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

Hi,

Am 11.11.2013 18:17, schrieb Oogie McGuire:

> What's a problem is that in Excel even though it also uses the 
> leading ' to format text as numbers, if you change the format of 
> a cell the conversions happen without any problems.
That´s not true. I just tried in Excel. The leading ' stays, no
matter what format you would apply.

> to me it makes sense that the cell format should be the
> controlling factor for what type of data is in a given cell.
Absolutely no! Format must never have an impact on values or data
types. That´s a matter of logics.

Cheers,
Stefan


-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
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