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


The only way I have to know that the numbers are in reality text, are that they are originally left aligned. Numbers are right aligned.

In other matter, I get the ' when I apply a number format to a cell previously formatted as text. If I edit it (F2) I can reach the ' and edit it by hand. This is really slow and not practical.



El 2013-11-17 02:54 p.m., Oogie McGuire escribió:
I'm with Charles on this one. I was the OP on the problem.

Nearly all of my issues are because I have my LO spreadsheet and then a CSV file. If I open the CSV 
file in LO it looks fine. I can't just import it into my existing spreadsheet because the data in 
it need to go into small subsets of my big spreadsheet. So I typically copy and paste groups of 
cells as required.

What I am used to doing in Excel is copy everything in, then format the cells to be numbers and 
they are converted to numbers and my formula work.

Or if I know they are text (but there is ABSOLUTELY NO WAY TO SEE THAT IN LO) I can do a paste 
special and that also works in excel and prevents the additional step of formatting the cells back 
to numbers.

All the discussions about the leading apostrophe are great but I still can't see it in LO nor can I 
remove it.

Yes, I got around the problem this time by creating a dummy column as described many messages ago, 
but the fact remains that it is neither easy to change nor easy to see when numbers are formatted 
as text in LO and coming from MsOffice this causes lots of problems.

On Nov 17, 2013, at 12:49 PM, Charles Smith <chuc@chucsmith.org> wrote:

Hello,

I can only speak for myself, but numbers get formatted as text in two ways:

1. Import of a tab delimited or csv file.

2. Spreadsheets sent to me from other users who have imported such files.

Usually I format the import to avoid the problem, but if I just double click a csv file, it opens 
with the numbers formatted as text. Visually this is not a problem. But if I then decide I need to 
edit the sheet I either have to reimport it or reformat the numbers.

Hope this explains how it happens to me.

Charles

Sent from my iPod Touch

On Nov 17, 2013, at 12:16 PM, James E Lang <jim+lou@lang.hm> wrote:

I've been following this debate with great interest.

One big question comes to mind: Why would someone use the apostrophe construct in the first place if he intended to 
perform arithmetic calculations using the cell content? I understand ending up with a text string rather than a number 
by forgetting to use VALUE() on a substring in a formula but even that seems to fall into the category of a 
"cockpit error" rather than an "aircraft design flaw" as is being implied on one side of this 
debate.



--
Jim


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

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



Eugenie (Oogie) McGuire
Desert Weyr http://www.desertweyr.com/
Paonia, CO USA





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

Context


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.