Created attachment 83649 [details] archive 1. Some cells are shifted right, but not all. 2. Cell's lines are not hided behid the text. See screen
Well, it is reproducible with 3.3.0.4 - 4.1.0.4 and AOO 4.0 under Win7x64. The spreadsheet is formatted manually. The text that looks shifted compared to MS Excel, is actually written all in the column B, and is formatted as aligned to left with shift. The shift value in MS Excel is 5. LO imports it with shift value 50pt. It looks like these values are not in a good accordance. This is the bug. The text in row 9 is in two cells: B9 and C9. The text in rows 21-22 is in cells B22 and B23, but is aligned left without shift, and there is a number of spaces before text in each cell.
Created attachment 83658 [details] Screenshots of MS Excel and LO 4.1.0.4 under Win7x64
The same problem with incorrect shift is reported for XLSX (see bug 67779).
LO 4.2 hasn't this bug fix
** 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 (4.4.2 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 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 your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-05-02
Still reproducible with Version: 4.4.3.2 Build ID: 88805f81e9fe61362df02b9941de8e38a9b5fd16 Locale: ru_RU under Win7x64
** 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.1.5 or 5.2.1 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-20160920
This bug was resolved with LibreOffice 5.2
(In reply to Bartosz from comment #8) > This bug was resolved with LibreOffice 5.2 No, it was not. Still the same shift.
The shift from left in LO is much more than in Excel. According to ISO/IEC 29500-1, the "indent" attribute of "alignment" element is an integer that is number of triple spaces in the normal font of the cell. ODF expresses indent in normal length units. So, the conversion from Excel indent "5" triple spaces of cell's font to "50pt" seems to be incorrect.
Could you please also attach the .xlsx file in which described issue appears?
Created attachment 130616 [details] Screenshot of document on LO 5.2 It looks like there is not issue with LibreOffice 5.2 (Ubuntu 16.10), but there is an wrong formating on Master (LO 5.4). Could you please confirm it?
Created attachment 130617 [details] Screenshot of document on LO 5.2 On LO 5.4 the issues is still there. Looks like it is regression.
Created attachment 130621 [details] The bug doc converted to XLSX (In reply to Bartosz from comment #11) > Could you please also attach the .xlsx file in which described issue appears? Here it is - and shows the same.
Created attachment 130622 [details] 5.2.3.2 on Windows It shows the same. I suppose that the difference is because of some font substitution under Linux (and it's apparently different on two screenshots from Bartosz - either different systems, or differences between versions). With this regard, I must add that my screenshot is taken on the same system where Excel shows the same view as in attachment 83649 [details], so all fonts are OK.
Created attachment 130631 [details] .xlsx file with one row with incorrect alignment
** 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
This was resolved in version 7.2.3 and 7.3.0 in bug 130104. Please update to the current supported versions (e.g. 7.3.6 or 7.4.1) and retest. *** This bug has been marked as a duplicate of bug 130104 ***