Batch Update Bugs

[Michella_Tony_Xie]

Hi, it seems there’s a bug on batch update.
The one that I realize is when I copy my invoices and paste it on the excel

I think the IssueDate column is messed, the date, month, and year was seperated in 3 cell, and it makes the Customer, BillingAddress, etc move to the next room,
and the date below 12, the date and months were confused.

and then the description text on my invoices,

This Should be “Tokopedia INV/XX/I/416598251” (but in the excel it seperated in several columns), and moves the next information to the next column.

[Tut]

These look like issues with Excel formatting preferences and pasting. The data copied from Manager is in TSV format, not Excel format.

[Michella_Tony_Xie]

I tried paste it on notes, and looks the same. I don’t thinks it’s an issues with excel.

[Patch]

@Michella_Tony_Xie

when I copy my invoices

@Michella_Tony_Xie

I think the IssueDate column is messed, the date, month, and year was seperated in 3 cell

Manger v 21.3.51 Windows works OK for me reading into LibreOffice Calc

I suspect you have set “/” as a separator during pasting of the file / clipboard contents