incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 119197] New: Unexpected mark
Date Fri, 06 Apr 2012 21:33:34 GMT
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: ooo-issues@incubator.apache.org
        ReportedBy: ooxhesta@hotmail.com


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.

Mime
View raw message