Apache OpenOffice (AOO) Bugzilla – Issue 15143
Show table row and column numbers
Last modified: 2014-03-16 20:14:09 UTC
It would be valuable to have an option to show numbers of rows and cells in writer. That would help a lot to find the cell coordinates when writing dynamic formulas in writer (I'm not speaking of the formula editor here).
SBA: Reassigned to Bettina from the User Experience team for consideration.
OpenOffice.org Issue Tracker - Feedback Request. The Issue you raised is currently 'Unconfirmed' pending review, but has not been updated within the last 3 years. Please consider re-testing with one of the latest versions of OOo, as the problem(s) may have already been addressed. Either use the recent stable version: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ Please report back the outcome so this Issue may be Closed or Progressed as necessary - otherwise it may be Resolved as Invalid in the future. You may also wish to search for (and note) any duplicates of this Issue that may have advanced further by checking the Issue Tracker: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".
Confirmed with AOO410m14(Build:9760) - Rev. 1573062 2014-03-01_04:11:01 - Rev. 1573123 Debian
May I ask: What is the meaning of "dynamic formulas in writer"? 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. 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.
(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> .