Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index

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 

Perhaps there is something I'm missing.
 Michael D. Setzer II - Computer Science Instructor 
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.