Re: [libreoffice-users] Re: CALC convert text to numbers

On Mon, 11 Nov 2013 11:30:11 -0600
Denis Navas Vega <denis.navas@gmail.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
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: users+unsubscribe@global.libreoffice.org
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