[libreoffice-users] Trying to find way to automate process with 4 spreadsheets.

Have 4 spreadsheets that would import data from a csv file via 
external link and would then run an uniq sort on each one by 
different files
byname  - last and first
bytitle         - by title, last and first
bydept  - by dept, last and first
byphone - phone, last and first

Would save and export to pdf and csv
libreoffice --headless --convert-to pdf bydeptuog.ods bynameuog.ods 
byphoneuog.ods bytitleuog.ods

libreoffice --headless --convert-to csv bydeptuog.ods bynameuog.ods 
byphoneuog.ods bytitleuog.ods

That worked mostly, but one big issue. If one opened the pdf file 
with libreoffice it would try to do the external link. Generally, just 
sent the PDF files, so links no present.

So, created a bydate.ods file that had the link to the bydata.csv file.
Load the 5 spreadsheet.

In bydata.ods file, it imports the bydata.csv file.
In that file select a data range that is larger than actual data used, 
and then use Ctrl-C to copy it. 

Then manually go to each of the other 4 spreadsheets and past the 
new data.

Originally, tried to do the saved sorts in each file, but since data 
had different number of rows, it would treat it as a new sort.

So, in each of the spreadsheets created a larger range and redid 
sorts. name, dept, phone, title. 
So now have to select each spreadsheet, select range in that 
spreadsheet, and do sort and it works fine. 

Manual process takes about 8 minutes, and sometimes make 
errors. Don't know if there is any Macro or other method that 
would automate this process.

Recording definitely didn't work for macro.
Thanks.

+------------------------------------------------------------+
 Michael D. Setzer II - Computer Science Instructor (Retired)     
 mailto:mikes@guam.net                            
 mailto:msetzerii@gmail.com
 mailto:msetzerii@gmx.com
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy