In an xls worksheet, when we insert rows above another, the formulas are not copied in the added rows.
Excel does, if the row is in range formatted as a table. But calc doesn't manage it like excel, not a bug.
Strange, before last update it's working ? Now, if in a row a cell contains a formula, if I select this row and insert a new one above it, I need to copy the cell with the formula and paste it into the new row to find again my formula. It's not very easy. The last version I install is : Version: 7.2.5.2 (x64) / LibreOffice Community Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: fr-BE (fr_BE); UI: fr-FR Calc: threaded
It was never implemented, so I don't think it could ever work. Which version was the last working for you?
Sorry, I believe you are correct. With DROPBOX I am working on the same files from a PC that uses excel and another that uses "LibreOffice", that is confusion on my part.