[Libreoffice-bugs] [Bug 139536] [XSLX] Conditional Formatting is lost on import

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from NISZ LibreOffice Team <libreoffice at nisz.hu> ---
Created attachment 174883
  --> https://bugs.documentfoundation.org/attachment.cgi?id=174883&action=edit
Named ranges of the modified example in Excel and Calc

This part is more suspicious... the condition for the text coloring seems to be
imported, but does not work:

IF(ROW(A18)>Last_Row;1; 0)

Last_Row = IF(Values_Entered;Header_Row+Number_of_Payments;Header_Row)
   Values_Entered = IF(Loan_Amount*Interest_Rate*Loan_Years*Loan_Start>0;1;0)
   Header_Row = ROW($Tilgungstabelle.$17:$17)
   Number_of_Payments = MATCH(0,01;End_Bal;-1)+1

Loan_Amount, Interest_Rate, Loan_Years, Loan_Start are references to D4:D7
cells.
End_Bal = $Tilgungstabelle.$I$18:$I$377

-- 
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/20210908/80c5940b/attachment.htm>