On 4 May 2022 at 19:48, Paul D. Mirowsky wrote:
Date sent:Wed, 4 May 2022 19:48:06 -0400 Send reply to:p_mirow...@bentaxna.com Subject:Re: [libreoffice-users] Issue with automating a simple process. To:users@global.libreoffice.org From:"Paul D. Mirowsky" <p_mirow...@bentaxna.com> Organization:Bentax of North America, Inc. > I apologize, but I do not know how Calc handles this function, but the > logic is... > > If A5 greater then zero, then end process > The issues seems to be. I set conditional range to be A1:AAV600 and the conditional formatting works great. But, when I reload spreadsheet, the external link imports new data into A5:AV564 (at moment). If I check condition format range it has changed from A1:AV600 to A565:AV600,A1:AV4 and thus only applies to headings and empty cells were it does nothing. I can manually change it back to A1:AV600 and it works. But that requires manually FORMAT/CONDITIONAL/MANAGE/EDIT/CELL RANGE to change it. So 4 clicks change range and two OK clicks. Not a big deal, but wondering why range changes, or why absolute or range name is not an option?? > 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:mi...@guam.net > > mailto:msetze...@gmail.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 +------------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.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