LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices

Reply
 
Search this Thread
Old 11-08-2013, 10:54 AM   #1
vdemuth
Member
 
Registered: Oct 2003
Location: West Midlands, UK
Distribution: Slackware 14 (Server),Suse 13.1 (Desktop),, Mepis on the wifes lappy
Posts: 766

Rep: Reputation: 92
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?

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

Rep: Reputation: 193Reputation: 193
Probably not the best answer, first though are you running the latest LibreOffice? I also updated to 14.1 , but I am running LO 4.0.2.2 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, 02:40 AM   #3
vdemuth
Member
 
Registered: Oct 2003
Location: West Midlands, UK
Distribution: Slackware 14 (Server),Suse 13.1 (Desktop),, Mepis on the wifes lappy
Posts: 766

Original Poster
Rep: Reputation: 92
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.
 
  


Reply


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 09:44 AM
Libre Office Error on PCLinux linman Linux - Software 10 12-10-2012 04:56 PM
LXer: Libre Office Initial plans for the free office suite [German] LXer Syndicated Linux News 2 11-14-2010 05:14 PM
.docx, .xlsx, .pptx, XML Office formats? microsoft/linux General 1 08-02-2005 01:30 PM
Format Problems Saving Star Office Docs in Word Format kkempter Linux - Software 4 08-27-2003 04:23 PM


All times are GMT -5. The time now is 09:10 AM.

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