Issue 10281

Summary:

cell format for number values is not applied

Product:

Calc

Reporter:

moritzmhq <moritz-openoffice>

Component:

code

Assignee:

Status:

CLOSED NOT_AN_OOO_ISSUE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues

Version:

643C

Target Milestone:

---

Hardware:

OS:

Linux, all

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
private spreadsheet showing the bug in the PLZ column	none

Description moritzmhq 2002-12-23 12:50:18 UTC

The PLZ column in the attached spreadsheet can not be formatted with any means. To change these cells to text format -- necessary to get the leading zeroes in the area codes -- , I had to retype all of them. Any change of format did not stick. Tried with bot OOo 1.0.1 and 643C!

Why is a single number a "value"?

The spread sheet was imported from excel. This should work!

Comment 1 moritzmhq 2002-12-23 12:51:11 UTC

Created attachment 4152 [details]
private spreadsheet showing the bug in the PLZ column

Comment 2 frank 2003-08-11 13:55:53 UTC

This is not a bug of Calc.

Format the cells with leading zeros 5. This will mean you the format
of the number should have 5 places and if you have 4 numbers add a
leading zero.

So closed invalid.

Frank

Comment 3 frank 2003-08-11 13:56:08 UTC

closed invalid