https://bugs.documentfoundation.org/show_bug.cgi?id=131065
--- Comment #9 from ady <[email protected]> --- The problem might be in the file itself (but I am testing on MS Windows). Indeed there is a problem with the _unary_ operator in cell H41 -> H9: =+G41*F41 ...and perform the same steps as in comment 0 -> FAILS. Undo and redo "solves" the false #REF! references; IDK why. Reload the original file. Change cell H41 to: =0+G41*F41 ...and perform the same steps as in comment 0 -> OK, which points to the unary operator as a problem. BUT: 1. Open attachment 158302 from comment 0. 2. Save as a _new_ XLSX file name. 3. Reload the _new_ file -> this step is ESSENTIAL (IDK why). 4. Select rows 9:40 5. [CTRL]+[-] to delete the selected rows. 6. Go to cell H9 (which was previosuly cell H41). -> cell H9: =+G9*F9 -> correct! Tested with LO 6.0.4.2 and LO 24.8.beta1 on MS Windows: Version: 24.8.0.0.beta1+ (X86_64) / LibreOffice Community Build ID: 23c9f786ec24cce9c94e82943137572da61dc0f0 CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: threaded Version: 6.0.4.2 Build ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf CPU threads: 4; OS: Windows 10.0; UI render: GL; Locale: en-US (es_AR); Calc: CL Please note that the original report mentions Linux, not Windows. It would be worth testing on Linux too. -- You are receiving this mail because: You are the assignee for the bug.
