https://bugs.documentfoundation.org/show_bug.cgi?id=113013
--- Comment #7 from Markus Mohrhard <[email protected]> ---
Seems that MSO requires non-sheet local formulas in conditional formats to be
inside of the extLst part of the conditional formatting code.
I'm not sure if we can easily implement this as that requires quite some rework
of the conditional format export code.
The Excel generated content:
<x14:conditionalFormattings>
<x14:conditionalFormatting
xmlns:xm="http://schemas.microsoft.com/office/excel/2006/main";>
<x14:cfRule type="expression" priority="1"
id="{77AD90AA-B4EF-4A1E-BD56-D2B295348952}">
<xm:f>IF(A1<>Sheet2!A1,1,0)</xm:f>
<x14:dxf>
<fill>
<patternFill>
<bgColor rgb="FFFF0000"/>
</patternFill>
</fill>
</x14:dxf>
</x14:cfRule>
<xm:sqref>A1:E5</xm:sqref>
</x14:conditionalFormatting>
</x14:conditionalFormattings>
The LibreOffice generated content:
<conditionalFormatting sqref="A1">
<cfRule type="expression" priority="2" aboveAverage="0" equalAverage="0"
bottom="0" percent="0" rank="0" text="" dxfId="0">
<formula>IF(A1<>Sheet2!A1,1,0)</formula>
</cfRule>
</conditionalFormatting>
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
