https://bugs.documentfoundation.org/show_bug.cgi?id=170727
Bug ID: 170727
Summary: Calc lacks column formulas that persist when inserting
rows
Product: LibreOffice
Version: 26.2.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
In LibreOffice Calc, it is not possible to define a formula that applies
automatically to all rows of a column when new rows are inserted.
A common use case is applying a row-by-row calculation, for example:
discounted price = price * 0.98
Currently, when inserting rows inside a data range, formulas must be manually
copied again. This causes formulas to shift or stop applying to the correct
rows, making the workflow error-prone.
Other spreadsheet applications provide table-style column formulas where:
- formulas apply to the entire column
- new rows automatically inherit the formula
- existing data is not broken
Calc currently lacks this behavior, which limits its usability for pricing,
accounting, and financial workflows.
Similar functionality is available in other spreadsheet applications (e.g.
Excel tables, Google Sheets), which helps reduce manual formula management.
Steps to Reproduce:
1. Open LibreOffice Calc
2. Enter numeric values in a column
3. Enter a formula in the adjacent column referencing the same row (e.g.
=A1*0.98)
4. Insert a new row within the data range
Actual Results:
The formula does not automatically apply to the newly inserted row and existing
formulas shift position or require manual copying.
Expected Results:
The formula should automatically apply to newly inserted rows, preserving a
consistent column-level calculation.
Reproducible: Always
User Profile Reset: No
Additional Info:
This feature would reduce human error and improve Calc usability compared to
other spreadsheet applications.
--
You are receiving this mail because:
You are the assignee for the bug.
