Sheet tab colors at the bottom of the screen do not save correctly. If I open an Excel file in LO it will open correctly. I then save the file, keeping the same file type, and when I then reopen it, the colors on the bottom sheet tabs are no longer there.
I can reproduce this in 4.0 beta 2 with windows XP. Example attached. Steps to reproduce: 1. open the attached file in libreoffice 2. edit the file (e.g. type 1 in cell A1) 3. save the file (same file type) 4. close the file 5. reopen the file in libreoffice or excel Current behaviour: no tab colours in either program Expected behaviour: tab colour should be retained.
Created attachment 71941 [details] example excel spreadsheet with tab colours
*** Bug 61639 has been marked as a duplicate of this bug. ***
Even easier to reproduce: * Open Calc * Right click on tab * Click 'Tab color...' * Change color -> Ok * Save file as xls(x) Result: tab color lost Reproduced using LibreOffice 4.0.1.1 rc on Linux Mint 14 x64
*** Bug 62802 has been marked as a duplicate of this bug. ***
Tab colors save fine to xls. They are lost only when saving to xlsx. I used the latest master.
I'll take this.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5063f31c248fd3c16115582a1e3aef182257a225 fdo#58307: Export sheet tab colors to xlsx. 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.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=90af4f50e8673975e63c928aa47fbc18eb160046 fdo#58307: Write export test for this to ensure it won't go away... 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.
Fixed. This was one of those TODO items as it turned out.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=00b7d4c8043a0c6b9e267f0fd5d7389128628ca0&h=libreoffice-4-2 fdo#58307: Export sheet tab colors to xlsx. It will be available in LibreOffice 4.2.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.
*** Bug 75275 has been marked as a duplicate of this bug. ***