Created attachment 83406 [details] Calc file with text cells with "=" sign at start Bug occurs when opening an ods file in LO 4.1.0, which was previously saved under LO 4.0.4, that contains a text cell with an "=" sign at the start of the text. In LO 4.1.0, the text gets evaluated as a formula with the text following the "=" sign deleted and #NAME? appearing in the cell. The attached ods file will open correctly in LO 4.0.4 but be corrupted in LO 4.1.0.
Thank you for reporting this issue! I have been able to confirm the issue on: Version: 4.2.0.0.alpha0+Build ID: 09a4c4d176ff97ab8ff4027af83a549991667baf Date: Tue Jul 30 19:05:34 2013 +0300 Platform: Bodhi Linux 2.2 x64 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + As I've been able to confirm this problem I am marking as: New (confirmed) Major High Keywords - regression Whiteboard Status - bibisected + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link: https://wiki.documentfoundation.org/QA/BugTriage and join us on freenode at #libreoffice-qa There are also other ways to get involved including with marketing, UX, documentation, and of course developing - http://www.libreoffice.org/get-help/mailing-lists/. Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material
cafaff11f24078d636529c9ad9db7419b7275de1 is the first bad commit commit cafaff11f24078d636529c9ad9db7419b7275de1 Author: Jean-Baptiste Lallement <jean-baptiste.lallement@canonical.com> Date: Fri Apr 12 14:38:20 2013 +0000 source-hash-230f3ea249cd1f045ba30aced35935cdc32ddd87 commit 230f3ea249cd1f045ba30aced35935cdc32ddd87 Author: Kohei Yoshida <kohei.yoshida@gmail.com> AuthorDate: Wed Mar 20 18:07:17 2013 -0400 Commit: Kohei Yoshida <kohei.yoshida@gmail.com> CommitDate: Fri Mar 22 21:49:18 2013 -0400 This shouldn't be virtual. Change-Id: Ic15f96a71b7c315ab94ceed808c348cd6fe535df :100644 100644 bf148a878df3f708bb21dc2cb01cf6fd85a65a39 641838ee34b2e6f3f97ac5e93736aecec277dc58 M ccache.log :100644 100644 2ceabdf5f52c68b312c4d191325ca48dda432e7d 00bb7f9da42c7fca6699f1686a9ed88e4f67bf1a M commitmsg :100644 100644 3043396c7266bd801d5d92aaf9aa5dbf70d1168a abdc022a0f6653e6a8d6eec2d42b51ed9272945c M dev-install.log :100644 100644 785e1fd727536d721fa9879896894c22a7c830bf 905109be61578b5e886a8bda16d50e8c421f832b M make.log :040000 040000 c954cc412b0f30ce97762db2cbd0b19a6c8d7fb2 7aabad53e6b4d3492c3902e2bb904d06a3375184 M opt # bad: [4118d739dbd71e16057ea926ef3ef696025d3b67] source-hash-5bd6a5110bb812f82a81e73422a7b14851f84441 # good: [3e7462bd65e692bf0592d5b080b7716341b62a47] source-hash-1eddfce9894fd05315173744f495619189093dc7 git bisect start 'latest' 'oldest' # bad: [086c82fbd0a50dbf5dd28e8bcc7a6d702cea124e] source-hash-c74f2edfce221960fe546e88f2b3222d69d53598 git bisect bad 086c82fbd0a50dbf5dd28e8bcc7a6d702cea124e # good: [3367a5f4f0d1768c35ed32ac1956abf5c3ab4e0d] source-hash-cc9cd7af3beb13eede23c6c60506c6e8c329e29d git bisect good 3367a5f4f0d1768c35ed32ac1956abf5c3ab4e0d # good: [8609688fe6682504b3e6bc675e209db988d3acc1] source-hash-de69091d34d8102c0b56194d603ed9e66699d34c git bisect good 8609688fe6682504b3e6bc675e209db988d3acc1 # good: [097f48474f65f91045b392f1508d6c9b70ef8045] source-hash-5879775875cd769bca29ca87e758c13e34a7ff00 git bisect good 097f48474f65f91045b392f1508d6c9b70ef8045 # bad: [ff5ced2369e9a001066eda763779e38badb2c5af] source-hash-23c44b5745da8f0c63492e2246ffa41a439e3869 git bisect bad ff5ced2369e9a001066eda763779e38badb2c5af # bad: [1b5c886c1e7163164fc95fa2c2204e0228167669] source-hash-98c408356cffbf48fad596168399143e17321555 git bisect bad 1b5c886c1e7163164fc95fa2c2204e0228167669 # good: [1e74f6347415f51d6c83aaf4e9433a2cd86c5c47] source-hash-317a9b2e9463635b87f1c00fc11755dc9a4129f6 git bisect good 1e74f6347415f51d6c83aaf4e9433a2cd86c5c47 # bad: [cafaff11f24078d636529c9ad9db7419b7275de1] source-hash-230f3ea249cd1f045ba30aced35935cdc32ddd87 git bisect bad cafaff11f24078d636529c9ad9db7419b7275de1 # good: [783a75ef2d6a54610caac5ebccc37da6b8681f7c] source-hash-8d68b885b021a60af0fd199a167cbaeac1f15116 git bisect good 783a75ef2d6a54610caac5ebccc37da6b8681f7c
Hi, AFAICS, this has been resolved (by magic ;) ) in 4.1.1.2 (I dont have 4.1.1. installed.) Alan, can you pls have a look? thanks, Cor
no dev ever claimed to have this fixed => WORKSFORME
(In reply to comment #4) > no dev ever claimed to have this fixed => WORKSFORME Ah wel. DidNotWorkForMe in those few previous versions. So must haven been fixed, or the error reverted ;)
I have also been able to confirm that the bug no longer appears to be in version 4.1.1.2.
Migrating Whiteboard tags to Keywords: (bibisected) [NinjaEdit]