Issue 37659

Summary: calculation inside tables is broken
Product: Writer Reporter: tpotpo <tpo_deb>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1.3   
Target Milestone: ---   
Hardware: PC   
OS: Linux, all   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

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) 
"Expression is faulty" 
* 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. 
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".