https://bz.apache.org/bugzilla/show_bug.cgi?id=61832
--- Comment #3 from Thamodharan <thamodharan...@gmail.com> ---
(In reply to Yegor Kozlov from comment #2)
> (In reply to Thamodharan from comment #1)
> > Created attachment 35566 [details]
> > Excel 2013 - Alert Message - While opening such large file
>
> Is it a 32 or 64-bit Excel ? I wonder if it matters.
>
> What happens if you click Yes and agree to recover as much as possible ?
>
> Also, try to disable automatic re-calculation of formulas in Options /
> Formulas / Calculation Options. By default, Excel recalculates all the
> formulas in a worksheet on open. You'd better turn it off for such large
> files.
Hi Yegor Kozlov,
FYI,
The above attached code works good, if the number of rows has been reduced to
0.3 million rows (i.e 300,000) and 150 column. I can open the file without any
issue or error. But the same doesn't happen for 0.4 or 0.5 million rows.
Response to your questions.,
1) Its 32-bit Excel 2013.
2) When I click Yes to recover, excel stops responding few minutes and later
i am able to retrieve all data without any loss, but I get repair error report
in an alert box. Please find new attachments related to it.
- Once, I save the repaired file, I didn't get the content issue pop up
when I open it again or later.
3) We just tried to insert string, no numeric or formulas are applied to the
workbook. Though, I tried your suggestion.
- Before generating the workbook, I turned off the formula in local excel
file and saved it, checked once again by opening, it remains turned off. But
once the code is executed successfully, the formula is again enabled
automatically. Same Content issue persist for large files.
Kindly help if there is any further solution.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
