To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=63438
Issue #:|63438
Summary:|Calc change cell with number from "number" to "text",
|but keep real format as "number"
Component:|Spreadsheet
Version:|OOo 2.0.2
Platform:|PC
URL:|
OS/Version:|Linux
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|code
Assigned to:|spreadsheet
Reported by:|maxbritov
------- Additional comments from [EMAIL PROTECTED] Tue Mar 21 07:48:16 -0800
2006 -------
step by step
1. New Spreadsheet
2. Enter 1,2,3 in three cells
3. Change format from number to text
4. Save
5. Look content.xml and format still number: office:value-type="float"
I can select next 3 cells, then made they as text and then enter 1,2,3. If I
will try to sort I will get 1,2,3,1,2,3. This is wrong. Shoould be 1,1,2,2,3,3.
>From content.xml:
<table:table table:name="Лист1" table:style-name="ta1" table:print="false">
<table:table-column table:style-name="co1"
table:default-cell-style-name="ce1"/>
<table:table-row table:style-name="ro1">
<table:table-cell office:value-type="float" office:value="1">
<text:p>1</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:style-name="ro1">
<table:table-cell office:value-type="float" office:value="2">
<text:p>2</text:p>
</table:table-cell>
</table:table-row>
<table:table-row table:style-name="ro1">
<table:table-cell office:value-type="float" office:value="3">
<text:p>3</text:p>
</table:table-cell>
</table:table-row>
</table:table>
This is real string:
<table:table-row table:style-name="ro1">
<table:table-cell office:value-type="string">
<text:p>1</text:p>
</table:table-cell>
</table:table-row>
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
