https://issues.apache.org/ooo/show_bug.cgi?id=122812
Bug ID: 122812
Issue Type: ENHANCEMENT
Summary: If cell begins with ' the character can not be found,
removed, or replaced
Product: Calc
Version: AOO 4.0.0
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: formatting
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 81126
--> https://issues.apache.org/ooo/attachment.cgi?id=81126&action=edit
A file containing the hidden ' in A1. Try searching for this character and it
cannot be found.
In OpenOffice Calc create a new spreadsheet.
Insert: '123456789
-- into column A.
Then try to use find and replace, or any clean or substitute fomula to remove
this symbol/character. The apostrophe cannot be removed. I have found one work
around to be: =A1+0 into column B, however this was not the expected result.
It would be nice if OpenOffice could detect and remove this symbol by default
Find & Replace window. Especially when there's several thousand rows & lines of
it. Or remove the character when Format Cells >> User-defined >> 000000000 is
set.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
