Issue while reading date format dd.mm.yyyy #3241

New Issue

anurag938 · 2024-10-21T09:44:30Z

anurag938 commented

2024-10-21 09:44:30 +00:00

We are facing issue of upload error for excel file in our fiori UI5 application.
We were using format dd.mm.yyyy and dd/mm/yyyy for dates. However since 2-3 months(probable) system in producing error in date format dd.mm.yyyy while if we are using dd/mm/yyyy everything is correct.
Although if we click OK ( to be pressed time = no of dates records in file ) it gives correct result.

But we want dd.mm.yyyy should also be applicable in the file.
Assistance required.

We are facing issue of upload error for excel file in our fiori UI5 application. We were using format dd.mm.yyyy and dd/mm/yyyy for dates. However since 2-3 months(probable) system in producing error in date format dd.mm.yyyy while if we are using dd/mm/yyyy everything is correct. Although if we click OK ( to be pressed time = no of dates records in file ) it gives correct result. But we want dd.mm.yyyy should also be applicable in the file. Assistance required.

Excel file issue date format.jpg

20 KiB

sheetjs commented

2024-10-21 11:58:21 +00:00

Can you share the file?

anurag938 commented

2024-10-21 12:44:48 +00:00

Please find the file which is being used in current version.

xlsx.full.min.zip

367 KiB

sheetjs commented

2024-10-21 12:53:22 +00:00

Can you share the original spreadsheet that is not being processed correctly?

Can you share the *original* spreadsheet that is not being processed correctly?

anurag938 commented

2024-10-21 13:07:48 +00:00

Here on Row J - Price-calculation-Valid- it should consider both format dd.mm.yyyy as well as dd/mm/yyyy. dd/mm/yyyy is being considered without any error however when using format dd.mm.yyyy its giving pop up error.

Price-List-Upload-Template.xlsx

13 KiB

sheetjs commented

2024-10-21 13:17:00 +00:00

You are processing an upload. In en-US Excel, Column J looks like the following screenshot:

You can test against https://docs.sheetjs.com/docs/#preview-a-workbook-on-your-device by jumping down to the live demo in the "Preview a workbook on your device" section, clicking "Choose File" (the left button) and selecting the file.

Both give the same result.

Looking at the cells themselves, the data is stored in plaintext (they are not Excel dates). Likely your backend needs to look for and process these text cells.

You are processing an upload. In en-US Excel, Column J looks like the following screenshot: ![i3241-J.png](/attachments/ea6add5a-78b8-41c9-9557-e7ff116693b7) You can test against https://docs.sheetjs.com/docs/#preview-a-workbook-on-your-device by jumping down to the live demo in the "Preview a workbook on your device" section, clicking "Choose File" (the left button) and selecting the file. ![i3241-sheetjs.png](/attachments/5049e529-b1eb-4142-b9cd-b1bedbadc4f6) Both give the same result. Looking at the cells themselves, the data is stored in plaintext (they are not Excel dates). Likely your backend needs to look for and process these text cells.

i3241-J.png

12 KiB

i3241-sheetjs.png

162 KiB

Sign in to join this conversation.