Spread 8.0.0.28 : Import XLSX file problem : missing cells

Posted by: ylaroye on 24 April 2020, 1:03 am EST

  • Posted 24 April 2020, 1:03 am EST

    Hello,

    When importing a XLSX file with OpenExcel2007File function, cells defined with a quote prefix (') are not imported.

    The attached zip file is a C++/MFC (VC6) example to compare importing file with the same content (XLSX and XLS files).
    The result is :
    - No data in column 11 when reading test.xlsx file
    - Data are available in column 11 when reading test.xls file
    TestImportSpread8.zip
  • Replied 29 April 2020, 7:29 pm EST

    Hi,

    Thank you for sharing the project.
    I could replicate the issue at my end as well. I have escalated it to the developers [internal tracking ID: 279074] and will let you know once there is any information from them.

    ~Pragati
  • Replied 18 May 2020, 8:04 pm EST

    Hi Pragati,

    Do you have any information on how long it will take to resolve this issue?

    Yves
  • Replied 19 May 2020, 7:36 pm EST

    Hi,

    Not yet. I have asked the developers for the same and will let you know once there is any information from them.

    Thanks.
  • Replied 24 June 2020, 7:03 pm EST

    Hi Pragati,

    It has been more than two months since I reported this problem. Do you have news from the development team?

    Yves
  • Replied 25 June 2020, 8:34 pm EST

    Hi,

    Let me ask them. Will get back to you shortly.

    Thanks.
  • Replied 28 July 2020, 2:35 am EST

    Hi Pragati,

    It has been more than three months since I reported this problem.
    Do you have news from the development team?

    Yves
  • Replied 29 July 2020, 10:03 pm EST

    Hi,

    The team could replicate the issue at their end too. They need some time to investigate and conclude this further. I will keep you updated for the progress made.

    Thanks.
  • Replied 31 August 2020, 9:11 pm EST

    Hi,

    It has been more than four months since I reported this problem.
    Do you know when we can have a patch ?

    Yves
  • Replied 3 September 2020, 4:04 pm EST

    Hi,

    Please give me some time to connect to the developers once and share an update.
    I will get back on this shortly.

    Thanks,
    Pragati
  • Replied 1 October 2020, 6:57 pm EST

    Hi,

    It has been more than five months since I reported this problem.
    When a patch will be available?

    Yves
  • Replied 5 October 2020, 10:20 pm EST

    Hi,

    The developers are actively working on the issue and fixed it internally. However it needs some more investigation and research from our end. I will let you know as it progresses.

    Thanks for your cooperation so far.
  • Replied 7 October 2020, 9:32 pm EST

    Hi,

    Here is the new Spread COM version 8.0.29 which includes this fix:
    https://cdn.grapecity.com/SpreadCOM/EN_SPREAD8_RA_8.0.29.2020.0928.0.zip

    Please note, this is not a public release. However you can verify the fix and use the build in your application. When the release will be officially posted, you may or may not want to uninstall/reinstall as the binaries won't change. So it shouldn't really be necessary unless you want the updated readme file.

    Thanks.
  • Replied 16 October 2020, 5:06 am EST

    Hi,

    I have installed version 8.0.29 and rebuilded my TestImportSpread8 project.
    But the problem is still there.
    The result is :
    - No data in column 11 when reading test.xlsx file
    - Data are available in column 11 when reading test.xls file

    Yves
    TestImportSpread8.zip
  • Replied 19 October 2020, 10:29 pm EST

    Hi,

    Let me try to replicate the issue at my end. Will get back to you soon.

    Thanks.
  • Replied 21 October 2020, 10:56 pm EST

    Hi,

    I tried reproducing the issue at my end, however the xlsx file could not be loaded. Can you please share a screenshot or a video demonstrating the behavior with the new version at your end?

    Thanks,
    Pragati
  • Replied 22 October 2020, 9:10 pm EST

    Hi Pragati,

    Can you open xlsx file in Excel?

    Regards,
    Yves
  • Replied 23 October 2020, 12:23 am EST

    Hi Pragati,

    I have added information about current version of Spread8 is used in the screen and have also added to the zip file a MP4 file to capture xls and xlsx loading file in the spread.
    In the xlsx format the column 11 is empty (no value) but the entering format is a date. It is not correct because if a field is starting with a quote that means we don't want to format data.
    You can also see the date format which is not the same in columns 12 and 13 : American format for xls file (mm/dd/yyyy) and French format for xlsx file (dd/mm/yyyy).
    TestImportSpread8_New.zip
  • Replied 26 October 2020, 7:56 pm EST

    Hi,

    Thanks for sharing the project and the video. I have forwarded the issue to the developers and will let you know once there is any information from them.

    Thanks,
    Pragati
  • Replied 9 November 2020, 4:24 am EST

    Hi Pragati,

    Do you have any news from developers?

    Regards,
    Yves
  • Replied 10 November 2020, 10:07 pm EST

    Hi,

    I have asked the developers for the same. Will get back to you once there is any information from them.

    Thanks.
  • Replied 14 December 2020, 9:28 pm EST

    Hi Pragati,

    Do you have any news from developers?

    Regards,
    Yves
  • Replied 17 December 2020, 6:07 pm EST

    Hi,

    The problem seems to some from the invalid format of the date values in the cells. The cells have the value "'122019" which is not a valid date value string that Spread COM can parse.

    Spread COM requires the date values to either follow the format for the cell, or conform to the Spread COM hardcoded date format of "MMDDYYYY" for the cell value.

    If I edit the XLSX and change the cells to have a valid date value "'12202019" (I assume this is the date that you intend but if that is not correct, you can correct this value to specify the correct date) in the format "MMDDYYYY" then it works to import those values correctly to the cells.

    Also, the reason that the XLS loads successfully with the invalid date values in the cell is that the cells are imported as EDIT cells instead of DATE cells. In that case, the value is not parsed as a date and instead treated as a string, and the "'" character is removed from the beginning of each string.

    I am not sure why the XLS loads the cells as EDIT cells instead of DATE cells; there might be some extra logic to check whether the value can be parsed as a date and to change the cell type to EDIT if it cannot, but the XLSX import does not have such logic and always tried to import the cells with date cell format as DATE cell type.

    Thanks,
    Pragati
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels