Issue 71594 - Add period to end of Format code after re-loading spreadsheet
Summary: Add period to end of Format code after re-loading spreadsheet
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.1
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-11-16 01:04 UTC by y-catch
Modified: 2017-05-20 11:11 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 y-catch 2006-11-16 01:04:57 UTC 
- open a (new) spreadsheet
- enter a value into a cell
- apply "[S].000" as "Format code" for this cell: the format is
correctly applied
- close the spreadsheet
- load the spreadsheet 

=>> now the "Format code" change to "[S].000."

please refer to;
http://ja.openoffice.org/issues/show_bug.cgi?id=69991
http://ja.openoffice.org/issues/show_bug.cgi?id=40311

Japanese bagtrack:
http://oooug.jp/faq/index.php?faq/4/77
Comment 1 frank 2006-12-11 11:35:17 UTC 
Hi Eike,

please have a look at this one.

Frank
Comment 2 frank 2006-12-11 11:38:51 UTC 
targeted
Comment 3 papadopoulos_elias 2007-01-25 01:38:40 UTC 
I am running OO v2.1 on Windows XP SP2. I am able to produce the problem when I
save the file as a .ods. I did notice that when I saved the file as a .xls (for
Microsoft Excel 97/2000/XP), then when I closed the spreadsheet and loaded the
spreadsheet in OO, the cell retained the proper format code.
Comment 4 Martin Hollmichel 2007-11-09 16:51:54 UTC 
change target from 2.x to 3.x according to
http://wiki.services.openoffice.org/wiki/Target_3x
Comment 5 Marcus 2017-05-20 11:11:28 UTC 
Reset assigne to the default "issues@openoffice.apache.org".