balance with full account paths and unused accounts

[thielema]

I want to do the following: Write a balance report to a FODS file, load this FODS into LibreOffice Calc and append the table to another table, that accesses the numbers from the balance report. I want to access the balance report numbers with the LibreOffice function VLOOKUP (in the German version: SVERWEIS). For proper lookup, VLOOKUP needs the full account name, as provided by the list mode of hledger-balance. However, the list mode misses the amounts for parent accounts. Thus what I want is all the lines and numbers from the tree mode, but the account names written as in the list mode.

This wish is similar to https://github.com/simonmichael/hledger/issues/1550 but I do not want indentation. But I guess, VLOOKUP can be made to tolerate the indentation.

For now I work around the missing functionality by creating multiple balance reports in list mode, but with depths 2, 3, 4.

What I also need is that unused accounts are reported anyway, but with amount zero. This is for accounts that are unused in one year, but exist for transactions in other years. I consider an account existing if there is any transaction that refers to that account or if there is an explicit account declaration.