Bug 146640 - INSERT ROWS ABOVE INTO XLS DON'T COPY FORMULAS
Summary: INSERT ROWS ABOVE INTO XLS DON'T COPY FORMULAS
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-01-07 15:15 UTC by marcel.deneumostier
Modified: 2022-01-08 13:42 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description marcel.deneumostier 2022-01-07 15:15:25 UTC
In an xls worksheet, when we insert rows above another, the formulas are not copied in the added rows.
Comment 1 m_a_riosv 2022-01-07 15:35:35 UTC
Excel does, if the row is in range formatted as a table.
But calc doesn't manage it like excel, not a bug.
Comment 2 marcel.deneumostier 2022-01-07 17:29:08 UTC
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
Comment 3 m_a_riosv 2022-01-08 11:45:55 UTC
It was never implemented, so I don't think it could ever work.
Which version was the last working for you?
Comment 4 marcel.deneumostier 2022-01-08 13:42:23 UTC
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.