[Libreoffice-bugs] [Bug 122590] FILEOPEN XLSX Conditional formatting referencing cell value in another sheet isn't imported

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Jan 9 23:59:40 UTC 2019


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

--- Comment #4 from Aron Budea <baron at caesar.elte.hu> ---
Created attachment 148192
  --> https://bugs.documentfoundation.org/attachment.cgi?id=148192&action=edit
Similar sample created in Calc

(In reply to m.a.riosv from comment #3)
> The formula doesn't work in ODS, I think to remember there are limitations
> to use CF between sheets.
Yes, the Calc sheet reference syntax is different (eg. Sheet2.A1), but I could
create a similar sample in Calc with Calc's native syntax, and import/export is
expected to take care of translating the references.

In fact, saving this sample in XLSX format in Calc generates a file that can be
opened fine both in Calc and Excel.

-- 
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/20190109/e09d0982/attachment-0001.html>


More information about the Libreoffice-bugs mailing list