Enter some text is a cell and select justified alignment (Ctrl+J). If the width of the column is more than the length of the text entered then the text is pushed to the right (like right alignment) which should not occur. Operating System: Windows 8 Version: 4.1.0.4 release
I do not reproduce under Linux (Ubuntu 12.04 x86-64). What kind of text did you use for your test? Right alignment is the default alignment for numbers while left alignment is the default alignment for text. Could you attach a test document with which you have this problem ? Best regards. JBF
Reproducible with LO 4.1.0.4 under Windows 7\Ubuntu 13.10\Fedora 19. The strange thing is that if Auto SpellCheck is on, and the cell contains a spelling error, it will align correctly. But as soon as Auto SpellCheck turned off, the wrong alignment shows again.
Not reproducible for me under Linux, even with auto-spellcheck turned off.
Created attachment 84055 [details] test-case @JBF: Please try with the attached spreadsheet.
Created attachment 84056 [details] screenshot (Fedora 19)
Oups, sorry, I read "centered" (why? ;-) ) instead of "justified". That said what should mean justified for a single word in a cell as in your example? Please try with several words in order to have several lines in the same cell and compare left align, right align and justified. Best regards. JBF
@JBF: I agree that justified alignment is useless for one-line text, but still it's a bug (although it might be a good reason to lower the priority). The text should align to left in that case. You can observe the correct alignment, if you open Writer, set the alignment to 'Justify' and type some text - the text will align to left. Same should happen in Calc. Anyway you should agree that turning Auto SpellCheck on and off, shouldn't have any effect on text alignment.
If the length of the text entered in a Full Justified cell is less than the column width then the text should be Left justified and not right justified. This problem was not there in the previous release.
Created attachment 84092 [details] Sample Calc file with formatting problem The attachments shows cells with full justified showing text with different alignments.
Indeed, in LO 4.0.5.1, justified text shorter than the cell length is left aligned while it is right aligned in LO 4.1. In LO 4.0.5.1 auto spellcheck does not affect this behavior while it does in LO 4.1. So I added the keyword "regression". Best regards. JBF
Here is a workaround: Go to Tools->Options...->Language Settings->Languages and enable 'Show UI elements for Bi-Directional writing', then you'll have RTL\LTR switch buttons on the Formatting toolbar. Now select the affected cell, and click on the LTR button (even though it's already pushed, just click on it again).
Thanks for the workaround Ashok
*** Bug 68847 has been marked as a duplicate of this bug. ***
Confirming that this still exists in 4.1.3 on Linux.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=045e037b7acde9d8e63fbb977c28b167e8815278 no default LTR mode does not mean RTL, fdo#68097 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.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=de67c6d6159c0801b0959d77c2c8a8b7fb148b03&h=libreoffice-4-1 no default LTR mode does not mean RTL, fdo#68097 It will be available in LibreOffice 4.1.4. 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.