[Libreoffice-bugs] [Bug 113013] FILEOPEN: XLSX - Unable to interpret 'Formula is' type conditional formatting rule

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from Markus Mohrhard <markus.mohrhard at googlemail.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180926/c301d1b5/attachment.html>