Issue 93950 - Number format for array results should not be inherited from top left cell.
Summary: Number format for array results should not be inherited from top left cell.
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: recent-trunk
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-09-16 11:54 UTC by ooo
Modified: 2017-05-20 11:35 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
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 ooo 2008-09-16 11:54:18 UTC 
Let A1:A2 be 0;1
B1:B2 {=IF(A1:A2;5)}
=> Result is FALSE;5 but displayed is FALSE;TRUE (applying boolean format on the
fly, hiding the 5).
Should be FALSE;5 instead.
Comment 1 mariosv 2009-02-14 01:58:34 UTC 
I think in comparations, any value different form zero is always TRUE.
Comment 2 Marcus 2017-05-20 11:35:10 UTC 
Reset assigne to the default "issues@openoffice.apache.org".