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

2022-05-04 Thread Michael D. Setzer II 
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" 

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

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

2022-05-04 Thread Paul D. Mirowsky 
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: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

Re: [libreoffice-users] problem with file name with some dot on name

2022-05-04 Thread LO User 


*From:* Nilton Jose Rizzo [mailto:niltonri...@gmail.com]
*Sent:* Tuesday, May 3, 2022, 21:49 UTC
*To:* users@global.libreoffice.org
*Subject:* [libreoffice-users] problem with file name with some dot on name

> Hi all,
>
>
>     I found a problem using my LibreOffice 7.3.2.2 on FreeBSD 14-current.
>
>     If the file name has more then one dot (.) the file dialog to save
> as or export as PDF or other way to change a file name, only show all
> characters until first dot ocurrence.
>
>     One example is:
>
>         File.Name.Other.Name.odt  it will show as File.
>
>     The file extension (.odt or .pdf) not added on the end string
>
I am unable to reproduce this with 7.3.2.2 on Linux and Windows. Seems
like it could be a FreeBSD issue. Where are you seeing the truncated
file name?


-- 
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

Re: [bug] Re: [libreoffice-users] LibreOffice 7.3.3.2 Windows 64 bit seems not detect AdoptOpenJdk JRE Windows 64 bit runtime

2022-05-04 Thread Carlo Strata (tiscali.it) 
Thank you very much, I would have filed the bug in this afternoon 
because I just have finish to work, but since then I only say thank you.


Have a sunny day,

Carlo Strata

Il 04/05/22 14:36, Stephan Bergmann ha scritto:

On 04/05/2022 09:58, Stephan Bergmann wrote:

On 04/05/2022 08:58, carlo.str...@tiscali.it wrote:
Have I to file e bug? Can someone confirm the situation before I 
create the bug?


Looks broken indeed.  Please file a bug, put me on CC, and leave the 
bug ID here.


fix at  "Some JREs 
need the bin/server/jvm.dll path after all"





--
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

Re: [bug] Re: [libreoffice-users] LibreOffice 7.3.3.2 Windows 64 bit seems not detect AdoptOpenJdk JRE Windows 64 bit runtime

2022-05-04 Thread Stephan Bergmann 

On 04/05/2022 09:58, Stephan Bergmann wrote:

On 04/05/2022 08:58, carlo.str...@tiscali.it wrote:
Have I to file e bug? Can someone confirm the situation before I 
create the bug?


Looks broken indeed.  Please file a bug, put me on CC, and leave the bug 
ID here.


fix at  "Some JREs need 
the bin/server/jvm.dll path after all"



--
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

Re: [bug] Re: [libreoffice-users] LibreOffice 7.3.3.2 Windows 64 bit seems not detect AdoptOpenJdk JRE Windows 64 bit runtime

2022-05-04 Thread Stephan Bergmann 

On 04/05/2022 08:58, carlo.str...@tiscali.it wrote:
Have I to file e bug? Can someone confirm the situation before I create 
the bug?


Looks broken indeed.  Please file a bug, put me on CC, and leave the bug 
ID here.



--
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

[bug] Re: [libreoffice-users] LibreOffice 7.3.3.2 Windows 64 bit seems not detect AdoptOpenJdk JRE Windows 64 bit runtime

2022-05-04 Thread carlo . strata 

Hi Everyone,

I have just tried again:
Edizione Windows 10 Pro Education
Versione 21H2
Data installazione: ‎21/‎02/‎2022
Build sistema operativo 19044.1682
Esperienza Windows Feature Experience Pack 120.2212.4170.0

LibreOffice 7.2.5.2 x86_64 windows
--> correctly detects C:\Program Files\Semeru\jre-11.0.15.10-openj9bin

after unistalling it and installing
LibreOffice 7.3.3.2 x86_64 Windows (without and with Local italian help 
installed)
--> doesn't (!) detect C:\Program 
Files\Semeru\jre-11.0.15.10-openj9\bin


Have I to file e bug? Can someone confirm the situation before I create 
the bug?


Have a nice peaceful day,

Carlo

Il 02.05.2022 17:44 Carlo Strata (tiscali.it) ha scritto:


Hi Everyone,

there are some years that I didn't write to you, but I never stop use
and promote LO! ;-)

Just a little question before the near release of LibreOffice 
7.3.3.2.


In Windows environment I used to install the pre-release stable 
version.


I'm not sure (!) because I have tried only a few times in the Italian
School in which I teach, but both the next 7.3.3.1 and .2 Windows 64 
bit
builds seem not detect AdoptOpenJdk JRE Windows 64 bit runtime (I 
used

the ibm-semeru-open-jre_x64_windows_11.0.15_10_openj9-0.32.0.msi).

The 7.3.2.2 seems to detect it correctly, instead.

So, with respect to the release plan time, I prefer asking you if
someone has the same my doubt/suspect (I haven't found some open bugs
about it yet).

Have all a nice evening and make (open) code not war!

Carlo

-- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org 
[1]

Problems?

https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
[2] Posting guidelines + more:
https://wiki.documentfoundation.org/Netiquette [3] List archive:
https://listarchives.libreoffice.org/global/users/ [4] Privacy 
Policy:

https://www.documentfoundation.org/privacy [5]



Links:
--
[1] mailto:users+unsubscr...@global.libreoffice.org
[2] 
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

[3] https://wiki.documentfoundation.org/Netiquette
[4] https://listarchives.libreoffice.org/global/users/
[5] https://www.documentfoundation.org/privacy


Voucher MISE per P.IVA e PMI: fino a 2500€ per la Banda Ultralarga. 
https://casa.tiscali.it/promo/?u=https://promozioni.tiscali.it/voucher_business/?r=TS0A00025=link=tiscali_source=tiscali_medium=link_campaign=voucherbusiness_np=tiscali.link.footermail.voucherbusiness.btb..




--
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