On Mon, 11 Nov 2013 11:30:11 -0600
Denis Navas Vega <email@example.com> wrote:
The problem is with the symbol ' It can't be searched and replaced.
That's why Ady consider it a bug.
That's because it isn't actually there. It's just an indicator of the
fact that the number is not a number, but a text string. You can't take
it out to make the text string a number. You need to replace the
text string with an actual number (that may *look* the same, but
The only solution, which I used yesterday, is multiply by one.
I still don't understand what that is supposed to do. It sounds like a
kludge to me. The text string is a text string, I'm not sure why
anybody would think multiplying a text string by 1 would give you a
More than a bug, we must consider it an incomplete implementation of
the meaning of ' to accept figures as text. The operator should be
reachable from Calc interface and not hidden.
Again, as explained before by myself and Brian, I think, it's *not*
hidden, it just isn't part the the cell value. It is purely an
indicator of what the cell value is, either text or numeric. It *is*
reachable from the interface, in-as-much-as you can edit the cell
contents and either put in a string marker, or remove a string marker.
This is not a bug or incomplete feature. This is expected behaviour and
works like other spreadsheet programs.
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers · Ady
Re: [libreoffice-users] CALC convert text to numbers · Oogie McGuire
[libreoffice-users] Re: CALC convert text to numbers · Denis Navas Vega
- [libreoffice-users] Re: CALC convert text to numbers (continued)
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy