https://issues.apache.org/ooo/show_bug.cgi?id=15143
--- Comment #6 from Edwin Sharp <[email protected]> --- (In reply to mroe from comment #5) > May I ask: What is the meaning of "dynamic formulas in writer"? I assume formulas that are frequently updated according table changes. > In a writer (text) table there can be used formulas like sum(A1:A3) or > sum(Table1.A1:A3). There are no functions where the parameter can be a > number of a column or a row. Isn't it? > > The position of the cursor (or the selected cells) in a text table is shown > at the status bar like "Table1:A1:A3". The difference between formula and > status bar is the "." after the table name in the formula and the ":" in the > status bar. The problem with the status bar indication is that it is not updating during highlight of cells, only after. So one has to highlight the required range in a large table until the approximate location and then correct with shift+arrows to final location - unintuitive. > Or is this request focussed at API or DDE? > > - - - - - - - > > A numbering of rows and columns with column/row headers like in calc isn't > practicable because in a text table the number of cells in each row can > differ, also the number of cells in each column. > > Try the following: > Insert a text table with 4 columns and 3 rows into a writer document. So you > get a table with cells A1:D3. > > Now select B2:C2 and merge these cells. The result is that row 2 now > contains only 3 cells A2:C2. C2 is located between D1 and D3. > Similar for merging cells in a column or cells in columns _and_ rows. This is IMHO a different bug (renaming former D2 to C2) - a formula in D4 shows =<D1:D3> and not =<D1:C2:D3> . -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
