Inquiry about import excel date format (pqgrid 9.x)

[YONGHOO KIM]

Hello pqgrid
When I upload excel to pqgrid using pq.excelImport.getWorkbook api.
After uploaded the date data was changed.

For example, the excel data is 7/23/2023, when I upload into pqgrid, pqgrid data is expressed 7/22/2023.
It seems data changed by OS locale country date.

How can I upload the data as is ?

[paramvir]

Could you share a jsfiddle.

pq.excel.importXl API imports xlsx file into a js workbook.

What's the cell value and format in the javascript wotkbook?

[YONGHOO KIM]

Hi pqgrid

I'm testing with your sample  - https://paramquery.com/pro/demos/import-xlsx (toolbar import excel button)

I Uploaded the test result - pqgrid excel import.jpg
I hope you will find the problem.
If you think it is not an error, please guide to me how can I upload "Date" excel data as is.

test condition
1. Please make OS Timezone to another region which date is not today
2. Excel column type is "Date"

Thanks

[paramvir]

Ok got to reproduce it with Samoa timezone ( UTC + 13:00 ) and a different date ( 1/10/2010 ). Looking further into it.

[YONGHOO KIM]

Dear pqgrid

You mean, did you reproduce the problem ?
So, what is the next step ? is it a bug ? or not ?

[YONGHOO KIM]

Dear pqgrid

Please give me a more information.
I can not understand your comment.

Thanks 

[paramvir]

Dear Kim

The dates are supposed to be static similar to Excel, thanks for pointing out the issue. It would be fixed in upcoming version.

[YONGHOO KIM]

Thank you for your support,
Could you notice on this ticket, if it is fixed?

Thanks !

[YONGHOO KIM]

Dear PQGrid

When is the next release date ?

Thanks

[paramvir]

Dear Kim

Tentative date for next release is 21 Aug, 2023.

[YONGHOO KIM]

Thank you for your reply ! 

[YONGHOO KIM]

Hi, PQGrid

I wonder your patch plan about pqgrid 9.x  with bug fix my issue !
Our user continuously complain about this issue...

Please let me know your plan

Thanks

[paramvir]

This issue has been fixed, though the corrected version is not available for download yet.

Please check the fix in this example: https://paramquery.com/pro/demos/import_xlsx_tabs and let me know your findings.

Regards

[YONGHOO KIM]

 Dear PQgrid

We confirmed here (https://paramquery.com/pro/demos/import_xlsx_tabs) that this problem has been resolved and the import can be done without issues.
We need a release of this patch version.

When will we be able to download this?

 Best regards

 

[paramvir]

Dear Kim

Its release is anticipated on Monday

If it's urgent for you, then you can download fixed version from here:

https://paramquery.com/pro2/Content/js9.0.2/pqgrid.min.js

Regards