hickeng / financial

Repository containing financial spreadsheets
Other
207 stars 24 forks source link

Gain (h) shows as `0.00` in Excel and there is a circular reference warning on opening the sheet. #133

Closed hickeng closed 7 months ago

hickeng commented 8 months ago

New issue with v0.1.7 introduced by the toggle to show Cash only or Combined values for Form8949 Proceeds.

Excel complains about a circular reference... which is only sort of correct. The cells cross-reference, but only in mutually exclusive clauses which is why this isn't an issue in the Google Sheet.

This can be worked around in Desktop Excel by going to File->Options->Formulas->Enable iterative calculation and checking that box. The Options menu is at the bottom left when in File.

Iterative calculation isn't supported in the online version of Excel, so I'll need to see if I can work around this using intermediate columns.