This is not really an answer but ... sometimes I have a problem with my Windows PC at work, and the IT person confirms the problem, but trouble shooting the problem will take longer than reinstalling ... so by analogy I suggest you rebuild the spreadsheet starting with File > New > Spreadsheet. Bring all you data and formulas into the new spreadsheet by Edit > Paste Special without Formats or Objects. Better yet just Paste Special "Values" (Text, Numbers, Date & Time) and recreate the formulas. Copy & Paste Special selected blocks of cell never entire columns. Recreate ALL formatting in the new spreadsheet. End by saving in ODS format. I know this might seem like overkill but sometimes particular spreadsheets "acquire" unique problems which are most easily resolved with a rebuild (reinstall). Consider it an opportunity to improve the worksheet with better functions available more clear layout & formatting.
On Sat, Feb 4, 2017 at 9:48 PM, John R. Sowden <jsow...@americansentry.net> wrote: > Why has my message regarding a "Fatal Error" as indicated by LibreOffice, > not been responded to? > > I have done a further test to find that even if I perform an F9 AND a > save, it still crashes. This seemed to have started when I turned off > "auto calc". Haven't tested by turning autocalc back on. > > John > > > > On 02/02/2017 07:14 PM, John R. Sowden wrote: > >> I have a 5 page spreadsheet, one page that gets used ofter, the others >> are not used much. Page 2 is a chart of accounts that a column in page 1 >> refers to often. Page 1 is about 400 lines long, maybe 10 columns wide. >> There is a date column, but I do not do date math, and no other cells refer >> to the date column. That said, after December, through April (FY), >> entering data takes about 30 seconds per cell (a long time in computer >> years). The solution I received from this list was to turn off all >> formatting (font, bold, not much more). That was unacceptable, so recently >> I tried turning off auto-calc, requiring I use F9 to recalc the sheet after >> additions/changes. It didn't help much. And, in the process, I found the >> following. >> >> On to the "verified fatal error": >> I have a group of about 10 lines that I want to delete. >> Lines above and below are referenced in page 3. >> I select and delete the lines and get the following fatal error: >> (three times (verified)) >> Fatal Error (title in a window) >> multi_type_vector::position#1321:block position not found! >> (logical pos=4294967275, block size=9. logical size=1048575) >> >> I had 5 sheets open, all 5 were damaged, and all 5 were recovered upon >> reentry. >> >> Ubuntu 16.04 and LO version 5.1.4 >> >> What I have not tried is to F9 and/or save before the delete. >> >> John >> >> >> > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns > ubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
