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


Le 19/03/2014 15:24, Gilles a écrit :

Hi,

In theory, a LibreOffice Database report should be able to do something
like that, but :

- if you bind a Calc or Excel file, you will not be able to write/edit
any of the data in the bound Calc or Excel file, as these become
read-only - in order to update the sheets, you would have to open them
up separately in Calc, do your editing/updates, etc, and then re-open
the ODB file;

- binding Calc or Excel files as text file data sources within an ODB
means you are limited to the column headers for your field names -
anything else is just a value (text string, date, integer, etc);

- if you import the data to an ODB file, via the data import wizard, you
will have more flexibility in what you do with that data, but you will
lose the direct link to the Excel/Calc file, so changes you make to the
latter will not be reflected in the ODB file, until you reimport the
data into your Base file - this might be too much of a hassle for most
people.

Alex


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