Created attachment 81270 [details] Sample File I had file that created with MSO. Currency format misinterpreted by LO so the currency overlap left column. Steps to reproduce; 1. Open attached file 2. See that values on column C have currency (Rp) that overlap column B That format is: _([$Rp-421]* #.##0,00_);_([$Rp-421]* \(#.##0,00\);_([$Rp-421]* -??_);_(@_) Cell C6 & C7 had misallignment that I've been reported on Bug 64518. Perhaps also related to Bug 48810 This bug still happen on LO 4.0.4.2 (Win7 Home Premium 32bit)
Change version to 3.6.6.2 (oldest known version)
hi ign_christian, I do not see the overlap of Rp with column B in LibreOffice 3661, 4042 and 4101 on Ubuntu
Hi, Indeed. I fail to reproduce this using Linux Mint 15 x64 with LibreOffice Version: 4.2.0.0.alpha0+ Build ID: 87c50e75633f31b54bfa1758cc0921ac53c6b418 So as far I can see -> Windows only :-). Marking it as such. Kind regards, Joren
Thank you for your bug report, I CAN't reproduce this bug running LibreOffice Version: 4.1.0.1 Build ID: 1b3956717a60d6ac35b133d7b0a0f5eb55e9155 on Mac osx 10.8.4. I also can't reproduce this bug running LibreOffice 4.1.0.0 beta2 and 4.0.4.2 on Windows 7.
So...something wrong with my laptop :( Ok i'll try to reset user profile & clean install LO I've just checked that on OOO 3.3.0 (Win XP) not happen too
Yes, currency problem solved with resetting user profile :) Thanks all for testing
Still happen on LO 4.0.5.1 even after resetting user profile. I don't have any idea with the inconsistent behavior..perhaps because Indonesian language setting? (but I'm using standard English installation) Same behavior also happen with XLSX file (if required i will file new bug report).
Created attachment 84490 [details] Screenshot from LO 4.0.5.1
Hey Christian, is this bug still valid / reproducible with the latest pre-release 4.2.0.1: http://www.libreoffice.org/download/pre-releases/ Should this be still reproducible for you with the latest LO release please set this bug back to UNCONFIRMED. Should this issue be solved set it to WORKSFORME. Setting to NEEDINFO until more detail is provided.
Hi..unfortunately this bug still exist & same behavior. Tested on LO 4.2.3.3 (Ubuntu 12.04 x86)
Christian, just a ping. Does this one here persist with 4.3RC1? http://www.libreoffice.org/download/pre-releases/ If so, please back to unconfirmed, thanks.
(In reply to comment #11) Thanks for the ping..encourages me to observe more deeply :) I just found what is responsible for the problem: "Use printer metrics for text formatting" enabled. I always enable that setting though I don't really know the actual usability. Since LO 3.6.x until 4.3.0.1, that setting generates that weird problem: overlapping / misalignment. But that setting doesn't generate the problem in LO 3.5.7.2, OOO 3.3.0, AOO 4.1.0. I'll observe the "printer metrics" thing in other bugs.
Hi Christian, so I've check that setting in my version 4.3.0.4 Unbuntu 14.04 and the text doesn't overlap. Left as unconfirmed - Sophie
Hi, Sorry to be too late, but can you see also Bug 78503 - EDITING: Some cells overlap the cell to the left when Calc option "Use printer metrics for text formatting" is enable. Regards, Jacques
Unfortunately it's still not fix, same behavior in 4.3.0.4 and 4.3.1.0.0+ Time: 2014-07-30_10:54:10 I think it's only reproducible with particular currency format like in screenshot & "Use printer metrics for text formatting" is enabled. Sophie, would you mind checking what is the currency format in which you can't reproduce this issue? Ok Jacques, I'll see that
(In reply to ign_christian from comment #15) > Unfortunately it's still not fix, same behavior in 4.3.0.4 and 4.3.1.0.0+ > Time: 2014-07-30_10:54:10 > > I think it's only reproducible with particular currency format like in > screenshot & "Use printer metrics for text formatting" is enabled. > Can't reproduce. Win 7 64-bit Version: 4.4.0.0.alpha1+ Build ID: b7d8a58ff2698ffc6e22943f64aa97c5ea253bd9 TinderBox: Win-x86@42, Branch:master, Time: 2014-11-05_00:40:38
I can reproduce with LO 4.3.2, win7. For reproduce is needed to set national settings to Indonesian and set "Use printer metrics for text formatting"
** 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 on a currently supported version of LibreOffice (5.0.4 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) 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: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-12-20
*** Bug 64518 has been marked as a duplicate of this bug. ***
** 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 on a currently supported version of LibreOffice (5.2.7 or 5.3.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) 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: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170522
*** Bug 117018 has been marked as a duplicate of this bug. ***
Aron Budea committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=93e9a3e2b545c853f53ffe28d2795f55ad29f304 tdf#66089 tdf#105720: only rely on bPixelToLogic It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
With the above commit the spreadsheet looks fine to me after the instructions in comment 17. Backport to 6.1 is in gerrit.
Aron Budea committed a patch related to this issue. It has been pushed to "libreoffice-6-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b86a8857e6488bac1224a9eed471bcf930994399&h=libreoffice-6-1 tdf#66089 tdf#105720: only rely on bPixelToLogic It will be available in 6.1.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Works as expected now with LO 6.2.0.0.alpha0+ Build ID: 4a82543b3419339ae554485c582a80c41a57c417 CPU threads: 2; OS: Windows 6.1; UI render: default; TinderBox: Win-x86@42, Branch:master, Time: 2018-06-22_06:30:14 Locale: fr-FR (fr_FR); Calc: CL Thank you very much, Aron.