Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

On Mon, 11 Nov 2013 11:30:11 -0600
Denis Navas Vega <> 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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.