Issue 40311 - bad Format code after re-loading spreadsheet
Summary: bad Format code after re-loading spreadsheet
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.4
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 69991 (view as issue list)
Depends on:
Blocks:
 
Reported: 2005-01-10 19:23 UTC by norbert2
Modified: 2017-05-20 11:13 UTC (History)
3 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 norbert2 2005-01-10 19:23:48 UTC 
- open a (new) spreadsheet
- enter a value into a cell
- apply "0,00000 00000 00000" as "Format code" for this cell: the format is
correctly applied
- close the spreadsheet
- load the spreadsheet: now the "Format code" is corrupt!

(in the "Format Cells"-window you can see that the two spaces have moved to the
end of the "Format code"-string!)
Comment 1 abdul 2005-01-11 05:24:11 UTC 
I tried the same on oo  m65 version, Instead of displaying the number with 
format , it showing '###' 

Steps
-----
Enter a value  
eg:-  123456789
Right click on the cell and select  'Format cells...'
Type  0, 00000 00000 00000 in  'Format Code '
Comment 2 frank 2005-01-11 09:40:58 UTC 
Hi Niklas,

one for you I think.

Frank
Comment 3 niklas.nebel 2005-01-11 15:27:29 UTC 
The number:embedded-text element is specified only for positions left of the
decimal point.

It seems useful to extend this to the right of the decimal point, but it's too
late now to do so for 2.0.

Remember we never had the goal of saving every possible format string (that's
the cost of using a structrured, logical description).

We'll have to change this issue's target to "later".
Comment 4 frank 2005-01-11 16:03:11 UTC 
So I've done it. Target later.
Comment 5 ooo 2006-10-12 13:11:58 UTC 
*** Issue 69991 has been marked as a duplicate of this issue. ***
Comment 6 norbert2 2006-11-16 16:46:39 UTC 
Hi Niklas.

"but it's too late now to do so for 2.0"

So what about targeting to 2.2?
Comment 7 Marcus 2017-05-20 11:13:40 UTC 
Reset assigne to the default "issues@openoffice.apache.org".