https://issues.apache.org/ooo/show_bug.cgi?id=119197
Bug #: 119197
Issue Type: DEFECT
Summary: Unexpected mark
Classification: Application
Product: Spreadsheet
Version: OOo 3.3
Platform: PC
OS/Version: Windows Vista
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: formatting
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 77427
--> https://issues.apache.org/ooo/attachment.cgi?id=77427
Calc file
I try to edit list of birthdays.
All is format *1.1.1832_ (day,month,year), but first mark is "*" and last mark
is space character"_".
I try to remove "*" and space character"_" marks by using
function =MID(A2;2;B2-2).
So first I use function =LEN(A2) for counting real numbers.
=MID(A2;2;B2-2) funtion works fine. I check by using again =LEN(C2)funtion that
extra marks "*" and space character"_" was tooked away.
Result looks nice, but then I took a copy from cell where was result of the
=MID(A2;2;B2-2) function. I pasted text another cell. In cell I can see
1.1.1832, but in feeding line is '1.1.1832.
I try to change result mode to the Date-mode, but its not work. Result is still
a text. Because mark "'". Why this happen?
And of cource cell =LEN(E2) result is not correct.
I have more then 5000 birthdays that I try to modify.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
