Created attachment 116839 [details] Screenshot showing blank cells When viewing a .xlsx file I find that some of the cells are not displayed, the data is there in that I can move the cursor over and see contents. The original file can be found here: http://www.cps.gov.uk/publications/docs/vawg_2014_2015_tables.xlsx (Sorry for the subject matter, but it is where I found the problem). A screen shot shows the issue. I am running 64 bit CentOS 6. I see the same problem under CentOS 7 (libre office 4.2.6.3).
This also looks the same and works with LibreOffice v4.4.3 under Windows XP. The blank cells are a chart that doesn't even show up on Excel 2003 or 2010... You can click on the empty area and delete the object (with the Del key only) Moving the chart in LibreOffice 5.0.0.1 (where the chart shows the axes) causes the program to crash with Fatal Error: bad rational: zero denominator.
Bibisect 43all points to the range # first bad commit: [ba6eb41acb8df58f3009920f8ab8b32a3e1b764e] source-hash-ae4e4a11d4300f7448cb6bd170fcb034542caddc The most likely thing in there is the below commit. commit 44cfc7cb6533d827fd2d6e586d92c61d7d7f7a70 Author: Michael Meeks <michael.meeks@suse.com> Date: Tue Oct 9 12:22:23 2012 +0100 re-base on ALv2 code. Includes (at least) relevant parts of: ... (The later crash is a separate issue)
-> Crash mentioned in comment 1 split into bug 93382
Migrating Whiteboard tags to Keywords: (bibisected) [NinjaEdit]
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Still reproducible in Version: 6.0.0.0.alpha1+ Build ID: d76c4e5c9aaf8bd27ec97679bcaeba5b18aca493 CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); Calc: group
Hi Alain Williams, The file is no longer accesible. Could you please attach it in here ?
The document is at the URL below. I still see the issue (Version: 4.3.7.2 Build ID: 4.3.7.2-2.el6_9.1) running on CentOS 6 (64 bit) https://www.cps.gov.uk/sites/default/files/documents/publications/vawg_2016_2017_tables.xlsxhttps://www.cps.gov.uk/sites/default/files/documents/publications/vawg_2016_2017_tables.xlsxhttps://www.cps.gov.uk/sites/default/files/documents/publications/vawg_2016_2017_tables.xlsx
Sorry: my mouse triple clicked, here is a saner URL: https://www.cps.gov.uk/sites/default/files/documents/publications/vawg_2016_2017_tables.xlsx
Created attachment 139447 [details] sample file
still repro in Version: 6.3.0.0.alpha0+ (x64) Build ID: 47c498417248444cab4e8f597ddeec4e0d585a71 CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-02-21_08:39:21 Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded
This seems to be gone in very current bibisect-win32-6.3 : Version: 6.3.0.0.alpha0+ Build ID: c5c425296debb2fbd67af8ec29f87e285d08575f CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; Locale: hu-HU (hu_HU); UI-Language: en-US Calc: threaded Bibisect says this commit did the trick: https://cgit.freedesktop.org/libreoffice/core/commit/?id=d0119ff7f2c68aa05286bd303128f3a69c6bbd6a $ git bisect log # bad: [836932d586429932ed61dd6490f30db26ee9c24f] source c5c425296debb2fbd67af8ec29f87e285d08575f # good: [ea94942caaf195b8d8b2d5c2abb523359ab390e7] source a20a2d7e0d28658f2d9089da076961a599833a28 git bisect start 'origin/master' 'oldest' # good: [c9f282d8b3525b381dd8bd21663c48067237498a] source 0c314c90a7af7d9e855e3cacfd8e7a31ed065a26 git bisect good c9f282d8b3525b381dd8bd21663c48067237498a # good: [ac38d0460dd17e5c6723ae3b7dbdf02cb0f136fc] source 5355f0d691cdefcebec25a555344d5cd78605c71 git bisect good ac38d0460dd17e5c6723ae3b7dbdf02cb0f136fc # good: [0e4b1d743a8e6dec583e9931abe76fa268647b26] source b9e75051807b807a6c9b96433390e09abaf38c24 git bisect good 0e4b1d743a8e6dec583e9931abe76fa268647b26 # good: [b05b033002039a55e13ce8f9f14ff31963da5fa0] source 55e28737e973b40f72d398c9bb7a4a41307eb562 git bisect good b05b033002039a55e13ce8f9f14ff31963da5fa0 # good: [b81d0a51785cf0e78f6e82100356aefc7fc8978d] source ed423da9d968d6f534a6d4d27b45aa96cd5b47d4 git bisect good b81d0a51785cf0e78f6e82100356aefc7fc8978d # good: [1f7d629537c781404f8e9b1c82174dddc7832f37] source 0e86f0c79e29bde4a29ef77046621398b6bede63 git bisect good 1f7d629537c781404f8e9b1c82174dddc7832f37 # good: [bdcbbf9c3b6c559e9c35e9429fc72c46c0892e12] source 258761507b08f6965c7f57b26fa5a02a692903a1 git bisect good bdcbbf9c3b6c559e9c35e9429fc72c46c0892e12 # bad: [ef5f4d77973c354279c5473946661a69366c9a85] source 3d6e2081f0ab71ad4515fed864c3f36566e466c3 git bisect bad ef5f4d77973c354279c5473946661a69366c9a85 # good: [765a74f8a193e14bd16d11f85e634ecbdaa0f1ca] source bfdb5a2d96483907cd4b757398b3df159a9e7af2 git bisect good 765a74f8a193e14bd16d11f85e634ecbdaa0f1ca # good: [9a0bda924b953dc46cfe15e60d5f48fc55777688] source 59278fa913116482c7d02e0729487ccd153545ae git bisect good 9a0bda924b953dc46cfe15e60d5f48fc55777688 # bad: [aebad265fb4d7655ea1a070c0577e2644c65c9dd] source d27ad84ec7a0aafb07d6a6152c686f4bc802f661 git bisect bad aebad265fb4d7655ea1a070c0577e2644c65c9dd # bad: [ca5a38f2bf6bb2013d4ea1436625c26358f8eadc] source d0119ff7f2c68aa05286bd303128f3a69c6bbd6a git bisect bad ca5a38f2bf6bb2013d4ea1436625c26358f8eadc # good: [8c39f73d71c838a4890233f40f91bec3f204ad25] source 5218ca22b472a80969a715e38d7cb8d052be4b6a git bisect good 8c39f73d71c838a4890233f40f91bec3f204ad25 # first bad commit: [ca5a38f2bf6bb2013d4ea1436625c26358f8eadc] source d0119ff7f2c68aa05286bd303128f3a69c6bbd6a
Indeed! Fixed in Version: 6.3.0.0.alpha0+ Build ID: 630db80d17616d635cf2e5f1d5a0852428b794a3 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded