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: firstname.lastname@example.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