https://bugs.documentfoundation.org/show_bug.cgi?id=170727
--- Comment #2 from Martinarg <[email protected]> --- (In reply to Regina Henschel from comment #1) > (In reply to Martinarg from comment #0) > > Actual Results: > > The formula does not automatically apply to the newly inserted row and > > existing formulas shift position or require manual copying. > > Please have a look at the settings in Tools > Options > Calc > General, > section Input Settings. Is "Expand references when new columns/row are > inserted" option enabled? That is needed to automatically change the > reference of the formulas after the inserted row. > > When working with xlsx-files you can use the feature described here: > https://wiki.documentfoundation.org/CalcTableRef. Enhancement request to > make it a regular feature is in bug 162088. > > Besides that, it is a missing feature. The request for this feature is > tracked in bug 132780 and in bug 127808. Thanks for the clarification. I’ve checked the “Expand references when new rows are inserted” option, but as mentioned, it does not provide column-level formula behavior. Good to know this is already tracked in the referenced bugs. I’ll follow their progress. Thanks for the explanation. -- You are receiving this mail because: You are the assignee for the bug.
