Created attachment 114782 [details] File with error reported and jpg to describe it Hello, I got some work xls files, that when opening in v4.3.6 version and 4.4.x versions (both 4.4.1 and latest 4.4.2) the values get lost and I see only zeros The sheet works ok with previous versions and especially ith 4.1.6.2, and 4.1.0.4, 4.1.0.2 which I tested. Will send you the file but because it's on Greek characters please see the attached jpg which shows where the numbers must appear and in the specific sheet If you need any additional info please do not hesitate to contact me Regards, Panagiotis
Please attach unlocked file.
(In reply to raal from comment #1) > Please attach unlocked file. Hi raal, thanks for your reply the file is unlocked, it is just in 7z compress format, along with a jpg file describing where the error occurs. Will send it again as simple file, Thanks, Panagiotis
Created attachment 114817 [details] xls with zero values in specific cells In specific cells, the values dissapear, and I have zeros on those cells. If I use LO ver 4.1.x, everything seems ok
I mean password in sheet.
(In reply to raal from comment #4) > I mean password in sheet. Raal, The sheet is NOT password protect ... it opens normally on all my pc's in work. (I've tested only in Win environments) It asks only for updating cells at start-up, but this is normal because it has links in other associated files .. "The file contains link to other files. Should they be updated ?? YES/NO ? " But the problem still occurs even if I update or not update the file at start-up. If you need further info you can contact me directly in my work email, and update the status when you are ready to open the file, Regards Panagiotis
I can confirm with Version: 4.4.4.0.0+ Build ID: 7ede9572e86a907f7cce8debba732d07b6b45923 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-4, Time: 2015-04-15_16:06:45 Version: 4.5.0.0.alpha0+ Build ID: 51e0d789c344547956764c3b5f0ef5a304f4e0aa TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-04-13_16:58:45 Works OK with LibreOffice 3.5.0 Build ID: d6cde02 -> regression
Thanks, raal. Let's set to NEW.
Migrating Whiteboard tags to Keywords: (bibisectRequest) [NinjaEdit]
To be honest having a complex sheet like this makes it 100x harder for a developer to actually figure out what's going on. It would help a lot if you made a much simpler version that was as cut down as possible. That being said, bibisect below. 560f398ecbc305b65a32a4ba0b9e4444761db889 is the first bad commit commit 560f398ecbc305b65a32a4ba0b9e4444761db889 Author: Bjoern Michaelsen <bjoern.michaelsen@canonical.com> Date: Wed Nov 27 04:52:19 2013 +0000 source-hash-dace560b350346b9f9a102ee602bb129a008bcfe commit dace560b350346b9f9a102ee602bb129a008bcfe Author: Caolán McNamara <caolanm@redhat.com> AuthorDate: Fri Oct 11 20:45:22 2013 +0100 Commit: Caolán McNamara <caolanm@redhat.com> CommitDate: Fri Oct 11 21:10:05 2013 +0100 CID#736194 out of bounds Change-Id: I236c2f51716bfebd0c132bbaed50c1f1ec811ffa :100644 100644 6e761d476a5f193388cf49d4a235be357f596c59 868adcf81ad9e8b7bf1c5b607608e9fc40410cd1 M autogen.log :100644 100644 0df89570ac01925eb0d92bd5cea375a1a6102e2e a74bef738e29c8062a7b26e82f3f98f84047a8a7 M ccache.log :100644 100644 ac150765aec93a2b2b2265bb72fbfae58043c9d4 18f2ed94c2f58a4e7a3fd7655d900b46f821dc47 M commitmsg :100644 100644 d9b7bc1a1c9b626c52ad13f1a42e3d11390d8c83 ea6a328f2ef10523d7195d77a3d5a840b892afcc M make.log :040000 040000 4ed0bc78fa4d8a698b6800cf0e8ff4c8c23dc2cf d2ef3a0d29599a9448f75c589c4671b3ad83a219 M opt # bad: [423a84c4f7068853974887d98442bc2a2d0cc91b] source-hash-c15927f20d4727c3b8de68497b6949e72f9e6e9e # good: [65fd30f5cb4cdd37995a33420ed8273c0a29bf00] source-hash-d6cde02dbce8c28c6af836e2dc1120f8a6ef9932 git bisect start 'latest' 'oldest' # good: [e02439a3d6297a1f5334fa558ddec5ef4212c574] source-hash-6b8393474974d2af7a2cb3c47b3d5c081b550bdb git bisect good e02439a3d6297a1f5334fa558ddec5ef4212c574 # bad: [4850941efe43ae800be5c76e1102ab80ac2c085d] source-hash-980a6e552502f02f12c15bfb1c9f8e6269499f4b git bisect bad 4850941efe43ae800be5c76e1102ab80ac2c085d # skip: [a043626b542eb8314218d7439534dce2fc325304] source-hash-9379a922c07df3cdb7d567cc88dfaaa39ead3681 git bisect skip a043626b542eb8314218d7439534dce2fc325304 # skip: [aba65c3e4c0df07e4909aeefb758cdb688242bf6] source-hash-827524abfb4b577d08276fde40929a9adfb7ff1a git bisect skip aba65c3e4c0df07e4909aeefb758cdb688242bf6 # skip: [aba65c3e4c0df07e4909aeefb758cdb688242bf6] source-hash-827524abfb4b577d08276fde40929a9adfb7ff1a git bisect skip aba65c3e4c0df07e4909aeefb758cdb688242bf6 # bad: [c81a8a0dcfc1ed095a80e4485c89dd0fcaf73f31] source-hash-c69ed33628ec0b7abf6296539cf280d6c4265930 git bisect bad c81a8a0dcfc1ed095a80e4485c89dd0fcaf73f31 # bad: [c81a8a0dcfc1ed095a80e4485c89dd0fcaf73f31] source-hash-c69ed33628ec0b7abf6296539cf280d6c4265930 git bisect bad c81a8a0dcfc1ed095a80e4485c89dd0fcaf73f31 # skip: [1d4980621741d3050a5fe61b247c157d769988f2] source-hash-89d01a7d8028ddb765e02c116d202a2435894217 git bisect skip 1d4980621741d3050a5fe61b247c157d769988f2 # good: [9daa289e178460daaafa4b3911031df5b8736218] source-hash-704292996a3731a61339b1a4a5c90c9403aa095f git bisect good 9daa289e178460daaafa4b3911031df5b8736218 # skip: [e014985ca41d06649533c7bedb4f029cbcb4ed6e] source-hash-af40ffdcef60c65437df4749c8bb2ad24356d1c2 git bisect skip e014985ca41d06649533c7bedb4f029cbcb4ed6e # good: [8988ebdd001d592339b7f8a64f1dcb4191c2396e] source-hash-beb43ed0942dcd5f14d3d49b407878866e3d248d git bisect good 8988ebdd001d592339b7f8a64f1dcb4191c2396e # bad: [d4eeea10e38fec832f258f1d4612f3cbaab2eacd] source-hash-3347f41a9b13c317c1d001e7ff501a4b0ee8f896 git bisect bad d4eeea10e38fec832f258f1d4612f3cbaab2eacd # bad: [f0f03d19b3f0418cef7eb8c5b3f060266781016f] source-hash-3ad12d1a540eeb54fbb34afc3b7a76bf9e3207c3 git bisect bad f0f03d19b3f0418cef7eb8c5b3f060266781016f # skip: [9c14d560e000ed66786dfab9f9faa60f158e207b] source-hash-51c647cf744480db7ce1c450f6668727cc75d74b git bisect skip 9c14d560e000ed66786dfab9f9faa60f158e207b # good: [7bb8b30c4ba0cb495d00562359b30a5c838b3da8] source-hash-0089d3ae9442f26695ae742f5fbdeeaf698861f2 git bisect good 7bb8b30c4ba0cb495d00562359b30a5c838b3da8 # good: [36f3dc5427eb2e1af3ddd629e0e7e199b7782fae] source-hash-21055f014c2d98f9f57ee81da9c54a4218d45e0d git bisect good 36f3dc5427eb2e1af3ddd629e0e7e199b7782fae # bad: [2a9ff869c5638dc5c3aa387d0fe55c3291c86288] source-hash-01b7e04172889cbc9e4ac404b105e18ddc062d6f git bisect bad 2a9ff869c5638dc5c3aa387d0fe55c3291c86288 # bad: [560f398ecbc305b65a32a4ba0b9e4444761db889] source-hash-dace560b350346b9f9a102ee602bb129a008bcfe git bisect bad 560f398ecbc305b65a32a4ba0b9e4444761db889 # first bad commit: [560f398ecbc305b65a32a4ba0b9e4444761db889] source-hash-dace560b350346b9f9a102ee602bb129a008bcfe
@Caolan, according to comment 9, this bug was introduced by one of your commits. Could you please take a look whenever you have time? Regards
Adding Cc: to Caolán McNamara
NOT reproduce with: - Version: 4.1.6.2 Build ID: 40ff705089295be5be0aae9b15123f687c05b0a Confirmed with - Version: 4.3.6.2 Build ID: d50a87b2e514536ed401c18000dad4660b6a169e NOT reproduce with - Version: 5.3.4.2 (x64) Build ID: f82d347ccc0be322489bf7da61d7e4ad13fe2ff3 Threads CPU : 4; Version de l'OS :Windows 6.1; UI Render : par défaut; Moteur de mise en page : nouveau; Locale : fr-FR (fr_FR); Calc: group ==> Works for me Change component to Calc