Issue 27449 - complex functions of german Calc return values including "." as decimal seperator istead of ","
Summary: complex functions of german Calc return values including "." as decimal seper...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-04-05 11:09 UTC by norbert2
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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

Attachments
complex.sxc (5.64 KB, application/vnd.sun.xml.calc)
2004-04-05 11:10 UTC, norbert2 		no flags Details
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 norbert2 2004-04-05 11:09:58 UTC 
The complex functions of german Calc return values including "." as decimal 
seperator istead of ",".

Please open the attached spreadsheet with german Calc version:

The blue cell sums the both values in the white cells, using the built-in 
function "IMSUMME":
"110.34+5.2i", but "110,34+5,2i" would be correct for german version of Calc.

(Maybe other language Calc versions that should use "," as decimal seperator 
have the same problem.)
Comment 1 norbert2 2004-04-05 11:10:33 UTC 
Created attachment 14335 [details]
complex.sxc
Comment 2 frank 2004-04-06 08:54:03 UTC 
Hi Niklas,

as a German Excel displays the imaginary numbers with a comma as decimal
Separator, we should do it in the same way. Also and in my opinion more
relevant, a function result under german locales has to be displayed using the
german separators even if they are results from imaginary numbers.

Frank
Comment 3 niklas.nebel 2004-04-06 09:11:55 UTC 
No, function results shouldn't depend on the language of the installation. They
never do. Making it dependent on the system locale seems like a bad idea, too.
It would potentially affect further calculations using the result. This is very
different from the formatting (for display only) of a numeric result.
Comment 4 frank 2004-04-06 09:14:47 UTC 
Hi Falko,

it's your turn now.

I think we have to implement a 'view' for imaginary function results to display
with the correct decimal separators.

Frank
Comment 5 norbert2 2004-04-06 11:16:08 UTC 
The complex function's can be given over values with "." OR "," as decimal 
seperator. Only the return-values are always displayed with ".".

So, I think, if one complex function gives its value with "," to another 
complex function should be not a problem.

So, Niklas, why is it a problem to make the display dependent on the program-
language, like Frank has suggested?
Comment 6 falko.tesch 2004-04-07 08:51:20 UTC 
FT: Yes, we could think about this - but not in this relaese.
Please make an RFE out of this issue with target "Office Later" and assign it to
BH. Thx.
Comment 7 frank 2004-04-07 10:03:13 UTC 
Set the flags according to Falkos decission.

Frank
Comment 8 bettina.haberer 2010-05-21 15:13:14 UTC 
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".