Bug 122763 - Improve writer table formulae handling, when adding rows, to also clone formula
Summary: Improve writer table formulae handling, when adding rows, to also clone formula
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Writer-Tables-Formulas
  Show dependency treegraph
Reported: 2019-01-16 16:18 UTC by Hans-Peter Jansen
Modified: 2019-01-17 12:09 UTC (History)
0 users

See Also:
Crash report or crash signature:

A Writer document with a typical offering/invoice table (11.06 KB, application/vnd.oasis.opendocument.text)
2019-01-16 16:18 UTC, Hans-Peter Jansen

Note You need to log in before you can comment on or make changes to this bug.
Description Hans-Peter Jansen 2019-01-16 16:18:16 UTC
Created attachment 148364 [details]
A Writer document with a typical offering/invoice table

Dear everybody,

attached document contains a table, that is typically found in offer/invoice documents. Please load the document and attempt to add an item.

E.g.: put cursor in "Microbes" row, and add another table row below. You might notice, that the format of the fields is cloned (this is one of the latest user visible achievements in this area, much appreciated, thank you!), but the formula in the unit sum column is missing. Adding an article involves specifying an amount (ok), name (ok), unit price (ok), and a formula in the last column (= amount * unit prize)(improvable).

From a users point of view, the last step is the most inconvenient one, and it would be nice to behave similar to a Calc table here, where such a formulae would be cloned correctly. 

The expected result would be have any formulae cloned from above.
Comment 1 Timur 2019-01-17 11:36:44 UTC
I'll confirm as useful. But we still need an assessment if feasible.
And we need to take into account that sometimes you don't want formulae cloned. 
Maybe consider to clone formula only with Ctrl pressed during Insert Rows, regardless if menu/right-click menu/toolbar.
Comment 2 Hans-Peter Jansen 2019-01-17 12:09:44 UTC
From a users POV and from "experience of least surprise" department, you will want to have the formulae cloned, as well as everything else (formats). 

Another reason is: it is much easier to remove formulae than adding them. Especially since Writer doesn't have the Calc's concept of fill operations (and I second this - Writer is not Calc).

FYI, cloning formats used to fail in former times as well:


Yes, I reported these issues about 13 years ago. At that time, it was flagged trivial, but who knows....