I have been cleaning up my logbook and noticed a discrepancy when exporting the logbook in CSV format.
In the Expense fields, if the total Expense value is over $999.99, the field displays the thousands separator comma.
However, when this value is exported in CSV formatting, the thousands separator comma is treated as a column separator and skews the rest of that row's data.
See attached.
Previously, I was recording that field in hundreds, but obviously switched to exact (don't know why I changed)
In the Expense fields, if the total Expense value is over $999.99, the field displays the thousands separator comma.
However, when this value is exported in CSV formatting, the thousands separator comma is treated as a column separator and skews the rest of that row's data.
See attached.
Previously, I was recording that field in hundreds, but obviously switched to exact (don't know why I changed)