Re: [libreoffice-users] Re: Turning spreadsheet data into legible report?

Hi :)
Would the optimal thing to do be to import that Excel tables into Base
and then export into an external back-end?  Then enter data using some
Form in Base.  For the reporting set-up a Report in Writer or Calc?

It sounds like it would be a lot of hassle but possibly would end-up
with something far more elegant?  ie easier for the people who just
want to see the lists (the reports).

About once per year it would need someone to go into the Forms to add
new students and delete old ones but most of the time people would be
just viewing the reports in a fairly familiar program wouldn't they?
Regards from
Tom :)




On 19 March 2014 15:45, Alex Thurgood <alex.thurgood@gmail.com> wrote:
> 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

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