Description: 1. get file at http://www.excelvorlage.de/entry/118/kreditberechnung-mit-sondertilgungen-2 2. Fill fields: D4=100.000; D5=2%; D6=5; D7=01.01.2021; D8=500 3. press F9 4. scroll down to line 65: everything 65 and following lines should be hidden per conditional formatting Steps to Reproduce: see above Actual Results: see above Expected Results: see above Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.0.4.2 (x64) Build ID: dcf040e67528d9187c66b2379df5ea4407429775 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: threaded
Created attachment 168814 [details] file from excelvorlage.de
You might have to click F9 when being in cell G18. A separate ticket will be filled in a minute.
Created attachment 168817 [details] The original xlsx file in Excel and Calc 7.2 I don't get the expected result in Excel 2013 either. All rows are visible between 18 and 377. Nor in: Version: 7.2.0.0.alpha0+ (x64) Build ID: 8e691505d4675b878b30bd00cd2e4fb4f794f0ef CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL Both Excel and Calc give and #N/A error in D13 when filled with the given numbers.
Created attachment 168820 [details] Good working example in MSO O365 See line 64 and later: they are "hidden" by color. The second conditional formatting rule is not imported in Calc.
Created attachment 174879 [details] Modified example file I managed to get it visible in Excel by leaving the D8 field empty. Also changed the CF rule a bit, to make the invisible text formatting orange instead, so it's presence more clearly visible. Can confirm that the formatting is not applied to the text in: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: c7b5e6566d9b24a0a996c739a945004d9aadee2f CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL The conditions look to be imported fine though. To me it looks more like an issue with the forest of named ranges containing formulae, which is used in the condition. I could not minimize it enough yet to understand which step does not work.
Created attachment 174880 [details] Conditional formatting rules of the modified example in Excel and Calc These seem to be imported fine.
Created attachment 174883 [details] 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