Issue 20396

Summary: OO forgets number format with spaces after closing and opening document
Product: Calc Reporter: jenserikweber <jenserikweber>
Component: codeAssignee: oc
Status: CLOSED FIXED QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1 RC5   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description jenserikweber 2003-09-29 22:01:45 UTC
I formatted a column of numbers in the menu Format - Cells - Numbers as

##_i##_i##_m##_i##_i##

i. e. I want to have small spaces ("_i")and a big space ("_m") like written in
the help. The issue is the same if the format is more simple.

After closing the dialogue box the formatting works as expected. But after
closing  the document and oppening it again the format has become

#"       "

i. e. the spaces in between the digits have vanished, but there is a string of 7
spaces at the end of the cell, which shows also in rendering.

If you use spaces in quotation marks like

##" "##" "##"  "##" "##" "##

instead, the format is retained also after closing the document.

At least the documentation should be changed accordingly so you can insert
spaces that survive the closing of the document even if you can't determine the
width of the spaces in the workaround.

Jens
Comment 1 frank 2003-09-30 09:50:43 UTC
Hi Niklas,

it works like described in the help but only if you do not save the
document. So it's yours.

Frank
Comment 2 oc 2003-10-08 14:02:45 UTC
This needs a bigger change in the numberformatter for fixing, therfor
could not be fixed in OOo1.1.1
Comment 3 niklas.nebel 2004-10-05 15:34:34 UTC
Fixed in CWS "calc23". Changed: xmlnumfe.cxx 1.38.60.1
Comment 4 niklas.nebel 2004-10-12 12:50:37 UTC
reopening to reassign
Comment 5 niklas.nebel 2004-10-12 12:51:01 UTC
reassigning to QA for verification
Comment 6 frank 2004-10-19 10:08:24 UTC
reset fixed
Comment 7 frank 2004-10-19 10:22:30 UTC
Found fixed in cws calc23 using Linux, Solaris and Windows builds
Comment 8 oc 2004-12-01 13:52:34 UTC
closed because fix available in OOo1.9m63