Forums Home / Spread / SpreadJS
Posted by: datta on 1 May 2019, 9:13 pm EST
datta
Posted 1 May 2019, 9:13 pm EST
Hi All,
I have a file generated by Apache POI api. If I imported this file in demo https://www.grapecity.com/demos/spread/JS/TutorialSample/#/demos/ExcelIO data is blank for first row and first column after import… Even in SpreadJS designer, data is blank for first row and first column. Attaching the file .
Also what I noticed is if I open this file in Microsoft excel and click on save and then if I import to SpreadJS then data is coming fine.
datta
Posted 1 May 2019, 9:15 pm EST
Sorry missed attachment. Attaching the file
sharad.tomer
Posted 5 May 2019, 5:25 pm EST
Hi,
We are able to replicate the issue with the attached excel file and hence we have forwarded it to the concerned team for further investigation of the issue. We will let you know regarding any updates on the issue. Internal tracking ID for the issue is #272276.
Regards
datta
Posted 7 May 2019, 5:53 pm EST
OK Thanks
sharad.tomer
Posted 9 May 2019, 3:33 pm EST
Hi,
Could you please let us know the Apache POI version you are using, also please try with the latest version of Apache POI and let us know if you are able to reproduce the issue with the latest version too.
Thanks
datta
Posted 17 May 2019, 11:12 pm EST
We are using POI version 3.15. OK I will try with latest version
datta
Posted 18 May 2019, 4:48 am EST
Tried with latest version of POI 4.1.0. I could replicate the issue with latest version as well
sharad.tomer
Posted 19 May 2019, 3:00 pm EST
Thanks for the additional info. We have forwarded it to the dev team.
datta
Posted 21 May 2019, 11:11 pm EST
One more observation: This issue happens only with string values with SXSSFWorkbook object to generate bytes. There won’t be issue if we use XSSFWorkbook . Below is the poi code which causes problem
public static void main(String[] args) throws IOException {
Workbook wb = new SXSSFWorkbook();
Sheet sheet = wb.createSheet("Sheet12");
Row row = sheet.createRow(0);
Cell cell = row.createCell(0);
cell.setCellValue("XYZ");
row.createCell(1).setCellValue(1234);
wb.write(new FileOutputStream(new File("Ganesha.xlsx")));
}
As you can see from above code I am using SXSSFWorkbook . If I replace it with XSSFWorkbook then genrated file opens correctly in SpreadJS. But unfortunately I cannot use XSSFWorkbook because I get OutOfMemoryException with large data
datta
Posted 21 May 2019, 11:51 pm EST
But I don’t think issue is with POI because Microsoft Excel opens the file perfectly and shows all the data
sharad.tomer
Posted 22 May 2019, 7:39 pm EST
Thank you for taking the time to further investigate the issue. We have forwarded your observations to the dev team.
datta
Posted 2 June 2019, 2:52 am EST
Hi this has become a critical bug for us. Any updates on this?
sharad.tomer
Posted 2 June 2019, 3:45 pm EST
Hi,
The issue is still with the devteam. We have asked the team for an update and will notify you once as soon as we get an update.
mackenzie.albitz
Posted 16 August 2019, 4:47 am EST
Hello,
This issue has been fixed in our V12.2.1 release here
http://cdn.grapecity.com/spreadjs/12.2.2/Files/SpreadJS.Release.12.2.2.zip
Regards,
Mackenzie
