LO does not follow the OpenDocument v1.2 standard for conditional number formats. The Excel-style format "[<>0][Red]General;General" should be represented by the following ods sniplet: <number:number-style style:name="ND-0-0"> <style:text-properties fo:color="#FF0000"/> <number:number number:min-integer-digits="1"/> <number:text/> </number:number-style> <number:number-style style:name="ND-0"> <number:number number:min-integer-digits="1"/> <number:text/> <style:map style:condition="value()!=0" style:apply-style-name="ND-0-0"/> </number:number-style> See http://valhalla.fciencias.unam.mx/odfdomdoc/doc-files/OpenDocument-v1.2-part1-cd04.xhtml section 19.470. LO cannot load this format. Specifically the problem is that LO does not understand "value()!=0" and wants this to be "value()<>0". The standard does not allow that condition.
Created attachment 96588 [details] Sample file following the standard
Created attachment 96589 [details] Sample file using <> instead of !=
On pc Debian x86-64 with master sources updated yesterday, I could reproduce the pb from a brand new file. <number:number-style style:name="N106P0" style:volatile="true"> <style:text-properties fo:color="#ff0000" /> <number:number number:min-integer-digits="1" /> <number:text /> </number:number-style> <number:number-style style:name="N106"> <number:number number:min-integer-digits="1" /> <number:text /> <style:map style:condition="value()<>0" style:apply-style-name="N106P0" /> </number:number-style> Kohei/Markus/Eike: one for you?
If at all it is one for Eike. Kohei does not use the slickedit address any more.
*sigh*
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=dfcc851d65c8d81988843ef31a75b5d30051ddfd accept proper number style condition != as not equal operator, fdo#76777 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.
Pending review for 4-2 at https://gerrit.libreoffice.org/8834 for 4-1 at https://gerrit.libreoffice.org/8836
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3bc729b4b97ff3df67bb7af541b088f88248a1ec resolved fdo#76777 now write correct number style condition operator != 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.
thanks for submitting the issue and the *fast* fix :)
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=42ab5947518d92db9f0e1ccf063b211a3fd308ff&h=libreoffice-4-2 accept proper number style condition != as not equal operator, fdo#76777 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.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=bfab5b3bccf34f65d4238d0b43743c7c0365f859&h=libreoffice-4-1 accept proper number style condition != as not equal operator, fdo#76777 It will be available in LibreOffice 4.1.6. 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.