A work around for these bugs is
This fixes the date corruption. Until Manager does this automatically for Bach update / create I strongly suggest prior to doing any Batch operations go to
Settings → Date & Number Format → Select a non ambiguous format such as
Then do the batch update as normal
- Copy to clipboard
- Paste into LibreOffice Calc
- During data import select all columns by selecting the first, move the scroll bar to the end and shift-click. Then choose type text. This eliminates number (such as trailing zeros) and date format changes in LibreOffice Calc.
Make required changes. Note if you need to do date calculations use DateValue
Similarly if you need to do calculation on numbers use Value() or NumberValue()
When your batch update contents are as you want them, delete the calculation fields or paste the values & formatting you want into a new page / spread sheet.
Then save that sheet as a CSV file
When saving you will be prompted for delimiters, choose field delimiter is tab
In windows explorer go to the file you just saved and choose “Open with…” and choose Notepad or similar. Select all (ctrl-A), and copy it
Paste this back into Managers Batch update.
Note the reference numbers are there now and multiline transactions show as lots of lines on this screen
Choose next to see the a summary of the actual editing changes which will occur. In this case only the reference numbers are added (no other changes are made to multiline transactions)
The summary of receipts shows only the expected changes. Dates and totals are all correct. Confirmed by looking at history and only expected changes have occurred
