On Mon, 11 Nov 2013 11:30:11 -0600 Denis Navas Vega <[email protected]> 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 isn't). > 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 number. > 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. Paul -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
