Problem description: When a new sheet is open, by default the page direction will be from left to right. However, if you chose to change it from the buttons appearing at the top of the sheet, to become from right to Left instead, then save and close the document, and when the same document is opened again the direction shall be reverted to default from left to right. Steps to reproduce: 1. change the direction from left to right to become from right to left 2. save and close the document 3. open the saved document again Current behavior: The direction of the sheet is set to default from left to right Expected behavior: The action of changing the direction from left to right to become from right to left should be saved and launched whenever the document is opened again. Operating System: Ubuntu Last worked in: 3.5.4 release
Not a BASIC bug, changed title and component. Could not figure out how to change LTR -> RTL without changing language and can't be sure whether this is Writer or Calc and also unsure whether this is text direction or text alignment. Either way it is not a bug in BASIC language system.
Created attachment 71963 [details] A Calc sheet to explain the case Attached file will answer all questions raised on this bug.
I'm attaching a Libreoffice Calc sheet to explain the bug and answer the question raised. The Calc sheet once been entered by the Arabic language and the direction (as shown by the attached sheet) is changed to right to left instead of the default left to right then after saving the document and closing it, once opened again it will open by default direction from left to right making a change in the text entered and without saving the changes made before closing. The Calc file is saved as XLSX on windows partition.
Testing on Ubuntu 12.04.3 + LO 4.1.2.3 and LO 3.5.7.2 Following OP's steps to reproduce: (NOTE: I don't have the icons indicated in the screenshot (see xlsx file), so I had to set that up: a) Go to Tools -> Options -> Languages -> Language Settings b) In the 'Enhanced Language Support' section, check the box for 'Show UI Elements for Bi-Directional writing' c) I had to hide/show the Formatting toolbar (View -> Toolbars -> Formatting) to get the new icons to appear ) The particular icons you see may have a very different appearance to what's pictured in the sample document. The icons I see look like a fountain pen with a light green nib with left or right white arrows behind. Here's another set of icons (see the R-T-L/L-T-R buttons mentioned at the bottom of the page): https://help.libreoffice.org/Writer/Formatting_Bar 1. change the direction from left to right to become from right to left I changed several rows from LTR to RTL. Note that the content in all of the cells appears to be aligning to the right of the cell (even though the formatting toolbar indicates no alignment set), but when the cell is changed to RTL, the text itself does flip in direction. 2. save and close the document I got a warning about saving in Word format (some formatting may be lost..) 3. open the saved document again All of the cells I had set to RTL are now set back to LTR. ---- RESULTS: I see the same behavior in LO 4.1.2.3 and LO 3.5.7.2 I'm able to confirm the bug, but unable to confirm this is a regression. Changing 'regression' -> 'PossibleRegression' and marking as NEW.
** 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.1 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-04-01
So the issue persists and its an xlsx only export problem (doesnt happen with xls or ods) as the RTL state of a cell isnt saved. XLSX has 3 states for cell text direction : Context, LTR and RTL. When LO exports to XLSX it doesnt save the LTR or RTL states. Version: 5.0.0.0.alpha1+ Build ID: badec7478035008f514e0976a94438fe2e32dc40 TinderBox: Linux-rpm_deb-x86@45-TDF, Branch:master, Time: 2015-04-22_00:50:58
Created attachment 115079 [details] sample xlsx file with all 3 states created in excel 2010
I can reproduce this issue with Version: 5.1.0.0.alpha1+ <alignment readingOrder="2"> was not exported
*** Bug 58181 has been marked as a duplicate of this bug. ***
Migrating Whiteboard tags to Keywords: (filter:xlsx, possibleRegression)
PriyankaGaikwad committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=01575244271cc7e0156e766b91750c4c147a0f8e tdf#58122 FILESAVE: XLSX - Cell RTL direction state not saved It will be available in 5.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.
Hi Priyanka, I tested attachment 115079 [details] on master and the english cells (B3:B5) preserved the direction attributes, but the arabic cells (B6:B8) didnt. Version: 5.2.0.0.alpha0+ Build ID: d95d9d7f908419f397941ef60ac6ced3261c9b87 CPU Threads: 2; OS Version: Linux 4.2; UI Render: default; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-01-19_00:40:21 Locale: en-US (en_US.UTF-8)
Hi Priyanka, I'm setting this ticket back to NEW as it has been inactive for more than 3 months. Feel free to assign it back to you if you're still working on this. Regards
Seems fixed now. Version: 6.0.0.0.alpha0+ Build ID: 34c77d4bf3d2924c4ad26728d4c491b393fa0fc8 CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); Calc: group