https://bugs.documentfoundation.org/show_bug.cgi?id=147879
--- Comment #10 from bunkem <[email protected]> --- I wanted to rule out that there is a problem with the spreadsheet. 1) The file if saved to ODS shows the same #VALUE error when recreating the steps. 2) I opened the spreadsheet submitted with Excel 365. Excel deletes the columns and the formula calculates and shows the value correctly. Please note the formula in the cell W12 in the Excel screenshot and compare it to the formula in the Calc screenshot. The actual formula is correct in Calc even if it shows #VALUE. It would appear to me to be calculation engine issue. I was able to check back to 6.4.0alpha. This version has the issue also. -- You are receiving this mail because: You are the assignee for the bug.
