[Libreoffice-bugs] [Bug 139163] FILESAVE XLSX Conditional formatting give error by opening in excel

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139163

--- Comment #10 from NISZ LibreOffice Team <libreoffice at nisz.hu> ---
(In reply to NISZ LibreOffice Team from comment #9)
> Created attachment 168736 [details]
> Example file created from scratch to demonstrate the problem

Oops, too soon.

This file shows that a conditional formatting First/Second;Third>1 in B3 is
valid conditional format in ODS without quotes, if First/Second/Third are valid
named ranges (pointing to A1/A2/A3).

Also fff/sss;ttt>1 in B5 is valid in ODS without quotes when fff/sss/ttt are
not valid named ranges.

Saving this file to XLSX will generate invalid contents detected error in Excel
upon opening.

Putting these conditions into quotes as shown in B4 and B6 does not generate
invalid contents in XLSX.

B1 and B2 shows that the two parts of the condition "First/Second;Third>1" are
valid without quotes in XLSX too, only connecting them with the semicolon makes
it necessary to quote them.

D3 shows that using direct cell references instead of named ranges like
$Munkalap1.$A$1/$Munkalap1.$A$2;$Munkalap1.$A$3>1 
is also valid without quotes when saved in XLSX.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210107/536516c5/attachment.htm>