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 [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
