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

I apologize, but I do not know how Calc handles this function, but the 
logic is...

If A5 greater then zero, then end process

Hope this helps.


On 5/3/22 04:33, Michael D. Setzer II wrote:
> 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