Created attachment 97646 [details] Spreadsheet in which cells spontaneously change and then crash LibreOffice I have a relatively complicated spreadsheet. I recently updated LibreOffice to the current version, LibreOffice_4.2.3_Win_x86, and now when I edit cells, the content of cells that I am NOT editing change from their previous formulas to "=", and LibreOffice crashes shortly thereafter. I have tried opening the file in Apache OpenOffice, saving it as a new version, and then opening that in LibreOffice. The problem remains. i have completely un-installed LibreOffice, removed my user profile, and re-installed LibreOffice. The problem remains. I have unzipped the LibreOffice document and examined the XML of the contents with xmllint. xmllint finds no errors in any of the XML files. I have created a new, blank LibreOffice spreadsheet, created and named all of the tabs from the original file, then copied and pasted the contents of each tab into the new spreadsheet tabs. The problem remains. I can edit the file fine in Apache OpenOffice. Apache OpenOffice works just fine.
Created attachment 97647 [details] Spreadsheet in which cells spontaneously change and then crash LibreOffice BBCSH_2.00b.ods
Hi Brandon, thanks for reporting. Works for me with: Win7x64Ultimate Versión: 4.2.3.3 Id. de compilación: 882f8a0a489bc99a9e60c7905a60226254cb6ff0 Does it happen with other files or only with this particular file?
That is the only file this happens with.
As far as I know. I have not really tested with other files.
Created attachment 97764 [details] Spreadsheet which crashes LibreOffice
I have opened the file in Apache OpenOffice and made numerous additional edits. No errors or crashes. I then opened it in LibreOffice 4.2.3.3, went to cell Advantages.K24, clicked in the cell name field (the box that displays "K24"), and typed "WAS_TRILBY" to define a name for this cell (this name means nothing, I just did it to see if LibreOffice would crash). I then pressed the ENTER key, and LibreOffice crashed. I have added this spreadsheet document to this bug report.
I have installed LibreOffice 4.2.4.1 (which is currently a "preview" version), and repeated the above steps: opened the file, clicked in cell Advantages.K24, clicked in the cell name field (the box that displays "K24"), typed "WAS_TRILBY" to define a name for this cell, then pressed the ENTER key. LibreOffice did NOT crash. Is it possible that LibreOffice 4.2.4.1 has fixed the bug?
Maybe something in the user profile, resolved when updating.
"Maybe something in the user profile" No. As I mentioned, I have deleted the user profile several times, and had also *completely* un-installed and re-installed LibreOffice 4.2.3.3 several times. It is NOT a user profile issue.
How do we know there was not something wrong in a clean profile with 4.2.3? In any case, there has been many patches, some of them about named ranges. I think we can close the bug for now, please if you are not agree or if you found again the issue, reopen it.
correct status is RESOLVED WORKSFORME since we don't know the exact committ which fixed it.