Issue 37659 - calculation inside tables is broken
Summary: calculation inside tables is broken
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: editing (show other issues)
Version: OOo 1.1.3
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-11-22 22:36 UTC by tpotpo
Modified: 2013-02-07 22:37 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description tpotpo 2004-11-22 22:36:10 UTC 
How to reproduce: 
 
1. start openoffice 
2. File->New->Text Document 
3. Insert->Table 
4. =round(1;2) 
 
Result: 
"Expression is faulty" 
 
Remarks: 
* list separator doesn't matter - same result with "," as a separator 
* this has been working once (on 1.1.1?) since we've been using it in our 
documents before 
* this happens with 1.1.2 and 1.1.3 
* this happens on Linux Debian "testing", "unstable" and winxpsp2 
* you can achieve the same either by pressing "=" and entering the formula or 
by pressing "F2" inside the table 
 
Further similar bugs: 
* if you press "=" or F2 you'll get to the Function edit line. There is a f(x) 
button on the left of that edit line. If you press that, you have a choice of 
a few functions among which is "round". If you choose that you see "=round 
" (with the space) in the edit line - without parenthesis, explanation, 
example parameters or anything 
* "=floor(1)" works, but "=floor(1)*1" gives you a "Expression is faulty"
Comment 1 myrkraverk 2004-11-22 22:54:49 UTC 
This also happens on StarOffice 7 Update 4, Linux.
Comment 2 tpotpo 2004-11-23 08:02:05 UTC 
It has turned out, that this isn't a bug. 
 
The problem is that the syntax of functions is different in the spreadsheet 
and in text documents and that it is not trivial to happen to find the right 
function description. 
 
So I'd like to ask to transform this into two feature requests depending on 
what venue will be chosen: 
 
1.a) improve the documentation, so that searching for "round" (or any other 
function accessible to function editing inside text documents) will also get 
you to the syntax of the version of the function for text documents. 
1.b) crossreference the spreadsheet and the text-document formulas 
1.c) put some exclamation marks or "attention" or such in prominent places so 
that the user is made aware of the difference in syntax 
 
2. I'd rather have the same syntax in spreadsheets and text-documents. So my 
biggest wish would be to do just that. 
 
Thanks, 
*t
Comment 3 michael.ruess 2004-11-23 08:20:10 UTC 
Adapting the table calculation functions in Writer and Calc could be a useful
thing, as one can see from this example.
Comment 4 bettina.haberer 2010-05-21 15:17:57 UTC 
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".