Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Slackware This Forum is for the discussion of Slackware Linux.


  Search this Thread
Old 11-08-2013, 11:54 AM   #1
Registered: Oct 2003
Location: West Midlands, UK
Distribution: Slackware 14 (Server),OpenSuse 13.2 (Laptop & Desktop),, OpenSuse 13.2 on the wifes lappy
Posts: 775

Rep: Reputation: 97
Libre Office conditional formatting error when saving in xlsx format in 14.1

Hi all,

Running the latest and greatest here, thanks to Pat et al. However, having a problem with Libreoffice and conditional formatting.

I have a spreadsheet for work that basically shows peoples rota'd days on, hols, day off etc and normally when altering cell contents, say from being in to day off, I have set conditional formatting which changes the background colour based on cell content.

This works fine when reading and writing the SS in xls format. Unfortunately, our helpdesk have just upgraded to Window$ 8 (I know, bad idea), and the latest MSOffice 2013 and have requested the files in xlsx format.

Not a problem you would have thought, LibreOffice can do that. Except when saving the SS in xlsx format, all the conditional formatting seems to be deleted, which is a bit of a PITA, especially as the master file covers the whole year and is altered as and when to cover workloads, hol requests etc.

So, anyone come across this and found a solution other than suggesting work use LO?

Old 11-09-2013, 08:51 PM   #2
Senior Member
Registered: May 2004
Distribution: Slackware 14.1 64-bit with multilib
Posts: 2,124

Rep: Reputation: 255Reputation: 255Reputation: 255
Probably not the best answer, first though are you running the latest LibreOffice? I also updated to 14.1 , but I am running LO and 4.1.3 is out. I don't know whether or not that will solve your issue, but that is one step to try if you are not running that. If however you are running the latest offered by LO - it is still most likely the file itself that is not playing nice - maybe trying saving it as an older xlsx file, but that would most likely just throw other people off. No clear solution on this one, but perhaps the forums at LO might point you in a better direction, then again someone with more insight here hopefully might offer a better clue.
Old 11-10-2013, 03:40 AM   #3
Registered: Oct 2003
Location: West Midlands, UK
Distribution: Slackware 14 (Server),OpenSuse 13.2 (Laptop & Desktop),, OpenSuse 13.2 on the wifes lappy
Posts: 775

Original Poster
Rep: Reputation: 97
Thanks for the reply. As it happens, I am running the latest LO from Eric's build. I'll go with your suggestion though and put this on their forum.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Unoconv Convertor for RHEL 6 : Libre office & open office utility vishwajeet jagtap Linux - Software 0 02-15-2013 10:44 AM
Libre Office Error on PCLinux linman Linux - Software 10 12-10-2012 05:56 PM
LXer: Libre Office Initial plans for the free office suite [German] LXer Syndicated Linux News 2 11-14-2010 06:14 PM
.docx, .xlsx, .pptx, XML Office formats? microsoft/linux General 1 08-02-2005 02:30 PM
Format Problems Saving Star Office Docs in Word Format kkempter Linux - Software 4 08-27-2003 05:23 PM

All times are GMT -5. The time now is 03:42 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration