Duplicate sheets missing rows issue

Although I managed to solve my problem, the following maybe of interest to others:
MacMini M4, Sequoia 15.5
Libreoffice 25.2.4
I duplicated a sheet using the duplicate sheet option. The duplicated sheet is missing original rows 6 and 7. The screenshots are attached. The sheet contains some 200-300 rows altogether, these are the only missing rows.

Solution : I found that the columns with the names of the month contained a formula which indicated they came from another sheet (something like =anothersheet.cellref). When I changed this column to actual values (copy and paste special) the problem disappeared !. But why only these two rows ? All rows are defined the same way.
The original spreadsheet came from an openoffice document. There are no hidden rows and the delete duplication option is not enabled (there are no duplicates anyway).

Before

After

It looks like the rows are there (the values match) but the Month Ending cells are incorrect. Maybe Edit > Links to External Cells needed updating. Or maybe A6 had a formula like =TODAY()

1 Like

Thanks for your comments. I hadn’t noticed that the amounts are still correct (but only in the first block of amount columns) so it looks like the sheet duplication affected other columns in a strange way. It has something to do with there being formulas in columns because the copy/paste special fixed the problem. But why these 2 rows only (all cells in the column contained the same formula) remains a mystery.

Can you attach a sample file?