Issue 105192

Summary: Opening a Micrsoft 2000 formated document boolean are getting read as invalid
Product: Calc Reporter: mikeycarter <mikey>
Component: viewingAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOO310m19Keywords: ms_interoperability
Target Milestone: ---   
Hardware: All   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description mikeycarter 2009-09-18 22:04:06 UTC
When I open a MS Office 2000 and the field reports err:502

The field in question is:

=ROUND(100-TREND(T7:T10;S7:S10^{1;2;3};0.05^{1;2;3};TRUE());0)

If I change the TRUE() to TRUE it works fine.   I've tried this in a few
documents and same result.  MS Office 2000 and 2003 both save the boolean as
TRUE() and open office can't read it.