I accidentally created a circular reference in a 650K spreadsheet. I happened to insert a number of rows which pushed a series of SUBTOTAL functions of the screen and I forgot about them. Since upgrading to the 4.x series, I'd get occasional "bad allocation" errors when attempting to open the file. I had numerous conditional formatting instances set. Removing those seemed to help, but the error would randomly come back. In the most recent set of crashes, I downgraded to version 3.5.1.2. This version loaded the file. I then saved it as an XLS file and reloaded in Excel 2000. The file loaded, but the EXCEL identified the circular references. Deleted the circular referencing cells and resaved. File now loads in Calc without the "Bad Allocation" error. There should be some way to load a file with a Circular Reference problem so that it can be removed.
Hi @marco, thanks for reporting. If was possible better attach a sample file. Maybe disable the option for recalculate on load can help. Menu/Tools/Options/LibreOffice calc/Formula - Recalculation on file load. Option for manage circular references: Menu/Tools/Options/LibreOffice calc/calculate - Iterative references. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
(In reply to m.a.riosv from comment #1) > Hi @marco, thanks for reporting. > > If was possible better attach a sample file. Kind of hard to attach a sample file since the data is sensitive & I'm not sure I could replicate a sample file. I'll try. Side note, after resaving into Excel format, I discovered I could no longer save into an ODS format. After some poking, I removed all conditional formatting and now things really seem to have stabilized. Conditional formatting, although visually helpful, seems to generate havok.
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/FDO/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team This NEEDINFO message was generated on: 2015-09-03
Hi @marco if you are not agree on closing, please reopen it.