[libreoffice-users] Issue with automating a simple process.

Have a shell script that creates 2 csv files with data that 
changes each quarter of year.

Script creates the files with about 600 lines.

Have a spreadsheet that then has external links to import 
data to cell A5:V600 from one and AA5:AV600 for other.
That works fine..

I added conditional formatting that compares the data 
between two groups to hightlight lines that are added or 
deleted between to sets of data. That also works fine at 
that point. 

Problem is: If I open the spreadsheet again, it reimports 
the data and in process wipes out all reference to the 
range A5:AV5xx and AA5:AV5xx leaving just cells 
between groups. Tried setting range to A1:AV600, but 
again, it seems importing information wipes out the 
conditional formatting.

I can manually go in and change the ranges back to 
A1:AV600 and that restores the formatting..

Tried recording a macro for that, but result is nothing 
was recorded. 
Also, trying to record the importing manually does seem 
to work either. 

Tried to create a Range name thinking that might keep it, 
but conditional formatting does except range names or 
absolute addresses??

Perhaps it can't be done.

But process is much better than original manually getting 
two sets of data to line up with manuall inserting cells.
Has about 46 records that are add/delete between data 
sets.

Perhaps there is something I'm missing.
 
+------------------------------------------------------------+
 Michael D. Setzer II - Computer Science Instructor 
(Retired)     
 mailto:mikes@guam.net                            
 mailto:msetzerii@gmail.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