Issue 27634 - More formulae/functions for Writer tables
Summary: More formulae/functions for Writer tables
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOO310m4
Hardware: All All
: P5 (lowest) Trivial with 10 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 107849 (view as issue list)
Depends on:
Reported: 2004-04-09 01:23 UTC by maxqnz
Modified: 2013-02-07 22:33 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description maxqnz 2004-04-09 01:23:58 UTC
Currently, Writer is very limited in the number of functions it offers in tables.
There is no "COUNT" for example, and a total of barely a dozen functions. Adding
more basic funtions would increase the flexibility of Writer tables. Currently
the "MEAN" function treats blank cells as having a zero entered, whereas the
"AVERAGE" function in Calc correctly ignores blank cells or alpha data. A
similar function would be an asset in Writer.
Comment 1 michael.ruess 2004-04-13 12:15:13 UTC
Feature request.
Comment 2 tuarihemi 2006-11-05 08:03:17 UTC
*** Issue 27634 has been confirmed by votes. ***
Comment 3 katherinekatz 2006-11-07 05:12:07 UTC
I want a split screen & the ability to hide rows 'n columns.
Comment 4 katherinekatz 2006-11-14 04:25:29 UTC
I also need a fill function in writer tables--so I can fill a series of 
numbers (1,2,3,4) down a column in a table in writer. Thankyou
Comment 5 maxqnz 2009-03-17 12:52:39 UTC
It is sad to see this still in limbo after all these years. I first posted this
enhancement request in 1.1RC1 and now I'm running 310m4 and nothing's changed.
Comment 6 igx31 2009-12-18 11:52:57 UTC
Basic string handling function are also direly needed. There does not even seem
to be a way to simply refer to the string included in another cell of the table...
Comment 7 eric.savary 2009-12-31 13:55:52 UTC
*** Issue 107849 has been marked as a duplicate of this issue. ***
Comment 8 bobharvey 2009-12-31 16:53:35 UTC
As I said in  Issue 107849 it would truly be an Integrated suite if all the
formulae and functions were available in WP tables and Presentations.  Perhaps
the first truly integrated suite since Ashton-Tate's Framework?
Comment 9 igx31 2009-12-31 17:04:58 UTC
Well, as stated in the summary, the subject is not /all/ functions, but /more/
functions. There are really too few, and many others would be trivial to
implement. My request for text functions may be tricky (since it requires
carrying the cell type along with the value), but I'm sure the COUNT function
asked by "maxqnz" would be easy, since it is surely computed internally for the
existing MEAN function...
Comment 10 bettina.haberer 2010-05-21 14:47:38 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".