Libre Office conditional formatting error when saving in xlsx format in 14.1
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?