Apache OpenOffice (AOO) Bugzilla – Issue 111843
No warning when saving to .xls spreadsheets with formulas pointing out of 256 columns limit
Last modified: 2013-01-29 21:54:09 UTC
Save a spreadsheet to .xls, with formulas (in cells placed in .xls file format range - 65.536 rows per 256 columns) pointing to cells out of .xls file format range => you will get a .xls file with broken links, without any alert. Possible solution: a messagebox warning the user about what's going to happen, similarly to the one provided for data in cells out of "65.536 rows per 256 columns" range. Possibly, the messagebox should pop up each time the user tries to save to .xls, otherwise we could get into the same issue noted here: http://www.openoffice.org/issues/show_bug.cgi?id=85945
*** Issue 111843 has been confirmed by votes. ***