https://bugs.documentfoundation.org/show_bug.cgi?id=139536
--- Comment #7 from NISZ LibreOffice Team <[email protected]> --- 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.
