Issue 121716 - saving to .xls file the custom format of negative numbers uses CAP case [RED] not Title Case [Red]
Summary: saving to .xls file the custom format of negative numbers uses CAP case [RED]...
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 3.4.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: saisyamala
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2013-02-04 15:52 UTC by jon goldman
Modified: 2017-05-20 09:54 UTC (History)
2 users (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 jon goldman 2013-02-04 15:52:20 UTC 
The custom format of negative numbers in OpenOffice uses CAP case [RED] not Title Case [Red] and causes compatibility issues with other software..
looked on Microsoft site and they use Title Case [Red]
Kingsoft Office PC and Android use Title Case [Red]

Cannot use OpenOffice at the moment to save to .xls file standard using this [RED] CAP CASE.
Cannot ask Kingsoft to change as they are using and only claiming to use the Microsoft standard.
Cannot ask Microsoft to change as it is their formatting standard.

If the OpenOffice standard is [RED] CAP CASE, when you offer the facility to save in other file formats, then

I hope not to detract from your hard work, dilligence and ethics regarding open source software in pointing this out.

best regards and many thanks 

jon

sorry if this is my error, duplication and/or ignorance
Comment 1 saisyamala 2013-02-05 16:03:54 UTC 
Can you please mention the steps you followed and the error faced. Thanks!
(In reply to comment #0)
> The custom format of negative numbers in OpenOffice uses CAP case [RED] not
> Title Case [Red] and causes compatibility issues with other software..
> looked on Microsoft site and they use Title Case [Red]
> Kingsoft Office PC and Android use Title Case [Red]
> 
> Cannot use OpenOffice at the moment to save to .xls file standard using this
> [RED] CAP CASE.
> Cannot ask Kingsoft to change as they are using and only claiming to use the
> Microsoft standard.
> Cannot ask Microsoft to change as it is their formatting standard.
> 
> If the OpenOffice standard is [RED] CAP CASE, when you offer the facility to
> save in other file formats, then
> 
> I hope not to detract from your hard work, dilligence and ethics regarding
> open source software in pointing this out.
> 
> best regards and many thanks 
> 
> jon
> 
> sorry if this is my error, duplication and/or ignorance
Comment 2 Edwin Sharp 2014-01-09 15:47:52 UTC 
XLS with format code including conditions OK.

AOO410m1(Build:9750)  -  Rev. 1552994
Rev.1552994
Excel 2010 
Win 7