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

Le 10/11/2013 22:57, Oogie McGuire a écrit :
I have a spreadsheet that is the output of a SQLite Database on
Android. It contains numbers that have been formatted as text. When I
copy the columns into my LibreOffice Spreadsheet I want to make sure
that they are interpreted as numbers.

This will do quite easily:

Call the menu Data / Numbers as text (freely translated from my FR
install) then just click OK in the window that opens without changing
anything. This should do the trick.

Another way I often use when the import is made on a regular basis, is
to create what I call an "exploitation sheet".

You create a new spreadsheet and insert data there from the spreadsheet
you got from the import. The formulas will then look like
Then copy down and right and you're set.

What is interesting is that you may add some data handling when linking
the cells: you may have
which would automagically convert the text data into numerical data
without having to bother each and every time a new import comes.
You may also ignore any superfluous column, and so on.

For the ease of use, make sure to have both spreadsheets in the same

Note that:
-- this works only if the imported data is consistent (same columns at
the same place) and the data file must be uniformly named.
-- the imported data must be in a real file on disk.

Jean-Francois Nifenecker, Bordeaux

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.