ParamQuery grid support forum

General Category => Bug Report => Topic started by: YONGHOO KIM on August 01, 2023, 09:56:46 am

Title: Inquiry about import excel date format (pqgrid 9.x)
Post by: YONGHOO KIM on August 01, 2023, 09:56:46 am

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 ?

Title: Re: Inquiry about import excel date format (pqgrid 9.x)
Post by: paramvir on August 01, 2023, 11:55:54 am

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?

Title: Re: Inquiry about import excel date format (pqgrid 9.x)
Post by: YONGHOO KIM on August 02, 2023, 01:18:44 pm

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

Title: Re: Inquiry about import excel date format (pqgrid 9.x)
Post by: paramvir on August 03, 2023, 07:34:20 am

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

Title: Re: Inquiry about import excel date format (pqgrid 9.x)
Post by: YONGHOO KIM on August 04, 2023, 11:18:54 am

Dear pqgrid

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

Title: Re: Inquiry about import excel date format (pqgrid 9.x)
Post by: YONGHOO KIM on August 08, 2023, 04:29:10 am

Dear pqgrid

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

Thanks  ;)

Title: Re: Inquiry about import excel date format (pqgrid 9.x)
Post by: paramvir on August 08, 2023, 12:18:40 pm

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.

Title: Re: Inquiry about import excel date format (pqgrid 9.x)
Post by: YONGHOO KIM on August 09, 2023, 06:10:37 am

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

Thanks !

Title: Re: Inquiry about import excel date format (pqgrid 9.x)
Post by: YONGHOO KIM on August 09, 2023, 01:31:46 pm

Dear PQGrid

When is the next release date ?

Thanks

Title: Re: Inquiry about import excel date format (pqgrid 9.x)
Post by: paramvir on August 09, 2023, 01:41:16 pm

Dear Kim

Tentative date for next release is 21 Aug, 2023.

Title: Re: Inquiry about import excel date format (pqgrid 9.x)
Post by: YONGHOO KIM on August 10, 2023, 10:40:50 am

Thank you for your reply !  :)

Title: Re: Inquiry about import excel date format (pqgrid 9.x)
Post by: YONGHOO KIM on August 30, 2023, 12:47:25 pm

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

Title: Re: Inquiry about import excel date format (pqgrid 9.x)
Post by: paramvir on August 30, 2023, 02:00:34 pm

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

Title: Re: Inquiry about import excel date format (pqgrid 9.x)
Post by: YONGHOO KIM on September 06, 2023, 12:16:27 pm

 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

 

Title: Re: Inquiry about import excel date format (pqgrid 9.x)
Post by: paramvir on September 07, 2023, 03:47:41 pm

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