https://bugs.freedesktop.org/show_bug.cgi?id=62031
--- Comment #17 from [email protected] --- I originally had looked to obtain HELP with a PROBLEM but your site does not allow for that or, at least, I could not find it hence my question had to be placed in the "BUG" section. Note that most of my writing refers to PROBLEM reverting to 'BUG" only when I was told it was "IMPOSSIBLE." Question remains how a number was entered in that cell when I never even remotely addressed that cell. The original has "$519" at that location which was converted to "0" when I deleted the 13 x 29 spreadsheet data, only those 377 cells, communicating that somehow a formula "problem" instructed loading that cell then, instead of deleting, it changed the value to "0" instead of "$0" which would be expected since they were currency numbers and currency is shown in the original. Think about it, 13 x 29 places a value in "last row 1048576" but I never worked with other than simple SUM formulas. SUM formulas can place it's result wherever the user wishes (within limits) but with only one exception I higlighted what I wanted added then clicked on the SUM icon of the spreadsheet. The one exception was copied and pasted 10 times which when their value was deleted should have generated as many as 10 cells with "$0" but only one with "0" appeared. And while it may not be a BUG to you it was/is a problem. True the spreadsheet was a modified copy of a 2012 even smaller spreadsheet without the "custom" formula but that is as far back as it goes, since the 2012 was a new spreadsheet of the 3.x.x.x version. My money remains on a related problem to the upgrade -- a conflict between a sheet created in the prior version being modified after an upgrade -- but having obtained a solution I don't care. TY, Amos From: [email protected] To: [email protected] Subject: [Bug 62031] FORMATTING: Insert - Row fails with error message Date: Sun, 10 Mar 2013 18:03:01 +0000 Comment # 14 on bug 62031 from Rainer Bielefeld The sample document contains data in last row 1048576, a formula in C1048576. Simply try <control+end> and use arrow left until you see the "0"! So it's expected that you can't insert a row, also not with 3.6 or more early versions or OOo. So indeed not a bug. @challengnow: Deleting that last row with menu 'Edit -> Delete Cells' after you have selected it with a click on the row header will heal your problem. Or simply <del> with cell cursor around C1048576 Probably not related to your problem: Your document still contains several invalid ODF (may be it has a long history starting with old OOo versions), what even can not be healed by saving document after Menu 'Tools -> Options -> Load/Save -> ODF-Type 1.2 (instead of 1.2 Extended"). Normally that will not cause trouble, but using different software editing the same document might be dangerous. You are receiving this mail because: You reported the bug. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
