[libreoffice-users] Calc question

Hello. I am new on this list and to LibreOffice and have a question about
using Calc.

I want to be able to take a file that has been exported as a .CSV file from
another application, import all the data in that file and then generate a
summary from selected columns and then to print that summary.

The .CSV file has name, address, phone/fax number, email, organisation name,
job role and a whole lot of other fields. The export facilities from the
other application are limited so I can't export only the fields I want; it
is an all or nothing export.

I want to be able to take all the data and import into an existing worksheet
in the workbook, overwriting the old data that was there from the last
import.
Then I want to create a summary of about 6 or 7 fields from that worksheet
into another worksheet in the current workbook, apply some
styling/formatting then print it out.

The import/summary print is a job that will be done frequently but at
irregular intervals.

Has anyone done this or something similar? If so any advice on how to
automate the process as much as possible would be very much appreciated.

Hope that all makes sense as to what I want to achieve. Happy to provide
more details if it will help.

Joe Aquilina

--
View this message in context: 
http://nabble.documentfoundation.org/Calc-question-tp2654256p2654256.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***