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

m.a.riosv <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
                 CC|                            |[email protected]
                   |                            |rg
     Ever confirmed|0                           |1

--- Comment #1 from m.a.riosv <[email protected]> ---
Hi Geza,

seems the issue is with Conditional Formatting, some address are wrong in it
opening in LibreOffice.

conditions for multiple ranges seems not well imported.

In the original file:
-<conditionalFormatting sqref="G2:H1048576">
-<cfRule dxfId="0" text="" rank="0" percent="0" bottom="0" equalAverage="0"
aboveAverage="0" priority="2" type="expression">
<formula>$B2="x"</formula>
</cfRule>
</conditionalFormatting>
-<conditionalFormatting sqref="F2:I2;F1;F3:J1048576">
-<cfRule dxfId="1" text="" rank="0" percent="0" bottom="0" equalAverage="0"
aboveAverage="0" priority="3" type="expression">
<formula>$D1="x"</formula>
</cfRule>
</conditionalFormatting>
-<conditionalFormatting sqref="H2:H1048576">
-<cfRule dxfId="2" text="" rank="0" percent="0" bottom="0" equalAverage="0"
aboveAverage="0" priority="4" type="expression">
<formula>$A2="x"</formula>
</cfRule>
</conditionalFormatting>
-<conditionalFormatting sqref="G2:H1048576">
-<cfRule dxfId="3" text="" rank="0" percent="0" bottom="0" equalAverage="0"
aboveAverage="0" priority="5" type="expression">
<formula>$C2="x"</formula>
</cfRule>
</conditionalFormatting>
-<conditionalFormatting sqref="F1;F2:J1048576">
-<cfRule dxfId="4" text="" rank="0" percent="0" bottom="0" equalAverage="0"
aboveAverage="0" priority="6" type="cellIs" operator="notEqual">
<formula>#ref!</formula>
</cfRule>
</conditionalFormatting>

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to