Kirill S. Palagin wrote:
>
>> -----Original Message-----
>> From: Adrian Try [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, March 28, 2007 5:46 PM
>>
>> > I am trying to change cell format from text to number
>> (Standard) and
>> > Calc adds leading ' to the cell contents.
>> > How do make Calc not do this?
>>
>> The apostrophe is put there because the cell contains text.
>> Just delete the apostrophe, and then it will be a normal number.
>>
>>
>> --
>> Adrian Try
>> Try Another Angle
>> www.tryanotherangle.org
>> Computer software should be affordable, effective and safe.
>>
>
> Deleting it just dose not scale well. Many people have filed issues
> simillar to http://www.openoffice.org/issues/show_bug.cgi?id=24374 .
>
>
The placement of a leading apostrophe is appropriate. The defect is that,
in Linux at least, the find mechanism cannot find a leading apostrophe. The
same is evidently true of some Windows versions:
http://qa.openoffice.org/issues/show_bug.cgi?id=62596
Because there is a workaround (as mentioned by Dan Lewis), the geniuses in
OOo have decided that the issue is invalid. They have not altered Help to
make the position clear. In Windows now you can evidently search for ^' and
replace with nothing, still using "regular expressions". Whether in
Windows, a simple search for ' will find a leading apostrophe without using
regular expressions (as it should), I do not know.
--
View this message in context:
http://www.nabble.com/Calc---changing-from-text-format-to-number%2C-%27-is-added-tf3480343.html#a9725605
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
