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

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

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.