Issue 115075 - Funktion N() does not handle matrix
Summary: Funktion N() does not handle matrix
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOO320m12
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-10-15 11:19 UTC by ruwen
Modified: 2017-05-20 11:33 UTC (History)
1 user (show)

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

Attachments
Example: Funktion N() does not interprete Matrix correctly (8.97 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-10-15 11:21 UTC, ruwen 		no flags Details
Screenshot of file opened with OpenOfficeCalc (106.85 KB, image/png)
2010-10-15 11:28 UTC, ruwen 		no flags Details
Screenshot of file opened with Gnumeric (75.09 KB, image/png)
2010-10-15 11:28 UTC, ruwen 		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 ruwen 2010-10-15 11:19:47 UTC 
When using funktion N() in combination with a matrix, it does not behave as
expected.

For example if I write 

{=N(F11:F13)}, only the first element seems to be analized.

See attachment.
Comment 1 ruwen 2010-10-15 11:21:11 UTC 
Created attachment 72058 [details]
Example: Funktion N() does not interprete Matrix correctly
Comment 2 ruwen 2010-10-15 11:28:18 UTC 
Created attachment 72059 [details]
Screenshot of file opened with OpenOfficeCalc
Comment 3 ruwen 2010-10-15 11:28:48 UTC 
Created attachment 72060 [details]
Screenshot of file opened with Gnumeric
Comment 4 ooo 2010-10-15 12:54:57 UTC 
Confirming.
Comment 5 Marcus 2017-05-20 11:33:16 UTC 
Reset assigne to the default "issues@openoffice.apache.org".