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:mi...@guam.net mailto:msetze...@gmail.com mailto:msetze...@gmx.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ -- To unsubscribe e-mail to: users+unsubscr...@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
