Re: [libreoffice-users] Help with searching

[Tim Hoover]

Have you checked into using the auto filters option? Select all the columns in 
the sheet that you want to apply filtering, then go to Data > More Filters and 
select AutoFilter.

This will then add a drop down list to each column header that has options for 
sorting/searching. It may not be quite what you're looking for, but thought it 
might be worth checking out.

--
Thank you,
Tim Hoover


-- On Wed, 24 Jul 2024 15:29:11 -0400,  Clement @ Leitersburg Lawn & Garden LLC 
wrote: 
> I have a spreadsheet with parts for equipment. It has these columns:
> 
> SKU   MakeModel   TypeSerial
> 
> 
> To find a SKU number, I want to be able to have search boxes and enter
> the Make and Model and get the resulting search in a list of options
> that match.
> 
> 
> What feature should I implement to do this? Having problems using
> VLOOKUP. I guess I am too inexperienced to figure this out.
> 
> -- 
> Regards,
>  Clement Martin
> 
>  Leitersburg Lawn & Garden LLC
> 
>  Hagerstown, MD
> 
>  phone/fax--301-331-5872
> 
> 
> 
> 
> 
> -- 
> 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
>  
>


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

[libreoffice-users] Help with searching

[Clement @ Leitersburg Lawn & Garden LLC]

I have a spreadsheet with parts for equipment. It has these columns:

SKU MakeModel   TypeSerial


To find a SKU number, I want to be able to have search boxes and enter
the Make and Model and get the resulting search in a list of options
that match.


What feature should I implement to do this? Having problems using
VLOOKUP. I guess I am too inexperienced to figure this out.

-- 
Regards,
 Clement Martin

 Leitersburg Lawn & Garden LLC

 Hagerstown, MD

 phone/fax--301-331-5872





-- 
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] Help with failing AutoValue increment in LO Base table

[Harvey Nimmo]

On Sat, 2024-07-20 at 08:36 +0200, Robert Großkopf wrote:
> Am 20.07.24 um 08:16 schrieb Robert Großkopf:
> > Hi Harvey,
> > > > 
> > > I don't have mariadb installed on my desktop (which is LOBase
> > > client
> > > connectect via ethernet (hone zone) to mariadb on NAS sever)
> > 
> > There shouldn't be any difference between MariaDB on a Linux sytem 
> > connected through localhost or connected from another system in
> > your 
> > local network.
> > 
> > How did you create the connection to MariaDB to JDBC?
> > 
> > I could reproduce the behavior when I don't use the connection
> > through 
> > the MySQL/MariaDB-wizard but through JDBC direct.
> > 
> > I don't know how to get the right code for Base to set
> > autoincremented 
> > value through the GUI here at this moment. Seems it must be set in
> > the 
> > properties for incremented values…
> 
> Got it:
> 
> Go to Edit → Database → Advanced Settings → Generated values
> 
> Retrieve Generated Values → checked
> Auto-increment Statement: AUTO_INCREMENT
> Query of genetated vales doesn't need an entry.
> 
> Regards
> 
Aaaah Robert, you are a wizard! Who needs another?

Cheers
Harvey

-- 
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] Help with failing AutoValue increment in LO Base table

[Harvey Nimmo]

On Sat, 2024-07-20 at 08:16 +0200, Robert Großkopf wrote:
> 
> There shouldn't be any difference between MariaDB on a Linux sytem 
> connected through localhost or connected from another system in your 
> local network.
> 
> How did you create the connection to MariaDB to JDBC?
> 
> I could reproduce the behavior when I don't use the connection
> through 
> the MySQL/MariaDB-wizard but through JDBC direct.
> 
Yes, I connect through JDBC directly. 


Harvey

-- 
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] Help with failing AutoValue increment in LO Base table

[Robert Großkopf]

Am 20.07.24 um 08:16 schrieb Robert Großkopf:

Hi Harvey,



I don't have mariadb installed on my desktop (which is LOBase client
connectect via ethernet (hone zone) to mariadb on NAS sever)


There shouldn't be any difference between MariaDB on a Linux sytem 
connected through localhost or connected from another system in your 
local network.


How did you create the connection to MariaDB to JDBC?

I could reproduce the behavior when I don't use the connection through 
the MySQL/MariaDB-wizard but through JDBC direct.


I don't know how to get the right code for Base to set autoincremented 
value through the GUI here at this moment. Seems it must be set in the 
properties for incremented values…


Got it:

Go to Edit → Database → Advanced Settings → Generated values

Retrieve Generated Values → checked
Auto-increment Statement: AUTO_INCREMENT
Query of genetated vales doesn't need an entry.

Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/robert


--
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] Help with failing AutoValue increment in LO Base table

[Robert Großkopf]

Hi Harvey,



I don't have mariadb installed on my desktop (which is LOBase client
connectect via ethernet (hone zone) to mariadb on NAS sever)


There shouldn't be any difference between MariaDB on a Linux sytem 
connected through localhost or connected from another system in your 
local network.


How did you create the connection to MariaDB to JDBC?

I could reproduce the behavior when I don't use the connection through 
the MySQL/MariaDB-wizard but through JDBC direct.


I don't know how to get the right code for Base to set autoincremented 
value through the GUI here at this moment. Seems it must be set in the 
properties for incremented values…


Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/robert


--
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] help with find

[Rob Jasper]

What about
=ISERR(SEARCH("Nationwide";B1))+1


> Op 19 jul. 2024, om 23:30 heeft James  het volgende 
> geschreven:
> 
> I want to do something like this now:
> =IF(FIND("Nationwide", B1)>0,1,2)
> It works if "Nationwide" is found in B1 but I get #VALUE! if it is not found.
> I'm guessing because the FIND is not returning a number?
> 
> On 2024-07-16 23:41, Brian Barker wrote:
>> At 21:11 16/07/2024 -0400, James Lockie wrote:
>>> B1 = Data Nationwide
>>> B2 = =FIND("Nationwide", B1, 0)
>>> I get #VALUE!
>> 
>> Good! Your computer is working properly.
>> 
>> You have asked FIND() to start looking at the zeroth character in the text, 
>> which doesn't exist. The characters are the first, second, third, and so on. 
>> Try:
>> =FIND("Nationwide",B1,1)
>> or just:
>> =FIND("Nationwide",B1)
>> 
>> I trust this helps.
>> 
>> Brian Barker
>> 
> 
> -- 
> 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


-- 
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] help with find

[Brian Barker]

At 17:30 19/07/2024 -0400, James Lockie wrote:

I want to do something like this now:
=IF(FIND("Nationwide", B1)>0,1,2)
It works if "Nationwide" is found in B1 but I get #VALUE! if it is not found.
I'm guessing because the FIND is not returning a number?


Yes: FIND() itself returns error 519, alias #VALUE, in this case.

Try
=IF(ISNUMBER(FIND("Nationwide",B1)),1,2)
or
=IF(ISERROR(FIND("Nationwide",B1)),2,1)

I trust this helps.

Brian Barker


--
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] help with find

[James]

I want to do something like this now:
=IF(FIND("Nationwide", B1)>0,1,2)
It works if "Nationwide" is found in B1 but I get #VALUE! if it is not 
found.

I'm guessing because the FIND is not returning a number?

On 2024-07-16 23:41, Brian Barker wrote:

At 21:11 16/07/2024 -0400, James Lockie wrote:

B1 = Data Nationwide
B2 = =FIND("Nationwide", B1, 0)
I get #VALUE!


Good! Your computer is working properly.

You have asked FIND() to start looking at the zeroth character in the 
text, which doesn't exist. The characters are the first, second, 
third, and so on. Try:

=FIND("Nationwide",B1,1)
or just:
=FIND("Nationwide",B1)

I trust this helps.

Brian Barker



--
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] Help with failing AutoValue increment in LO Base table

[Harvey Nimmo]

On Fri, 2024-07-19 at 21:48 +0200, Robert Großkopf wrote:
> Hi Harvey,
> 
> tested with LO 24.2.5.2 and MariaDB on OpenSUSE 15.6 64bit rpm Linux.
> 
> Works well with internal driver, also with JDBC (mariadb-java-client
> 3.1.3)
> 
> Its the same behavior with special version LO 24.2.4.2 fronm OpenSUSE
> you use.
> 
> Note: A funny bug appears: The wizard (JDBC-connection) also offers 
> "AutoValue" when the content of the field is VARCHAR.
> 
I don't have mariadb installed on my desktop (which is LOBase client
connectect via ethernet (hone zone) to mariadb on NAS sever)

Yes, I noticed that funny bug, changing it to INT (10) and AutoValue is
OK at the moment. But after storing the new table and opening it again
for editing the AutoValue is =NO and not even editable.

I can indeed create a workable table using phpMyAdmin and/or LOBase SQL
syntax but that is far beyond the convenience of a pretty and efficient
graphical LOBase user interface (if only it worked!)

Cheers
Harvey

-- 
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] Help with failing AutoValue increment in LO Base table

[Robert Großkopf]

Hi Harvey,

tested with LO 24.2.5.2 and MariaDB on OpenSUSE 15.6 64bit rpm Linux.

Works well with internal driver, also with JDBC (mariadb-java-client 3.1.3)

Its the same behavior with special version LO 24.2.4.2 fronm OpenSUSE 
you use.


Note: A funny bug appears: The wizard (JDBC-connection) also offers 
"AutoValue" when the content of the field is VARCHAR.


Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/robert


--
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] Help with failing AutoValue increment in LO Base table

[Harvey Nimmo]

On Wed, 2024-07-17 at 09:02 -0400, Java Joe wrote:
> Different databases have different ways of implementing Auto-
> Increment
> or Serial numbers.
> 
> I expect this to be related to the database you're using (Mariadb), a
> Base compatibility issue but not really a bug.
> 

Until now, in the previous versions of LO, it worked fine. I have been
able to create tables in my mariadb/LObase configuration (even those
with more complex attributes) using the convenient, user-friendly
features of LOBase. 

So now having to resort to a cumbersome method like phpMyAdmin or
LOBase direct SQL to create a table (whose properties, by the way can
no longer be edited) is a big, disappointing step backwards! Pity.

Cheers
Harvey



-- 
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] Help with failing AutoValue increment in LO Base table

[Harvey Nimmo]

On Wed, 2024-07-17 at 09:02 -0400, Java Joe wrote:
> Different databases have different ways of implementing Auto-
> Increment
> or Serial numbers.
> 
> I expect this to be related to the database you're using (Mariadb), a
> Base compatibility issue but not really a bug.
> 
It hasn't been a problem with my LOBase/Mariadb configuration until LO
version 24.2.4.2 and existing tables with autovalue work as they always
did. However, I will see what I can do to investigate this.

Harvey
> On 7/17/24 07:20, Harvey Nimmo wrote:
> > I wonder if anyone else sees this issue with LOBase. It would be
> > good
> > to know, if it might be an issue to be addressed to the OpenSUSE
> > forum.
> 


-- 
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] Help with failing AutoValue increment in LO Base table

[Java Joe]

Different databases have different ways of implementing Auto-Increment
or Serial numbers.

I expect this to be related to the database you're using (Mariadb), a
Base compatibility issue but not really a bug.

I have no experience with Mariadb, but expect you can resolve your
problem by running the appropriate SQL command(s) to set the ID column
to your db-specific auto-increment type.  In PostgreSQL, for example,
you'd need to create a Sequence then set the default value of the ID
column to that sequence.

PostgreSQL example code:
CREATE SEQUENCE mytable_id_seq INCREMENT 1 START 1 CACHE 1;
ALTER TABLE mytable ALTER COLUMN ID SET DEFAULT
nextval('mytable_id_seq'::regclass);

Joe

On 7/17/24 07:20, Harvey Nimmo wrote:

I wonder if anyone else sees this issue with LOBase. It would be good
to know, if it might be an issue to be addressed to the OpenSUSE forum.


--
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] Help with failing AutoValue increment in LO Base table

[Harvey Nimmo]

I wonder if anyone else sees this issue with LOBase. It would be good
to know, if it might be an issue to be addressed to the OpenSUSE forum.

Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 2; OS: Linux 6.4; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Calc: threaded

Cheers
Harvey

On Tue, 2024-07-16 at 16:21 +0200, Harvey Nimmo wrote:
> Greetings!
> 
> I am running LO 24.2.4.2 on OpenSUSE Leap 156 with LOBase as desktop
> client to Mariadb backend on my home network. I wanted to create a
> new
> simple table in LOBase Design View with two columns (logevent as
> VARCHAR(100), ID as INT (primary key set)). The ID has AutoValue and
> Entry required both = Yes when saving the new table.
> 
> However, when reopening the table for editing the AutoValue is
> set to NO. Adding a row of text to the new table does not increment
> the
> ID value.
> 
> What is going on here?
> Is this a consequence of the network connection (using
> org.mariadb.jdbc.Driver) from the LOBase desktop client to Mariadb
> network backend?
> Am I doing something wrong?
> 
> I should say that all other tables (already existing before upgrading
> to LO version 24.2.4.2) still behave as they should in this respect.
> 
> Cheers
> Harvey
> 
> 


-- 
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] help with find

[Brian Barker]

At 21:11 16/07/2024 -0400, James Lockie wrote:

B1 = Data Nationwide
B2 = =FIND("Nationwide", B1, 0)
I get #VALUE!


Good! Your computer is working properly.

You have asked FIND() to start looking at the zeroth character in the 
text, which doesn't exist. The characters are the first, second, 
third, and so on. Try:

=FIND("Nationwide",B1,1)
or just:
=FIND("Nationwide",B1)

I trust this helps.

Brian Barker


--
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] help with find

[tim lloyd]

Hi, I changed the third parameter from 0 to 1 and it works

=FIND("Nationwide", B1, 2)


Sent with Proton Mail secure email.

On Wednesday, July 17th, 2024 at 11:11 AM, James  wrote:

> B1 = Data Nationwide
> B2 = =FIND("Nationwide", B1, 0)
> I get #VALUE!
> 
> --
> 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

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

[libreoffice-users] help with find

[James]

B1 = Data Nationwide
B2 = =FIND("Nationwide", B1, 0)
I get #VALUE!

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

[libreoffice-users] Help with failing AutoValue increment in LO Base table

[Harvey Nimmo]

Greetings!

I am running LO 24.2.4.2 on OpenSUSE Leap 156 with LOBase as desktop
client to Mariadb backend on my home network. I wanted to create a new
simple table in LOBase Design View with two columns (logevent as
VARCHAR(100), ID as INT (primary key set)). The ID has AutoValue and
Entry required both = Yes when saving the new table.

However, when reopening the table for editing the AutoValue is
set to NO. Adding a row of text to the new table does not increment the
ID value.

What is going on here?
Is this a consequence of the network connection (using
org.mariadb.jdbc.Driver) from the LOBase desktop client to Mariadb
network backend?
Am I doing something wrong?

I should say that all other tables (already existing before upgrading
to LO version 24.2.4.2) still behave as they should in this respect.

Cheers
Harvey


-- 
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] Help with conditional formatting (Calc)

[Paul Goyette]

On Sat, 25 May 2024, Rob Jasper wrote:


Paul,

Yes, you should use a formula as condition.
To use a formula as condition:

Go to Format -> Conditional -> condition -> More rules -> formula:

$C$3=$Sheet1.$A$14
And use A5:J10 as range (if you select the range before defining the 
conditional formatting LO sets it automatically).

Succes


I could've sworn that I had tried that, but I guess not.

It works - thanks!




Op 25 mei 2024, om 14:20 heeft Paul Goyette  het volgende 
geschreven:

I've read the docs, and tried several ways, but I cannot seem to
get it right.

I'd like to apply conditional formatting to a group of cells, based
on the value of one cell in the group.  Something like

In cell range a5:j10, if the row-N column-C entry is equal
to "sheet.$row$column", apply format to the entire range
a-N:j-N

Is this possible?


+-+--+--+
| Paul Goyette (.sig) | PGP Key fingerprint: | E-mail addresses:|
| (Retired)   | 1B11 1849 721C 56C8 F63A | p...@whooppee.com|
| Software Developer  | 6E2E 05FD 15CE 9F2D 5102 | pgoye...@netbsd.org  |
| & Network Engineer  |  | pgoyett...@gmail.com |
+-+--+--+

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




!DSPAM:6651f84817981359412487!




+-+--+--+
| Paul Goyette (.sig) | PGP Key fingerprint: | E-mail addresses:|
| (Retired)   | 1B11 1849 721C 56C8 F63A | p...@whooppee.com|
| Software Developer  | 6E2E 05FD 15CE 9F2D 5102 | pgoye...@netbsd.org  |
| & Network Engineer  |  | pgoyett...@gmail.com |
+-+--+--+

--
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] Help with conditional formatting (Calc)

[Rob Jasper]

Paul,

Yes, you should use a formula as condition. 
To use a formula as condition:

Go to Format -> Conditional -> condition -> More rules -> formula:

$C$3=$Sheet1.$A$14
And use A5:J10 as range (if you select the range before defining the 
conditional formatting LO sets it automatically).

Succes

> Op 25 mei 2024, om 14:20 heeft Paul Goyette  het volgende 
> geschreven:
> 
> I've read the docs, and tried several ways, but I cannot seem to
> get it right.
> 
> I'd like to apply conditional formatting to a group of cells, based
> on the value of one cell in the group.  Something like
> 
>   In cell range a5:j10, if the row-N column-C entry is equal
>   to "sheet.$row$column", apply format to the entire range
>   a-N:j-N
> 
> Is this possible?
>  
> 
> +-+--+--+
> | Paul Goyette (.sig) | PGP Key fingerprint: | E-mail addresses:|
> | (Retired)   | 1B11 1849 721C 56C8 F63A | p...@whooppee.com|
> | Software Developer  | 6E2E 05FD 15CE 9F2D 5102 | pgoye...@netbsd.org  |
> | & Network Engineer  |  | pgoyett...@gmail.com |
> +-+--+--+
> 
> -- 
> 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
> 


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

[libreoffice-users] Help with conditional formatting (Calc)

[Paul Goyette]

I've read the docs, and tried several ways, but I cannot seem to
get it right.

I'd like to apply conditional formatting to a group of cells, based
on the value of one cell in the group.  Something like

In cell range a5:j10, if the row-N column-C entry is equal
to "sheet.$row$column", apply format to the entire range
a-N:j-N

Is this possible?


+-+--+--+
| Paul Goyette (.sig) | PGP Key fingerprint: | E-mail addresses:|
| (Retired)   | 1B11 1849 721C 56C8 F63A | p...@whooppee.com|
| Software Developer  | 6E2E 05FD 15CE 9F2D 5102 | pgoye...@netbsd.org  |
| & Network Engineer  |  | pgoyett...@gmail.com |
+-+--+--+

--
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] Help for Libreoffice portable

[Dave Howorth]

On Wed, 15 May 2024 16:14:31 -0300
ady  wrote:

> > I would like to get help for LibreOffice
> > portable in Czech. Is it somewhere to download it, please? Best
> > regards  
> 
> For the (Windows) portable package, the offline help is available in
> English only.
> 
> In the LibreOffice download site, you could select to download a Help
> package to _install_, but I am not sure how it would work with your
> _portable_ version. I guess you really need to know what you are doing
> in order to mix these 2 packages. Generally speaking, I wouldn't
> recommend it.
> 
> Since you are using the portable package, I guess that the simplest
> way to read the help content in Czech would be to read it on-line:
> 
> For LO 7.6:
> 

FWIW that link is unusable for me. As are each of the others below. They
all take me to
https://help.libreoffice.org/latest/en-US/text/swriter/main.html

which sits there apparently constantly reloading the page. This is
using FF 115.11.0esr with the NoScript add-on that is set to disable
scripting on 'new' sites such as this one is to my browser.

wget appears to fetch and save the correct new_help.html but I haven't
investigated to see what FF finds so objectionable.

> For LO 24.2:
> 
> 
> For the "latest" version (a moving target):
> 
> 
> HTH,
> Ady.

-- 
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] Help for Libreoffice portable

[ady]

> I would like to get help for LibreOffice
> portable in Czech. Is it somewhere to download it, please? Best regards

For the (Windows) portable package, the offline help is available in
English only.

In the LibreOffice download site, you could select to download a Help
package to _install_, but I am not sure how it would work with your
_portable_ version. I guess you really need to know what you are doing
in order to mix these 2 packages. Generally speaking, I wouldn't
recommend it.

Since you are using the portable package, I guess that the simplest
way to read the help content in Czech would be to read it on-line:

For LO 7.6:


For LO 24.2:


For the "latest" version (a moving target):


HTH,
Ady.

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

[libreoffice-users] Help for Libreoffice portable

[Jarek Krcmar]

Greetings to the group, I would like to get help for LibreOffice 
portable in Czech. Is it somewhere to download it, please? Best regards

--
Jarek

--
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] Help - how to get rid of 'administrator'

[Alan B]

Emily,

The following presumes you use Windows.

This is a test to attempt to isolate the problem...
* Use a thumb drive (USB drive) ,
* create and save a file to the thumb drive (use Write, Calc, or whichever
program you use most)
* close the program used to create the file
* eject the thumb drive
* right click the drive and pick the "Eject" option
* wait for the safe to remove message (this must be done to prevent
file corruption)
* remove the drive
* open the program again
* insert the thumb drive
* open the file and test if you can edit and save or not

If it is possible to edit and save the file on the thumb drive then the
problem is most likely the security settings for the location the files are
being saved to on the computer.

BUT even if files on the thumb drive can be edited and saved with
LibreOffice while those on the computer cannot be, there is still another
bit of info that's needed. Using other programs is it possible to
create/edit/save files to the same place on the computer as the LibreOffice
files?

If other files also can not be created/edited/saved to the same place with
other programs (the same problem as with LibreOffice) then the culprit is
nearly certainly the computer's security settings for that location.

If only the LibreOffice files can not be created/edited/saved then more
investigation into the files and LibreOffice installation will be needed.

If you try the above, please provide an update so we know if it is only
LibreOffice doing this (so likely an LO problem to work out) or other
programs do it too (so likely a computer security problem).

Knowing the above will help with troubleshooting and resolving the problem.

On Wed, Mar 6, 2024 at 5:00 PM Emily Scharf 
wrote:

> I have used Libreoffice for years. But recently I downloaded it and -
> mistakenly - responded to an option for greater security.  This turns out
> to be 'administrator' which continually blocks me from anything but
> read-only documents.
>
> How do I turn off the 'administrator'?  I even tried to uninstall and
> download again and it is still happening with my documents..
>
> If I cannot stop the 'administrator' I will be forced to use another
> programme (though I have used LibreOffice for years)
>
> Thank you for your help.
>
> Emily from London
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Help - how to get rid of 'administrator'

[John]

FYI, on Fedora Linux using Libre Office 7.5.9.2 there is a "Restart in Safe 
Mode" function on the
"help" pop down menu.  About halfway down the menu.  If you clicked this is may 
have a "leave safe
mode" or equivalent in the same place because I don't have the "Start in Test 
Mode" function on this
menu.

Hope that may be of some asistance.

John
==
On Wed, 2024-03-06 at 23:40 +0100, aguador wrote:
> 
> 
> El mié, 06-03-2024 a las 23:16 +0100, Philip Jackson escribió:
> > Are you sure this isn't a Windows' problem? Typically it's Windows
> > that has stuff blocked and restricted to those with administrator
> > privileges.
> > Philip
> > 
> > On 06/03/2024 22:56, Emily Scharf wrote:
> > > I have used Libreoffice for years. But recently I downloaded it and
> > > -
> > > mistakenly - responded to an option for greater security.  This
> > > turns out
> > > to be 'administrator' which continually blocks me from anything but
> > > read-only documents.
> > > 
> > > How do I turn off the 'administrator'?  I even tried to uninstall
> > > and
> > > download again and it is still happening with my documents..
> > > 
> > > If I cannot stop the 'administrator' I will be forced to use
> > > another
> > > programme (though I have used LibreOffice for years)
> > > 
> > > Thank you for your help.
> > > 
> > > Emily from London
> 
> Hi Emily,
> 
> I am not on LO 24 yet, but I suspect there is a way to do it from with
> the program. Lacking that knowledge, the first thing that occurs to me
> is to try with a new profile. Your profile remains even you re-install
> or update and that is where your settings are saved.
> 
> You can test this by going to Help and choosing Start in Test Mode.
> That will ignore your profile and, if it works, you can find your
> LibreOffice profile folder and rename it. When you restart you will
> have to redo your settings, although you can very likely copy most of
> the components from your old folder.
> 
> Wish I could be more specific, but without knowing the OS or the latest
> LO you're using, its a bit harder.
> 
> Hope this helps a bit,
> Roy
> 


-- 
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] Help - how to get rid of 'administrator'

[aguador]

El mié, 06-03-2024 a las 23:16 +0100, Philip Jackson escribió:
> Are you sure this isn't a Windows' problem? Typically it's Windows
> that has stuff blocked and restricted to those with administrator
> privileges.
> Philip
> 
> On 06/03/2024 22:56, Emily Scharf wrote:
> > I have used Libreoffice for years. But recently I downloaded it and
> > -
> > mistakenly - responded to an option for greater security.  This
> > turns out
> > to be 'administrator' which continually blocks me from anything but
> > read-only documents.
> > 
> > How do I turn off the 'administrator'?  I even tried to uninstall
> > and
> > download again and it is still happening with my documents..
> > 
> > If I cannot stop the 'administrator' I will be forced to use
> > another
> > programme (though I have used LibreOffice for years)
> > 
> > Thank you for your help.
> > 
> > Emily from London

Hi Emily,

I am not on LO 24 yet, but I suspect there is a way to do it from with
the program. Lacking that knowledge, the first thing that occurs to me
is to try with a new profile. Your profile remains even you re-install
or update and that is where your settings are saved.

You can test this by going to Help and choosing Start in Test Mode.
That will ignore your profile and, if it works, you can find your
LibreOffice profile folder and rename it. When you restart you will
have to redo your settings, although you can very likely copy most of
the components from your old folder.

Wish I could be more specific, but without knowing the OS or the latest
LO you're using, its a bit harder.

Hope this helps a bit,
Roy

-- 
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] Help - how to get rid of 'administrator'

[Philip Jackson]

Are you sure this isn't a Windows' problem? Typically it's Windows that has 
stuff blocked and restricted to those with administrator privileges.
Philip

On 06/03/2024 22:56, Emily Scharf wrote:

I have used Libreoffice for years. But recently I downloaded it and -
mistakenly - responded to an option for greater security.  This turns out
to be 'administrator' which continually blocks me from anything but
read-only documents.

How do I turn off the 'administrator'?  I even tried to uninstall and
download again and it is still happening with my documents..

If I cannot stop the 'administrator' I will be forced to use another
programme (though I have used LibreOffice for years)

Thank you for your help.

Emily from London

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

[libreoffice-users] Help - how to get rid of 'administrator'

[Emily Scharf]

I have used Libreoffice for years. But recently I downloaded it and -
mistakenly - responded to an option for greater security.  This turns out
to be 'administrator' which continually blocks me from anything but
read-only documents.

How do I turn off the 'administrator'?  I even tried to uninstall and
download again and it is still happening with my documents..

If I cannot stop the 'administrator' I will be forced to use another
programme (though I have used LibreOffice for years)

Thank you for your help.

Emily from London

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

[libreoffice-users] Help with Formulas

[Elad Magdasi]

Dear LibreOffice team,

Thank you so much for developing this amazing tool.
I am using Python to dynamically write formulas in my LibreOffice file.
However, I am noticing when LibreOffice opens the file, it adds an extra
")" at the end of the formula which results in a bad formula:

Here is my print log from the script:
[image: image.png]

and here are the actual formulas:
[image: image.png]

=SUM($'2024'.C17))
=SUM($'2024'.C34))

and so on..

Why is that? Is there a way to overcome it?

No matter what I do via code, it doesn't work. If I open the file in Google
Sheets for example, the formula shows correctly.

Any suggestions?

Thanks a lot

Elad

-- 

*Elad Magdasi*he/him

ghostm...@gmail.com |
*+49-17643309939*

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

[libreoffice-users] Help

[mynameisblueorange]

 
 
 
An error popped up it says, BASIC runtime error. Property or method not found: 
CellAddress  
 
I don't know what to do
 

 

 

 
 
 
-- 
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] Help: Convert a Multi-Page Text/word file to PNG using LibreOffice API in JAVA

[Dave Howorth]

On Sun, 29 Oct 2023 17:17:48 +
Madhu Patel  wrote:

> Hi folks,
> 
> It would be great if I can get an official response and/or update in
> the documentation, so that we can forward the dependency proceedings
> internally.

Please don't send individual copies of any replies to me. I read the
list. And please don't top post. And why have you stillnot explained
what was wrong with the previous suggested workaround?

If you want professional support, you might like to look at
https://www.libreoffice.org/get-help/professional-support/

> Thanks
> 
> From: Madhu Patel 
> Date: Monday, 9 October 2023 at 3:03 PM
> To: Dave Howorth , users@global.libreoffice.org
> , documentfoundat...@maxired.fr
> , aguador 
> Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word
> file to PNG using LibreOffice API in JAVA Hi folks,
> 
> It would be great if I can get an official response and/or update in
> the documentation, so that we can forward the dependency proceedings
> internally.
> 
> Thanks
> 
> From: Madhu Patel 
> Date: Saturday, 30 September 2023 at 8:50 PM
> To: Dave Howorth , users@global.libreoffice.org
> , documentfoundat...@maxired.fr
> , aguador 
> Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word
> file to PNG using LibreOffice API in JAVA From: Dave Howorth
>  Date: Thursday, 28 September 2023 at 1:47 AM
> To: users@global.libreoffice.org 
> Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word
> file to PNG using LibreOffice API in JAVA EXTERNAL: Use caution when
> clicking on links or opening attachments.
> 
> 
> On Tue, 26 Sep 2023 14:46:07 +
> Madhu Patel  wrote:
> 
> > Can someone please direct me to the documentation about conversion
> > of Multi-page of Text file to PNG using LibreOffice API.
> >
> > Bug link-
> > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.documentfoundation.org%2Fshow_bug.cgi%3Fid%3D157425&data=05%7C01%7Cmadhup%40adobe.com%7C615113b640074ca7e1f908dbbf96ba8f%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C638314426344958861%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=2I2ntKjnoH5u3ufEGZI0YyOMjeVpGboOuAaVRFEJo90%3D&reserved=0<https://bugs.documentfoundation.org/show_bug.cgi?id=157425>
> >
> > Ref:-
> > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FLibreOffice%2FUNOHelper%2Fissues%2F41%23issuecomment-1732949888&data=05%7C01%7Cmadhup%40adobe.com%7C615113b640074ca7e1f908dbbf96ba8f%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C638314426344958861%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=aRi2sjMa9E51OIYAGLyu9ntjr0suF%2Fg9ZssPNZzzYWE%3D&reserved=0<https://github.com/LibreOffice/UNOHelper/issues/41#issuecomment-1732949888>
> >
> >
> > If it is not possible to convert a Multi-page text file to PNG using
> > LibreOffice, where it is mentioned in the documentation.  Should I
> > send a PR for this, if it is not.
> >
> > Thanks for your time.
> >
> > From: aguador 
> > Date: Tuesday, 26 September 2023 at 2:49 PM
> > To: users@global.libreoffice.org 
> > Subject: Re: [libreoffice-users] Help: Convert a Multi-Page
> > Text/word file to PNG using LibreOffice API in JAVA EXTERNAL: Use
> > caution when clicking on links or opening attachments.
> >
> >
> > El lun, 25-09-2023 a las 04:20 +, Madhu Patel escribió:  
> > > Hey folks!
> > >
> > > How to convert a Multi-Page Text file to PNG, for example:- I
> > > have a Text document of 5 pages and I want to convert that into
> > > PNG. By default, it's giving a PNG of only 1st page. How to get
> > > the PNG file for ith page using LibreOffice.
> > > I used the PageRange filter like this, but it does not work, it's
> > > also giving the PNG only for 1st page.
> > > Also, I'm not able to generate multiple PNGs for multi-page word
> > > files using the LibreOffice Application
> > > CLI:-
> > > soffice --convert-to
> > > 'png:writer_png_Export:{"PageRange":{"type":"string","value":"2-"}}'
> > > test.odt
> > >
> > > JAVA:-
> > > conversionProperties[0] = new com.sun.star.beans.PropertyValue();
> > > conversionProperties[0].Name = "FilterName";
> > > conversionProperties[0].Value ="writer_png_Export";
> > >
> > > conversionProperties[1] = new com.sun.star.beans.PropertyValue();
> > > conversionProperties[1

Re: [libreoffice-users] Help: Convert a Multi-Page Text/word file to PNG using LibreOffice API in JAVA

[Madhu Patel]

Hi folks,

It would be great if I can get an official response and/or update in the 
documentation, so that we can forward the dependency proceedings internally.

Thanks

From: Madhu Patel 
Date: Monday, 9 October 2023 at 3:03 PM
To: Dave Howorth , users@global.libreoffice.org 
, documentfoundat...@maxired.fr 
, aguador 
Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word file to 
PNG using LibreOffice API in JAVA
Hi folks,

It would be great if I can get an official response and/or update in the 
documentation, so that we can forward the dependency proceedings internally.

Thanks

From: Madhu Patel 
Date: Saturday, 30 September 2023 at 8:50 PM
To: Dave Howorth , users@global.libreoffice.org 
, documentfoundat...@maxired.fr 
, aguador 
Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word file to 
PNG using LibreOffice API in JAVA
From: Dave Howorth 
Date: Thursday, 28 September 2023 at 1:47 AM
To: users@global.libreoffice.org 
Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word file to 
PNG using LibreOffice API in JAVA
EXTERNAL: Use caution when clicking on links or opening attachments.


On Tue, 26 Sep 2023 14:46:07 +
Madhu Patel  wrote:

> Can someone please direct me to the documentation about conversion of
> Multi-page of Text file to PNG using LibreOffice API.
>
> Bug link- 
> https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.documentfoundation.org%2Fshow_bug.cgi%3Fid%3D157425&data=05%7C01%7Cmadhup%40adobe.com%7C615113b640074ca7e1f908dbbf96ba8f%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C638314426344958861%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=2I2ntKjnoH5u3ufEGZI0YyOMjeVpGboOuAaVRFEJo90%3D&reserved=0<https://bugs.documentfoundation.org/show_bug.cgi?id=157425>
>
> Ref:-
> https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FLibreOffice%2FUNOHelper%2Fissues%2F41%23issuecomment-1732949888&data=05%7C01%7Cmadhup%40adobe.com%7C615113b640074ca7e1f908dbbf96ba8f%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C638314426344958861%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=aRi2sjMa9E51OIYAGLyu9ntjr0suF%2Fg9ZssPNZzzYWE%3D&reserved=0<https://github.com/LibreOffice/UNOHelper/issues/41#issuecomment-1732949888>
>
>
> If it is not possible to convert a Multi-page text file to PNG using
> LibreOffice, where it is mentioned in the documentation.  Should I
> send a PR for this, if it is not.
>
> Thanks for your time.
>
> From: aguador 
> Date: Tuesday, 26 September 2023 at 2:49 PM
> To: users@global.libreoffice.org 
> Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word
> file to PNG using LibreOffice API in JAVA EXTERNAL: Use caution when
> clicking on links or opening attachments.
>
>
> El lun, 25-09-2023 a las 04:20 +, Madhu Patel escribió:
> > Hey folks!
> >
> > How to convert a Multi-Page Text file to PNG, for example:- I have a
> > Text document of 5 pages and I want to convert that into PNG. By
> > default, it's giving a PNG of only 1st page. How to get the PNG file
> > for ith page using LibreOffice.
> > I used the PageRange filter like this, but it does not work, it's
> > also giving the PNG only for 1st page.
> > Also, I'm not able to generate multiple PNGs for multi-page word
> > files using the LibreOffice Application
> > CLI:-
> > soffice --convert-to
> > 'png:writer_png_Export:{"PageRange":{"type":"string","value":"2-"}}'
> > test.odt
> >
> > JAVA:-
> > conversionProperties[0] = new com.sun.star.beans.PropertyValue();
> > conversionProperties[0].Name = "FilterName";
> > conversionProperties[0].Value ="writer_png_Export";
> >
> > conversionProperties[1] = new com.sun.star.beans.PropertyValue();
> > conversionProperties[1].Name = "PageRange";
> > conversionProperties[1].Value ="2-";
> >
> > thanks!
> >
> This does not really solve the direct conversion problem, but given
> that the document is short, why no export pdfs of each page and then
> convert them to png?

Aguador, can you please link me the API documentation to convert 5 pages of PDF 
to PNG, one by one, or together in one go.

Given 5 pages of PDF, LibreOffice API converts only first page to PNG. 
LibreOffice API, do not have any Page Exacter or indexer where [i]th page of 
one file containing 5 pages of PDF can be extracted.




>
> Best,
> aguador

Why are you top-posting a new post instead of responding to what
aguador wrote? Please learn email etiquette (and bug reporting
etiquette!)

An

Re: [libreoffice-users] Help: Convert a Multi-Page Text/word file to PNG using LibreOffice API in JAVA

[Madhu Patel]

From: Dave Howorth 
Date: Thursday, 28 September 2023 at 1:47 AM
To: users@global.libreoffice.org 
Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word file to 
PNG using LibreOffice API in JAVA
EXTERNAL: Use caution when clicking on links or opening attachments.


On Tue, 26 Sep 2023 14:46:07 +
Madhu Patel  wrote:

> Can someone please direct me to the documentation about conversion of
> Multi-page of Text file to PNG using LibreOffice API.
>
> Bug link- 
> https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.documentfoundation.org%2Fshow_bug.cgi%3Fid%3D157425&data=05%7C01%7Cmadhup%40adobe.com%7C615113b640074ca7e1f908dbbf96ba8f%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C638314426344958861%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=2I2ntKjnoH5u3ufEGZI0YyOMjeVpGboOuAaVRFEJo90%3D&reserved=0<https://bugs.documentfoundation.org/show_bug.cgi?id=157425>
>
> Ref:-
> https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FLibreOffice%2FUNOHelper%2Fissues%2F41%23issuecomment-1732949888&data=05%7C01%7Cmadhup%40adobe.com%7C615113b640074ca7e1f908dbbf96ba8f%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C638314426344958861%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=aRi2sjMa9E51OIYAGLyu9ntjr0suF%2Fg9ZssPNZzzYWE%3D&reserved=0<https://github.com/LibreOffice/UNOHelper/issues/41#issuecomment-1732949888>
>
>
> If it is not possible to convert a Multi-page text file to PNG using
> LibreOffice, where it is mentioned in the documentation.  Should I
> send a PR for this, if it is not.
>
> Thanks for your time.
>
> From: aguador 
> Date: Tuesday, 26 September 2023 at 2:49 PM
> To: users@global.libreoffice.org 
> Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word
> file to PNG using LibreOffice API in JAVA EXTERNAL: Use caution when
> clicking on links or opening attachments.
>
>
> El lun, 25-09-2023 a las 04:20 +, Madhu Patel escribió:
> > Hey folks!
> >
> > How to convert a Multi-Page Text file to PNG, for example:- I have a
> > Text document of 5 pages and I want to convert that into PNG. By
> > default, it's giving a PNG of only 1st page. How to get the PNG file
> > for ith page using LibreOffice.
> > I used the PageRange filter like this, but it does not work, it's
> > also giving the PNG only for 1st page.
> > Also, I'm not able to generate multiple PNGs for multi-page word
> > files using the LibreOffice Application
> > CLI:-
> > soffice --convert-to
> > 'png:writer_png_Export:{"PageRange":{"type":"string","value":"2-"}}'
> > test.odt
> >
> > JAVA:-
> > conversionProperties[0] = new com.sun.star.beans.PropertyValue();
> > conversionProperties[0].Name = "FilterName";
> > conversionProperties[0].Value ="writer_png_Export";
> >
> > conversionProperties[1] = new com.sun.star.beans.PropertyValue();
> > conversionProperties[1].Name = "PageRange";
> > conversionProperties[1].Value ="2-";
> >
> > thanks!
> >
> This does not really solve the direct conversion problem, but given
> that the document is short, why no export pdfs of each page and then
> convert them to png?

Aguador, can you please link me the API documentation to convert 5 pages of PDF 
to PNG, one by one, or together in one go.

Given 5 pages of PDF, LibreOffice API converts only first page to PNG. 
LibreOffice API, do not have any Page Exacter or indexer where [i]th page of 
one file containing 5 pages of PDF can be extracted.


>
> Best,
> aguador

Why are you top-posting a new post instead of responding to what
aguador wrote? Please learn email etiquette (and bug reporting
etiquette!)

And why are you ignoring the suggestion, given that is what is already
posted as a workaround in the bug report you linked to? If it won't
work for you, you need to explain why.

Dave, Aguador: CC’ing the person who responded with a textual workaround which 
seems to be inefficient and is non documented in LibreOffice API for further 
explanation or a link to API endpoint.

Dave: Can you please link me to LibreOffice API documentation to convert a 
multi-page text file to single page or multi-page PNG. If it’s not possible, do 
you think there should be proper documentation for the same.

Devs, maintainers: One workaround to convert a multi-page text file to PNG is 
to extract each page text and store into buffer streams (JAVA programming 
language concept) and then write that text as PNG. For a huge file, or a 
on-the-fly stream of files, say, 10KB to 100KB, this p

Re: [libreoffice-users] Help: Convert a Multi-Page Text/word file to PNG using LibreOffice API in JAVA

[Dave Howorth]

On Tue, 26 Sep 2023 14:46:07 +
Madhu Patel  wrote:

> Can someone please direct me to the documentation about conversion of
> Multi-page of Text file to PNG using LibreOffice API.
> 
> Bug link- https://bugs.documentfoundation.org/show_bug.cgi?id=157425
> 
> Ref:-
> https://github.com/LibreOffice/UNOHelper/issues/41#issuecomment-1732949888
> 
> 
> If it is not possible to convert a Multi-page text file to PNG using
> LibreOffice, where it is mentioned in the documentation.  Should I
> send a PR for this, if it is not.
> 
> Thanks for your time.
> 
> From: aguador 
> Date: Tuesday, 26 September 2023 at 2:49 PM
> To: users@global.libreoffice.org 
> Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word
> file to PNG using LibreOffice API in JAVA EXTERNAL: Use caution when
> clicking on links or opening attachments.
> 
> 
> El lun, 25-09-2023 a las 04:20 +, Madhu Patel escribió:
> > Hey folks!
> >
> > How to convert a Multi-Page Text file to PNG, for example:- I have a
> > Text document of 5 pages and I want to convert that into PNG. By
> > default, it's giving a PNG of only 1st page. How to get the PNG file
> > for ith page using LibreOffice.
> > I used the PageRange filter like this, but it does not work, it's
> > also giving the PNG only for 1st page.
> > Also, I'm not able to generate multiple PNGs for multi-page word
> > files using the LibreOffice Application
> > CLI:-
> > soffice --convert-to
> > 'png:writer_png_Export:{"PageRange":{"type":"string","value":"2-"}}'
> > test.odt
> >
> > JAVA:-
> > conversionProperties[0] = new com.sun.star.beans.PropertyValue();
> > conversionProperties[0].Name = "FilterName";
> > conversionProperties[0].Value ="writer_png_Export";
> >
> > conversionProperties[1] = new com.sun.star.beans.PropertyValue();
> > conversionProperties[1].Name = "PageRange";
> > conversionProperties[1].Value ="2-";
> >
> > thanks!
> >  
> This does not really solve the direct conversion problem, but given
> that the document is short, why no export pdfs of each page and then
> convert them to png?
> 
> Best,
> aguador

Why are you top-posting a new post instead of responding to what
aguador wrote? Please learn email etiquette (and bug reporting
etiquette!)

And why are you ignoring the suggestion, given that is what is already
posted as a workaround in the bug report you linked to? If it won't
work for you, you need to explain why.

-- 
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] Help: Convert a Multi-Page Text/word file to PNG using LibreOffice API in JAVA

[Madhu Patel]

Can someone please direct me to the documentation about conversion of 
Multi-page of Text file to PNG using LibreOffice API.

Bug link- https://bugs.documentfoundation.org/show_bug.cgi?id=157425

Ref:- https://github.com/LibreOffice/UNOHelper/issues/41#issuecomment-1732949888


If it is not possible to convert a Multi-page text file to PNG using 
LibreOffice, where it is mentioned in the documentation.  Should I send a PR 
for this, if it is not.

Thanks for your time.

From: aguador 
Date: Tuesday, 26 September 2023 at 2:49 PM
To: users@global.libreoffice.org 
Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word file to 
PNG using LibreOffice API in JAVA
EXTERNAL: Use caution when clicking on links or opening attachments.


El lun, 25-09-2023 a las 04:20 +, Madhu Patel escribió:
> Hey folks!
>
> How to convert a Multi-Page Text file to PNG, for example:- I have a
> Text document of 5 pages and I want to convert that into PNG. By
> default, it's giving a PNG of only 1st page. How to get the PNG file
> for ith page using LibreOffice.
> I used the PageRange filter like this, but it does not work, it's
> also giving the PNG only for 1st page.
> Also, I'm not able to generate multiple PNGs for multi-page word
> files using the LibreOffice Application
> CLI:-
> soffice --convert-to
> 'png:writer_png_Export:{"PageRange":{"type":"string","value":"2-"}}'
> test.odt
>
> JAVA:-
> conversionProperties[0] = new com.sun.star.beans.PropertyValue();
> conversionProperties[0].Name = "FilterName";
> conversionProperties[0].Value ="writer_png_Export";
>
> conversionProperties[1] = new com.sun.star.beans.PropertyValue();
> conversionProperties[1].Name = "PageRange";
> conversionProperties[1].Value ="2-";
>
> thanks!
>
This does not really solve the direct conversion problem, but given
that the document is short, why no export pdfs of each page and then
convert them to png?

Best,
aguador



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? 
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.libreoffice.org%2Fget-help%2Fmailing-lists%2Fhow-to-unsubscribe%2F&data=05%7C01%7Cmadhup%40adobe.com%7C6c3c47f211c04cc0f2a308dbbe71bebe%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C638313167966025522%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=AnsTWngAlUyYeK%2BhKCz3WtwY96oL2%2BcCi%2FqxwJINSEA%3D&reserved=0<https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more: 
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.documentfoundation.org%2FNetiquette&data=05%7C01%7Cmadhup%40adobe.com%7C6c3c47f211c04cc0f2a308dbbe71bebe%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C638313167966025522%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=lNVKvaXVE%2FozM0xzPnAxB9DD8%2BccfQcrsFKbOhHGmfw%3D&reserved=0<https://wiki.documentfoundation.org/Netiquette>
List archive: 
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flistarchives.libreoffice.org%2Fglobal%2Fusers%2F&data=05%7C01%7Cmadhup%40adobe.com%7C6c3c47f211c04cc0f2a308dbbe71bebe%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C638313167966025522%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=a9bt9MndrW8AutLAGveoh34t4i2W9LIp25t0hKhlLco%3D&reserved=0<https://listarchives.libreoffice.org/global/users/>
Privacy Policy: 
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.documentfoundation.org%2Fprivacy&data=05%7C01%7Cmadhup%40adobe.com%7C6c3c47f211c04cc0f2a308dbbe71bebe%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C638313167966025522%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=oPNevqpp%2BLTismqTC0QP0kNTdtc8xXkfA1PnYBWSRW8%3D&reserved=0<https://www.documentfoundation.org/privacy>

-- 
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] Help: Convert a Multi-Page Text/word file to PNG using LibreOffice API in JAVA

[aguador]

El lun, 25-09-2023 a las 04:20 +, Madhu Patel escribió:
> Hey folks!
>
> How to convert a Multi-Page Text file to PNG, for example:- I have a
> Text document of 5 pages and I want to convert that into PNG. By
> default, it's giving a PNG of only 1st page. How to get the PNG file
> for ith page using LibreOffice.
> I used the PageRange filter like this, but it does not work, it's
> also giving the PNG only for 1st page.
> Also, I'm not able to generate multiple PNGs for multi-page word
> files using the LibreOffice Application
> CLI:-
> soffice --convert-to
> 'png:writer_png_Export:{"PageRange":{"type":"string","value":"2-"}}'
> test.odt
>
> JAVA:-
> conversionProperties[0] = new com.sun.star.beans.PropertyValue();
> conversionProperties[0].Name = "FilterName";
> conversionProperties[0].Value ="writer_png_Export";
>
> conversionProperties[1] = new com.sun.star.beans.PropertyValue();
> conversionProperties[1].Name = "PageRange";
> conversionProperties[1].Value ="2-";
>
> thanks!
>
This does not really solve the direct conversion problem, but given
that the document is short, why no export pdfs of each page and then
convert them to png?

Best,
aguador



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

[libreoffice-users] Help: Convert a Multi-Page Text/word file to PNG using LibreOffice API in JAVA

[Madhu Patel]

Hey folks!

How to convert a Multi-Page Text file to PNG, for example:- I have a Text 
document of 5 pages and I want to convert that into PNG. By default, it's 
giving a PNG of only 1st page. How to get the PNG file for ith page using 
LibreOffice.
I used the PageRange filter like this, but it does not work, it's also giving 
the PNG only for 1st page.
Also, I'm not able to generate multiple PNGs for multi-page word files using 
the LibreOffice Application
CLI:-
soffice --convert-to 
'png:writer_png_Export:{"PageRange":{"type":"string","value":"2-"}}' test.odt

JAVA:-
conversionProperties[0] = new com.sun.star.beans.PropertyValue();
conversionProperties[0].Name = "FilterName";
conversionProperties[0].Value ="writer_png_Export";

conversionProperties[1] = new com.sun.star.beans.PropertyValue();
conversionProperties[1].Name = "PageRange";
conversionProperties[1].Value ="2-";

thanks!



-- 
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] Help please with multipage document.

[Brad Rogers]

On Fri, 7 Jul 2023 12:40:08 +0100
Dave Howorth  wrote:

Hello Dave,

>It's an 8-page document and opens exactly as I would expect with each
>page shown above the next page. I'm not sure how else to expect a
>document to be shown?

Pages can be displayed separate sheets, side by side, or where each page
is displayed as if they were in an open book.  That is, evens on the
left, odds on the right of a landscape oriented piece of paper.

>If you can see the whole document, it sounds like you need to adjust
>the zoom level (View Menu/Zoom) and choose Entire Page or somesuch.

Good point - one others, myself included, neglected to mention.

-- 
 Regards  _   "Valid sig separator is {dash}{dash}{space}"
 / )  "The blindingly obvious is never immediately apparent"
/ _)rad   "Is it only me that has a working delete key?"
Every single one of us
Devil Inside - INXS

-- 
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] Help please with multipage document.

[Dave Howorth]

On Thu, 6 Jul 2023 21:19:51 +0100
Brad Rogers  wrote:

> On Thu, 6 Jul 2023 20:39:41 +0100
> Budge  wrote:
> 
> Hello Budge,
> 
> >I see the screenshot didn't copy.  Is this a settings thing here or
> >rule for the site?  
> 
> _All_ attachments are stripped.
> 
> Document opened fine here.  Yes, it opened as a single column, but you
> can change that by selecting one of the other two layout icons in the
> bottom toolbar (assuming default layout of LO).

It's an 8-page document and opens exactly as I would expect with each
page shown above the next page. I'm not sure how else to expect a
document to be shown?

If you can see the whole document, it sounds like you need to adjust
the zoom level (View Menu/Zoom) and choose Entire Page or somesuch.

-- 
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] Help please with multipage document.

[Budge]

Hi Regina,
You have it exactly.  Now I have what I want so very many thanks.

Thanks also to all who helped.
All good for now thanks.
Budge.

On 06/07/2023 21:20, Regina Henschel wrote:

Hi Budge,

Budge schrieb am 06.07.2023 um 17:15:

I have downloaded a document from the VistitBritain/VisitEngland website which 
is in which is in a Windows 2007 .docx format.
When I open the document it LibreOffice Writer it opens to show 7 pages all at 
once and showing in the same window.

How may I break this down into individual pages within the document please so I 
may work on each page and then page down?


You can decide, whether to show bottom/top margins and a little distance between 
the pager or to show a continues text without bottom/top margins. That setting is 
in menu View > item Whitespace.

Further have a look at the right side of the status bar. There are the icons "Single page view", 
"Multi-page view" and "Book view". They determine how the pages are arranged in the 
working area.

When you click on the percent value of the zoom field in the status bar a dialog opens. 
There you can select between often used presets, e.g. "Fit width and height".

In all cases you come to the next page by scrolling of you use the PgUp and 
PgDn keys. If you want to jump to a specific page you can enter the page number 
in the Navigator in the side bar or use the shortcut Strg+G and enter the 
target page name there.

The text is a continues text and page breaks are calculated dynamically. 
Microsoft Word works the same way. That makes office suites different from 
desktop publishing applications.



Hope somebody can help me with this as I have never seen this format before!


I hope when you play around with the settings you can solve your problem. If 
not, please make a screenshot available. You cannot attach it to the mail. 
Attachments are automatically removed for this mailing list.

Kind regards,
Regina




--
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] Help please with multipage document.

[Alan B]

With the link, thank you, I see that opening the document always shows me a
full screen view with thumbnails of all seven pages. If that is what you
mean by "it opens to show 7 pages all at once and showing in the same
window" then...

Use the "View > Zoom" menu and select a page view that works for you.

On Thu, Jul 6, 2023 at 11:15 AM Budge  wrote:

> I have downloaded a document from the VistitBritain/VisitEngland website
> which is in which is in a Windows 2007 .docx format.
> When I open the document it LibreOffice Writer it opens to show 7 pages
> all at once and showing in the same window.
>
> How may I break this down into individual pages within the document please
> so I may work on each page and then page down?
>
> Hope somebody can help me with this as I have never seen this format
> before!
> Budge
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Help please with multipage document.

[Regina Henschel]

Hi Budge,

Budge schrieb am 06.07.2023 um 17:15:
I have downloaded a document from the VistitBritain/VisitEngland website 
which is in which is in a Windows 2007 .docx format.
When I open the document it LibreOffice Writer it opens to show 7 pages 
all at once and showing in the same window.


How may I break this down into individual pages within the document 
please so I may work on each page and then page down?


You can decide, whether to show bottom/top margins and a little distance 
between the pager or to show a continues text without bottom/top 
margins. That setting is in menu View > item Whitespace.


Further have a look at the right side of the status bar. There are the 
icons "Single page view", "Multi-page view" and "Book view". They 
determine how the pages are arranged in the working area.


When you click on the percent value of the zoom field in the status bar 
a dialog opens. There you can select between often used presets, e.g. 
"Fit width and height".


In all cases you come to the next page by scrolling of you use the PgUp 
and PgDn keys. If you want to jump to a specific page you can enter the 
page number in the Navigator in the side bar or use the shortcut Strg+G 
and enter the target page name there.


The text is a continues text and page breaks are calculated dynamically. 
Microsoft Word works the same way. That makes office suites different 
from desktop publishing applications.




Hope somebody can help me with this as I have never seen this format 
before!


I hope when you play around with the settings you can solve your 
problem. If not, please make a screenshot available. You cannot attach 
it to the mail. Attachments are automatically removed for this mailing list.


Kind regards,
Regina

--
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] Help please with multipage document.

[Brad Rogers]

On Thu, 6 Jul 2023 20:39:41 +0100
Budge  wrote:

Hello Budge,

>I see the screenshot didn't copy.  Is this a settings thing here or
>rule for the site?

_All_ attachments are stripped.

Document opened fine here.  Yes, it opened as a single column, but you
can change that by selecting one of the other two layout icons in the
bottom toolbar (assuming default layout of LO).

-- 
 Regards  _   "Valid sig separator is {dash}{dash}{space}"
 / )  "The blindingly obvious is never immediately apparent"
/ _)rad   "Is it only me that has a working delete key?"
I can't do a thing 'cause I can't relax
Independence Day - Comsat Angels

-- 
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] Help please with multipage document.

[Alan B]

Which website? There are visitbritain . com and . org

And what file name or document title?

With the above info, others can attempt to open it and solve the problem.

I've tried opening several .docx downloaded from the . org site. All opened
with no issue in LO 6.4.x


On Thu, Jul 6, 2023 at 11:15 AM Budge  wrote:

> I have downloaded a document from the VistitBritain/VisitEngland website
> which is in which is in a Windows 2007 .docx format.
> When I open the document it LibreOffice Writer it opens to show 7 pages
> all at once and showing in the same window.
>
> How may I break this down into individual pages within the document please
> so I may work on each page and then page down?
>
> Hope somebody can help me with this as I have never seen this format
> before!
> Budge
>
> --
> 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
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Help please with multipage document.

[John Kaufmann]

On 2023-07-06 15:39, Budge wrote:

I see the screenshot didn't copy.  Is this a settings thing here or rule for 
the site?


The list works in plain text, not HTML, and does not take attachments. If you 
want to show a screenshot, best to use a sharing service like Dropbox and cite 
the URL.

--
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] Help please with multipage document.

[Budge]

I see the screenshot didn't copy.  Is this a settings thing here or rule for 
the site?

On 06/07/2023 20:37, Budge wrote:

Hi all,
Sorry I was distracted earlier.
Here is the link:-

https://www.visitbritain.org/sites/default/files/vb-corporate/business-hub/resources/visitengland_fire_risk_assessment_template_for_tourism_businesses_march2023.docx

opened it in another machine and it opened slightly differently in that the 
pages are in a column.  See screenshot:-



Hope this does the same for you or I am stuck on how to solve it.

On 06/07/2023 20:25, Dave Howorth wrote:

On Thu, 6 Jul 2023 16:42:26 +0100
Brad Rogers  wrote:


On Thu, 6 Jul 2023 16:15:34 +0100
Budge  wrote:

Hello Budge,


How may I break this down into individual pages within the document
please so I may work on each page and then page down?

I could only find one .docx file there and it opened fine.

I found one 5 pages long at visitengland and one 3 pages long at
visitbritain :( They both opened fine :)

As Steve suggests, posting the URL of the failing document would be
helpful.







--
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] Help please with multipage document.

[Budge]

Hi all,
Sorry I was distracted earlier.
Here is the link:-

https://www.visitbritain.org/sites/default/files/vb-corporate/business-hub/resources/visitengland_fire_risk_assessment_template_for_tourism_businesses_march2023.docx

opened it in another machine and it opened slightly differently in that the 
pages are in a column.  See screenshot:-



Hope this does the same for you or I am stuck on how to solve it.

On 06/07/2023 20:25, Dave Howorth wrote:

On Thu, 6 Jul 2023 16:42:26 +0100
Brad Rogers  wrote:


On Thu, 6 Jul 2023 16:15:34 +0100
Budge  wrote:

Hello Budge,


How may I break this down into individual pages within the document
please so I may work on each page and then page down?

I could only find one .docx file there and it opened fine.

I found one 5 pages long at visitengland and one 3 pages long at
visitbritain :( They both opened fine :)

As Steve suggests, posting the URL of the failing document would be
helpful.




--
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] Help please with multipage document.

[Dave Howorth]

On Thu, 6 Jul 2023 16:42:26 +0100
Brad Rogers  wrote:

> On Thu, 6 Jul 2023 16:15:34 +0100
> Budge  wrote:
> 
> Hello Budge,
> 
> >How may I break this down into individual pages within the document
> >please so I may work on each page and then page down?  
> 
> I could only find one .docx file there and it opened fine.

I found one 5 pages long at visitengland and one 3 pages long at
visitbritain :( They both opened fine :)

As Steve suggests, posting the URL of the failing document would be
helpful.

-- 
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] Help please with multipage document.

[Steve Edmonds]

Brad is doing better than me, may be include the link to be sure we are 
on the same page, so to speak.

steve

On 7/07/23 03:15, Budge wrote:
I have downloaded a document from the VistitBritain/VisitEngland 
website which is in which is in a Windows 2007 .docx format.
When I open the document it LibreOffice Writer it opens to show 7 
pages all at once and showing in the same window.


How may I break this down into individual pages within the document 
please so I may work on each page and then page down?


Hope somebody can help me with this as I have never seen this format 
before!

Budge




--
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] Help please with multipage document.

[Brad Rogers]

On Thu, 6 Jul 2023 16:15:34 +0100
Budge  wrote:

Hello Budge,

>How may I break this down into individual pages within the document
>please so I may work on each page and then page down?

I could only find one .docx file there and it opened fine.

-- 
 Regards  _   "Valid sig separator is {dash}{dash}{space}"
 / )  "The blindingly obvious is never immediately apparent"
/ _)rad   "Is it only me that has a working delete key?"
The deadbeats and the dispossessed, the seekers of unlikeliness
Street Of Dreams - The Damned

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

[libreoffice-users] Help please with multipage document.

[Budge]

I have downloaded a document from the VistitBritain/VisitEngland website which 
is in which is in a Windows 2007 .docx format.
When I open the document it LibreOffice Writer it opens to show 7 pages all at 
once and showing in the same window.

How may I break this down into individual pages within the document please so I 
may work on each page and then page down?

Hope somebody can help me with this as I have never seen this format before!
Budge

--
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] Help finding the last piece of writing

[Dave Howorth]

On Tue, 6 Jun 2023 10:50:47 +0100
Angeline Ball  wrote:

> Hi there,
> I am in a blind panic.
> I am trying to find a writing document I am working on.
> I have saved it at various times but really wanted the last one I
> worked on. I always save it but can’t seem to find it at the moment.
> It usually appears in my desktop I put all of them into a file but
> when I open libre it’s not showing the most recent version I worked
> on. Can anyone please help me.

In addition to all the other good suggestions, you might want to check
whether there is a backup of it. On my computer everything is under
~/.config/libreoffice and there are many files in a backup directory a
couple of levels down from there. You can check whether backups are
enabled using the Tools/Options/'Load/Save'/General menu/dialog and you
can check the exact place in Tools/Options/Libreoffice/Paths

> Thank you,
> Angeline 
> 
> Sent from my iPhone


-- 
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] Help finding the last piece of writing

[Thomas Cameron]

On 6/6/23 2:50 AM, Angeline Ball wrote:

Hi there,
I am in a blind panic.
I am trying to find a writing document I am working on.
I have saved it at various times but really wanted the last one I 
worked on.

I always save it but can’t seem to find it at the moment.
It usually appears in my desktop I put all of them into a file but 
when I open libre it’s not showing the most recent version I worked on.

Can anyone please help me.

Thank you,
Angeline

Sent from my iPhone


I don't know if it helps, but usually, when I choose File/Open, in LO, 
it opens the last place I saved. Also, if you go to File/Recent 
Documents, do you see your doc there?


Thomas

--
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] Help finding the last piece of writing

[James Knott]

On 2023-06-06 11:26, Tom wrote:
This is a long shot but maybe use your operating system's file 
manager/explorer and sort various folders where you save documents 
(Desktop, Documents, etc) by date and see if you can locate the file 
that way?


On Linux, you could probably use the find command.


--
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] Help finding the last piece of writing

[Tom]

This is a long shot but maybe use your operating system's file 
manager/explorer and sort various folders where you save documents 
(Desktop, Documents, etc) by date and see if you can locate the file 
that way?


Peace...

Tom

On 6/6/23 2:50 AM, Angeline Ball wrote:

Hi there,
I am in a blind panic.
I am trying to find a writing document I am working on.
I have saved it at various times but really wanted the last one I worked on.
I always save it but can’t seem to find it at the moment.
It usually appears in my desktop I put all of them into a file but when I open 
libre it’s not showing the most recent version I worked on.
Can anyone please help me.

Thank you,
Angeline

Sent from my iPhone


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

[libreoffice-users] Help finding the last piece of writing

[Angeline Ball]

Hi there,
I am in a blind panic.
I am trying to find a writing document I am working on.
I have saved it at various times but really wanted the last one I worked on.
I always save it but can’t seem to find it at the moment.
It usually appears in my desktop I put all of them into a file but when I open 
libre it’s not showing the most recent version I worked on.
Can anyone please help me.

Thank you,
Angeline 

Sent from my iPhone
-- 
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] Help with Impress

[Harald Berger]

Hi Greg,

Am 18.11.2022 um 16:19 schrieb Gregory Forster:

Hi Herald,

I checked your references, but I did not see any profile.

What I did with both computers, I totally deleted LibreOffice, 
deleted  all references to LibreOffice including the entire folders 
C:\Program Files\LibreOffice, 
C:\Users\Greg\AppData\Roaming\LibreOffice. I  then  ran CCleaner, 
including running  the registry cleaner, I then ran Privazer, then 
rebooted.


I then did a clean, new download of LibreOffice, the Help file and 
documentations in pdf format. I had to re-enter all my preferences. I 
have java on my laptop, but not on the desktop. I was  able to 
download java a few weeks ago. The java web site now would not let me 
download java on either computer using Windows Edge, or Firefox. I 
kept getting a 503 error.  Do  I really need java, other than the 
database?

https://wiki.documentfoundation.org/Faq/General/015

Best Regards
Harald


I don't know if Impress will work yet, I haven't tried it yet. I 
completed the original presentation project, despite it's continual 
crashing. I have to figure out a new project to try.


Thank you for responding.

Greg

On 11/11/2022 2:40 PM, lo.harald.ber...@t-online.de wrote:

Hi Gregory,

it's a pity that it doesn't work properly for you.

Please have a look at the points in the following link:
https://wiki.documentfoundation.org/QA/FirstSteps

Test steps 3 and 2 from there, in that order, to see if it brings 
improvement.


If this is not helpful, I would ask you to upload your Impress file 
somewhere in the cloud and post the link here.


So that someone can look at the file, test and investigate whether 
there are also problems. Thank you.


Best Regards
Harald

Am 11.11.2022 um 18:34 schrieb Gregory Forster:

Hi

    Recently, I volunteered to teach computer classes at a senior 
center.  I'm teaching Excel, Word, Power Point, etc. I'm trying to 
promote LibreOffice.  I use LibreOffice at home. However, I am 
having an extremely difficult time with LibreOffice Impress. After 
saving after every new slide, LibreOffice crashes on me.   I send 
the crash report, restore the program, then I have to reposition the 
last slide (What was slide 13, is now slide 12). My presentation is 
only 15 slides. In other words, LibreOffice crashed 15 times!


    I am using LibreOffice vs 7.4.2.3 on a Windows 10 vs 10.0.19044 
laptop.


    I want to do a presentation on LibreOffice using Impress, but 
not with that nonsense.









--
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] Help with Impress

[LO . Harald . Berger]

Hi Greg,

Am 18.11.2022 um 16:19 schrieb Gregory Forster:

Hi Herald,

I checked your references, but I did not see any profile.

What I did with both computers, I totally deleted LibreOffice, 
deleted  all references to LibreOffice including the entire folders 
C:\Program Files\LibreOffice, 
C:\Users\Greg\AppData\Roaming\LibreOffice. I  then  ran CCleaner, 
including running  the registry cleaner, I then ran Privazer, then 
rebooted.


I then did a clean, new download of LibreOffice, the Help file and 
documentations in pdf format. I had to re-enter all my preferences. I 
have java on my laptop, but not on the desktop. I was  able to 
download java a few weeks ago. The java web site now would not let me 
download java on either computer using Windows Edge, or Firefox. I 
kept getting a 503 error.  Do  I really need java, other than the 
database?

https://wiki.documentfoundation.org/Faq/General/015

Best Regards
Harald


I don't know if Impress will work yet, I haven't tried it yet. I 
completed the original presentation project, despite it's continual 
crashing. I have to figure out a new project to try.


Thank you for responding.

Greg

On 11/11/2022 2:40 PM, lo.harald.ber...@t-online.de wrote:

Hi Gregory,

it's a pity that it doesn't work properly for you.

Please have a look at the points in the following link:
https://wiki.documentfoundation.org/QA/FirstSteps

Test steps 3 and 2 from there, in that order, to see if it brings 
improvement.


If this is not helpful, I would ask you to upload your Impress file 
somewhere in the cloud and post the link here.


So that someone can look at the file, test and investigate whether 
there are also problems. Thank you.


Best Regards
Harald

Am 11.11.2022 um 18:34 schrieb Gregory Forster:

Hi

    Recently, I volunteered to teach computer classes at a senior 
center.  I'm teaching Excel, Word, Power Point, etc. I'm trying to 
promote LibreOffice.  I use LibreOffice at home. However, I am 
having an extremely difficult time with LibreOffice Impress. After 
saving after every new slide, LibreOffice crashes on me.   I send 
the crash report, restore the program, then I have to reposition the 
last slide (What was slide 13, is now slide 12). My presentation is 
only 15 slides. In other words, LibreOffice crashed 15 times!


    I am using LibreOffice vs 7.4.2.3 on a Windows 10 vs 10.0.19044 
laptop.


    I want to do a presentation on LibreOffice using Impress, but 
not with that nonsense.










--
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] Help with Impress

[Paul D. Mirowsky]

By any chance, did you start by importing a Power Point?

On 11/11/22 12:34, Gregory Forster wrote:

Hi

    Recently, I volunteered to teach computer classes at a senior 
center.  I'm teaching Excel, Word, Power Point, etc. I'm trying to 
promote LibreOffice.  I use LibreOffice at home.  However, I am having 
an extremely difficult time with LibreOffice Impress. After saving 
after every new slide, LibreOffice crashes on me.   I send the crash 
report, restore the program, then I have to reposition the last slide 
(What was slide 13, is now slide 12). My presentation is only 15 
slides.  In other words, LibreOffice crashed 15 times!


    I am using LibreOffice vs 7.4.2.3 on a Windows 10 vs 10.0.19044 
laptop.


    I want to do a presentation on LibreOffice using Impress, but not 
with that nonsense.




--
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] Help with Impress

[Ade Malsasa Akbar]

Hello Gregory,

I teach LibreOffice class with many students and now they use Impress
7.4 too. All succeeded  doing presentations with 20-50 slides without
any crash. However, they all use GNU/Linux. So I can confirm at least
Impress 7.4 works normally on GNU/Linux.

Firstly, could you send your presentation file here? It might help
others to examine and reproduce the issues.

Secondly, as a suggestion, you might consider to try several different
versions of LibreOffice on Windows 10 and see which one works normally
for you and use the working one (I always do this). Experience told me
the latest version is not always the best.

Sincerely yours,

Ade Malsasa Akbar

-- 
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] Help with Impress

[LO . Harald . Berger]

Hi Gregory,

it's a pity that it doesn't work properly for you.

Please have a look at the points in the following link:
https://wiki.documentfoundation.org/QA/FirstSteps

Test steps 3 and 2 from there, in that order, to see if it brings 
improvement.


If this is not helpful, I would ask you to upload your Impress file 
somewhere in the cloud and post the link here.


So that someone can look at the file, test and investigate whether there 
are also problems. Thank you.


Best Regards
Harald

Am 11.11.2022 um 18:34 schrieb Gregory Forster:

Hi

    Recently, I volunteered to teach computer classes at a senior 
center.  I'm teaching Excel, Word, Power Point, etc. I'm trying to 
promote LibreOffice.  I use LibreOffice at home.  However, I am having 
an extremely difficult time with LibreOffice Impress. After saving 
after every new slide, LibreOffice crashes on me.   I send the crash 
report, restore the program, then I have to reposition the last slide 
(What was slide 13, is now slide 12). My presentation is only 15 
slides.  In other words, LibreOffice crashed 15 times!


    I am using LibreOffice vs 7.4.2.3 on a Windows 10 vs 10.0.19044 
laptop.


    I want to do a presentation on LibreOffice using Impress, but not 
with that nonsense.






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

[libreoffice-users] Help with Impress

[Gregory Forster]

Hi

    Recently, I volunteered to teach computer classes at a senior 
center.  I'm teaching Excel, Word, Power Point, etc. I'm trying to 
promote LibreOffice.  I use LibreOffice at home.  However, I am having 
an extremely difficult time with LibreOffice Impress. After saving after 
every new slide, LibreOffice crashes on me.   I send the crash report, 
restore the program, then I have to reposition the last slide (What was 
slide 13, is now slide 12). My presentation is only 15 slides.  In other 
words, LibreOffice crashed 15 times!


    I am using LibreOffice vs 7.4.2.3 on a Windows 10 vs 10.0.19044 laptop.

    I want to do a presentation on LibreOffice using Impress, but not 
with that nonsense.



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

[Steve Edmonds]

What version of LO and what operating system do you have.

On 01/09/2022 03:14, Bids BR HVAC wrote:

Why is my LibreOffice Calc doing this?
The dropdown bars are all blacked out.
The number column is all janky. The numbers are stacked on top of each
other and gets worse when I scroll down.
When I open Calc there is a big section of the page that turns pink, but
not in any specific spot. It is totally random and goes away once I scroll.
I would take a screenshot to show what I mean, but I cannot read the
dropdowns to get me to that point due to them being blacked out.
WHAT AM I TO DO?




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

[libreoffice-users] HELP

[Bids BR HVAC]

Why is my LibreOffice Calc doing this?
The dropdown bars are all blacked out.
The number column is all janky. The numbers are stacked on top of each
other and gets worse when I scroll down.
When I open Calc there is a big section of the page that turns pink, but
not in any specific spot. It is totally random and goes away once I scroll.
I would take a screenshot to show what I mean, but I cannot read the
dropdowns to get me to that point due to them being blacked out.
WHAT AM I TO DO?

-- 
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] Help with find & replace. [SOLVED]

[Michael D. Setzer II]

On 17 Mar 2022 at 9:49, Dave Barton wrote:

Subject:Re: [libreoffice-users] Help with find & 
replace. [SOLVED]
To: users@global.libreoffice.org
From:   Dave Barton 
Date sent:  Thu, 17 Mar 2022 09:49:41 +

> On 16/03/2022 16:29, Dave Barton wrote:
> > I am looking for a find & replace solution in Writer, where there is a
> > blank space as the last character of a paragraph
> > (eg. last word ).
> 
> Thanks to all who replied.
> 

No problem. That is what support lists are suppose to do. 
Glad you got a solution.


> Dave
> 
> 
> 
> -- 
> 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] Help with find & replace. [SOLVED]

[Dave Barton]

On 16/03/2022 16:29, Dave Barton wrote:
> I am looking for a find & replace solution in Writer, where there is a
> blank space as the last character of a paragraph
> (eg. last word ).

Thanks to all who replied.

Dave



-- 
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] Help with find & replace.

[V Stuart Foote]

Dave, *

LibreOffice uses the ICU Regular Expression libraries. Full documentation is 
here:

https://unicode-org.github.io/icu/userguide/strings/regexp.html

While the projects documentation for its use is here:

https://help.libreoffice.org/7.3/en-US/text/shared/01/0211.html

https://help.libreoffice.org/latest/bs/text/swriter/guide/search_regexp.html

There have been a number of tweaks for handling new line/end of para that you 
can track in Bugzilla.

Stuart


From: Dave Barton 
Sent: Wednesday, March 16, 2022 5:21 PM
To: users@global.libreoffice.org 
Subject: [EXTERNAL] Re: [libreoffice-users] Help with find & replace.

  **EXTERNAL EMAIL**
  This email originated outside of The University of Texas at San Antonio.
  Please exercise caution when clicking on links or opening attachments.



Hi jomali,

Would you care to elaborate and provide links?

Dave

On 16/03/2022 22:04, jomali wrote:
> I just looked at LibreOffice help, searched for Regular Expressions,
> selected the list of regular expressions, and found all of the info you are
> looking for..
>
> On Wed, Mar 16, 2022 at 5:55 PM Dave Barton  wrote:
>
>>
>> Fantastic, but why does the LO project *_NOT_* inform it's users about
>> this *_HIDDEN_* option?
>>
>> Please provide links to the the TDF/LO Help/Documentation files that
>> provide this information to our users.
>>


-- 
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] Help with find & replace.

[Dave Barton]

Hi jomali,

Would you care to elaborate and provide links?

Dave

On 16/03/2022 22:04, jomali wrote:
> I just looked at LibreOffice help, searched for Regular Expressions,
> selected the list of regular expressions, and found all of the info you are
> looking for..
> 
> On Wed, Mar 16, 2022 at 5:55 PM Dave Barton  wrote:
> 
>>
>> Fantastic, but why does the LO project *_NOT_* inform it's users about
>> this *_HIDDEN_* option?
>>
>> Please provide links to the the TDF/LO Help/Documentation files that
>> provide this information to our users.
>>
>>  Original Message 
>> From: Michael D. Setzer II [mailto:msetze...@gmail.com]
>> Sent: Wednesday, March 16, 2022, 20:53 UTC
>> To: Dave Barton; users@global.libreoffice.org
>> Subject: [libreoffice-users] Help with find & replace.
>>
>>> On 16 Mar 2022 at 20:41, Dave Barton wrote:
>>>
>>> Subject:  Re: [libreoffice-users] Help with find &
>>> replace.
>>> To:   users@global.libreoffice.org
>>> From: Dave Barton 
>>> Date sent:Wed, 16 Mar 2022 20:41:43 +
>>>
>>>> On 16/03/2022 20:01, Steve Edmonds wrote:
>>>>>
>>>>>
>>>>> On 17/03/2022 08:34, Dave Barton wrote:
>>>>>> On 16/03/2022 18:27, Brian Barker wrote:
>>>>>>> At 16:29 16/03/2022 +, Dave Barton wrote:
>>>>>>>> I am looking for a find & replace solution in Writer, where there
>> is a
>>>>>>>> blank space as the last character of a paragraph (eg. last word
>>>>>>>> ). In the original OOo and most of the text editors I
>>>>>>>> use the simple solution that worked/works perfectly is: Find =
>>>>>>>> $ Replace = $ (Note: I use  here to represent a single
>>>>>>>> space character). This does not work in LO Writer, so I am forced to
>>>>>>>> fiddle around copying from LO and pasting into AOO, running F&R in
>>>>>>>> AOO, then copy/paste back again. Any pointers would be welcome.
>>>>>>> I'm surprised that exactly what you say works in OpenOffice. Don't
>> you
>>>>>>> need to find space-dollar, just as you describe, but to replace with
>>>>>>> nothing? Replacing with dollar will surely insert an unwanted dollar
>>>>>>> character?
>>>>>>>
>>>>>>> Or have you forgotten to click "Other options" in the Find and
>> Replace
>>>>>>> dialogue and to tick "Regular expressions"?
>>>>>>>
>>>>>>> I trust this helps.
>>>>>>>
>>>>>>> Brian Barker
>>>>>> Hi Brian,
>>>>>>
>>>>>> After 22 Years of you and I being involved in this project, I
>> genuinely
>>>>>> bow to your superior knowledge in this area. However, I do assure you
>>>>>> that the convoluted LO->AOO->LO� nonsense works for me, exactly as it
>>>>>> did in the days of OOo.
>>>>>>
>>>>>> No, I have not forgotten to click "Other options in the Find and
>> Replace
>>>>>> dialogue and to tick "Regular expressions", please see my screen
>> capture:
>>>>>> https://www.mediafire.com/view/80552jkp3qw6o8x/F%2526R_LO.png/file
>>>>>>
>>>>>> Here is a very simplistic file illustrating the 
>>>>>> paragraph endings:
>>>>>> https://www.mediafire.com/file/vmixa9r4dhjpc9e/F%2526R_LO.odt/file
>>>>>>
>>>>>> Version: 7.3.1.3 (x64) / LibreOffice Community
>>>>>> Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
>>>>>> CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL:
>>>>>> win
>>>>>> Locale: es-ES (en_IE); UI: en-US
>>>>>> Calc: threaded
>>>>>>
>>>>>> If you can please show me where I am going wrong, I would be extremely
>>>>>> grateful.
>>>>>>
>>>>>> Dave Barton
>>>>>>
>>>>>>
>>>>> May be this is sorted and I have received the emails out of order, but
>>>>> assuming you just want to remove the trailing space from each line,
>> both
>>>>> Johnny's and Mic

Re: [libreoffice-users] Help with find & replace.

[jomali]

I just looked at LibreOffice help, searched for Regular Expressions,
selected the list of regular expressions, and found all of the info you are
looking for..

On Wed, Mar 16, 2022 at 5:55 PM Dave Barton  wrote:

>
> Fantastic, but why does the LO project *_NOT_* inform it's users about
> this *_HIDDEN_* option?
>
> Please provide links to the the TDF/LO Help/Documentation files that
> provide this information to our users.
>
>  Original Message 
> From: Michael D. Setzer II [mailto:msetze...@gmail.com]
> Sent: Wednesday, March 16, 2022, 20:53 UTC
> To: Dave Barton; users@global.libreoffice.org
> Subject: [libreoffice-users] Help with find & replace.
>
> > On 16 Mar 2022 at 20:41, Dave Barton wrote:
> >
> > Subject:  Re: [libreoffice-users] Help with find &
> > replace.
> > To:   users@global.libreoffice.org
> > From: Dave Barton 
> > Date sent:Wed, 16 Mar 2022 20:41:43 +
> >
> >> On 16/03/2022 20:01, Steve Edmonds wrote:
> >>>
> >>>
> >>> On 17/03/2022 08:34, Dave Barton wrote:
> >>>> On 16/03/2022 18:27, Brian Barker wrote:
> >>>>> At 16:29 16/03/2022 +, Dave Barton wrote:
> >>>>>> I am looking for a find & replace solution in Writer, where there
> is a
> >>>>>> blank space as the last character of a paragraph (eg. last word
> >>>>>> ). In the original OOo and most of the text editors I
> >>>>>> use the simple solution that worked/works perfectly is: Find =
> >>>>>> $ Replace = $ (Note: I use  here to represent a single
> >>>>>> space character). This does not work in LO Writer, so I am forced to
> >>>>>> fiddle around copying from LO and pasting into AOO, running F&R in
> >>>>>> AOO, then copy/paste back again. Any pointers would be welcome.
> >>>>> I'm surprised that exactly what you say works in OpenOffice. Don't
> you
> >>>>> need to find space-dollar, just as you describe, but to replace with
> >>>>> nothing? Replacing with dollar will surely insert an unwanted dollar
> >>>>> character?
> >>>>>
> >>>>> Or have you forgotten to click "Other options" in the Find and
> Replace
> >>>>> dialogue and to tick "Regular expressions"?
> >>>>>
> >>>>> I trust this helps.
> >>>>>
> >>>>> Brian Barker
> >>>> Hi Brian,
> >>>>
> >>>> After 22 Years of you and I being involved in this project, I
> genuinely
> >>>> bow to your superior knowledge in this area. However, I do assure you
> >>>> that the convoluted LO->AOO->LO� nonsense works for me, exactly as it
> >>>> did in the days of OOo.
> >>>>
> >>>> No, I have not forgotten to click "Other options in the Find and
> Replace
> >>>> dialogue and to tick "Regular expressions", please see my screen
> capture:
> >>>> https://www.mediafire.com/view/80552jkp3qw6o8x/F%2526R_LO.png/file
> >>>>
> >>>> Here is a very simplistic file illustrating the 
> >>>> paragraph endings:
> >>>> https://www.mediafire.com/file/vmixa9r4dhjpc9e/F%2526R_LO.odt/file
> >>>>
> >>>> Version: 7.3.1.3 (x64) / LibreOffice Community
> >>>> Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
> >>>> CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL:
> >>>> win
> >>>> Locale: es-ES (en_IE); UI: en-US
> >>>> Calc: threaded
> >>>>
> >>>> If you can please show me where I am going wrong, I would be extremely
> >>>> grateful.
> >>>>
> >>>> Dave Barton
> >>>>
> >>>>
> >>> May be this is sorted and I have received the emails out of order, but
> >>> assuming you just want to remove the trailing space from each line,
> both
> >>> Johnny's and Michael's methods work for me on your sample file.
> >>>
> >>> Find= [:space:]{1,}$
> >>> Replace= empty
> >>>
> >>> Find= $
> >>> Replace= empty
> >>>
> >>> Use regular expression= checked
> >>> Steve
> >>
> >>
> >> Thanks Steve, but no it's NOT sorted.
> >>

Re: [libreoffice-users] Help with find & replace.

[Dave Barton]

Fantastic, but why does the LO project *_NOT_* inform it's users about
this *_HIDDEN_* option?

Please provide links to the the TDF/LO Help/Documentation files that
provide this information to our users.

 Original Message 
From: Michael D. Setzer II [mailto:msetze...@gmail.com]
Sent: Wednesday, March 16, 2022, 20:53 UTC
To: Dave Barton; users@global.libreoffice.org
Subject: [libreoffice-users] Help with find & replace.

> On 16 Mar 2022 at 20:41, Dave Barton wrote:
> 
> Subject:      Re: [libreoffice-users] Help with find & 
> replace.
> To:   users@global.libreoffice.org
> From: Dave Barton 
> Date sent:Wed, 16 Mar 2022 20:41:43 +
> 
>> On 16/03/2022 20:01, Steve Edmonds wrote:
>>>
>>>
>>> On 17/03/2022 08:34, Dave Barton wrote:
>>>> On 16/03/2022 18:27, Brian Barker wrote:
>>>>> At 16:29 16/03/2022 +, Dave Barton wrote:
>>>>>> I am looking for a find & replace solution in Writer, where there is a
>>>>>> blank space as the last character of a paragraph (eg. last word
>>>>>> ). In the original OOo and most of the text editors I
>>>>>> use the simple solution that worked/works perfectly is: Find =
>>>>>> $ Replace = $ (Note: I use  here to represent a single
>>>>>> space character). This does not work in LO Writer, so I am forced to
>>>>>> fiddle around copying from LO and pasting into AOO, running F&R in
>>>>>> AOO, then copy/paste back again. Any pointers would be welcome.
>>>>> I'm surprised that exactly what you say works in OpenOffice. Don't you
>>>>> need to find space-dollar, just as you describe, but to replace with
>>>>> nothing? Replacing with dollar will surely insert an unwanted dollar
>>>>> character?
>>>>>
>>>>> Or have you forgotten to click "Other options" in the Find and Replace
>>>>> dialogue and to tick "Regular expressions"?
>>>>>
>>>>> I trust this helps.
>>>>>
>>>>> Brian Barker
>>>> Hi Brian,
>>>>
>>>> After 22 Years of you and I being involved in this project, I genuinely
>>>> bow to your superior knowledge in this area. However, I do assure you
>>>> that the convoluted LO->AOO->LO� nonsense works for me, exactly as it
>>>> did in the days of OOo.
>>>>
>>>> No, I have not forgotten to click "Other options in the Find and Replace
>>>> dialogue and to tick "Regular expressions", please see my screen capture:
>>>> https://www.mediafire.com/view/80552jkp3qw6o8x/F%2526R_LO.png/file
>>>>
>>>> Here is a very simplistic file illustrating the 
>>>> paragraph endings:
>>>> https://www.mediafire.com/file/vmixa9r4dhjpc9e/F%2526R_LO.odt/file
>>>>
>>>> Version: 7.3.1.3 (x64) / LibreOffice Community
>>>> Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
>>>> CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL:
>>>> win
>>>> Locale: es-ES (en_IE); UI: en-US
>>>> Calc: threaded
>>>>
>>>> If you can please show me where I am going wrong, I would be extremely
>>>> grateful.
>>>>
>>>> Dave Barton
>>>>
>>>>
>>> May be this is sorted and I have received the emails out of order, but
>>> assuming you just want to remove the trailing space from each line, both
>>> Johnny's and Michael's methods work for me on your sample file.
>>>
>>> Find= [:space:]{1,}$
>>> Replace= empty
>>>
>>> Find= $
>>> Replace= empty
>>>
>>> Use regular expression= checked
>>> Steve
>>
>>
>> Thanks Steve, but no it's NOT sorted.
>>
>> You have "Kinda" given me 1/2 a clue.
>>
>> What does {.1.} mean?
> file:///opt/libreoffice7.3/help/en-US/text/shared/01/0211.html?&DbPAR=WRITER
> 
> {N}
> 
> The post-fix repetition operator that specifies an exact 
> number of occurrences ("N") of the regular expression 
> term immediately preceding it must be present for a 
> match to occur. For example, "tre{2}" matches "tree".  
> 
> {N,M} 
>  The post-fix repetition operator that specifies a range 
> (minimum of "N" to a maximum of "M") of occurrences of 
> the regular expression term im

Re: [libreoffice-users] Help with find & replace.

[Johnny Rosenberg]

Den ons 16 mars 2022 kl 21:44 skrev Dave Barton :

> On 16/03/2022 20:01, Steve Edmonds wrote:
> >
> >
> > On 17/03/2022 08:34, Dave Barton wrote:
> >> On 16/03/2022 18:27, Brian Barker wrote:
> >>> At 16:29 16/03/2022 +, Dave Barton wrote:
>  I am looking for a find & replace solution in Writer, where there is a
>  blank space as the last character of a paragraph (eg. last word
>  ). In the original OOo and most of the text editors I
>  use the simple solution that worked/works perfectly is: Find =
>  $ Replace = $ (Note: I use  here to represent a single
>  space character). This does not work in LO Writer, so I am forced to
>  fiddle around copying from LO and pasting into AOO, running F&R in
>  AOO, then copy/paste back again. Any pointers would be welcome.
> >>> I'm surprised that exactly what you say works in OpenOffice. Don't you
> >>> need to find space-dollar, just as you describe, but to replace with
> >>> nothing? Replacing with dollar will surely insert an unwanted dollar
> >>> character?
> >>>
> >>> Or have you forgotten to click "Other options" in the Find and Replace
> >>> dialogue and to tick "Regular expressions"?
> >>>
> >>> I trust this helps.
> >>>
> >>> Brian Barker
> >> Hi Brian,
> >>
> >> After 22 Years of you and I being involved in this project, I genuinely
> >> bow to your superior knowledge in this area. However, I do assure you
> >> that the convoluted LO->AOO->LO  nonsense works for me, exactly as it
> >> did in the days of OOo.
> >>
> >> No, I have not forgotten to click "Other options in the Find and Replace
> >> dialogue and to tick "Regular expressions", please see my screen
> capture:
> >> https://www.mediafire.com/view/80552jkp3qw6o8x/F%2526R_LO.png/file
> >>
> >> Here is a very simplistic file illustrating the 
> >> paragraph endings:
> >> https://www.mediafire.com/file/vmixa9r4dhjpc9e/F%2526R_LO.odt/file
> >>
> >> Version: 7.3.1.3 (x64) / LibreOffice Community
> >> Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
> >> CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL:
> >> win
> >> Locale: es-ES (en_IE); UI: en-US
> >> Calc: threaded
> >>
> >> If you can please show me where I am going wrong, I would be extremely
> >> grateful.
> >>
> >> Dave Barton
> >>
> >>
> > May be this is sorted and I have received the emails out of order, but
> > assuming you just want to remove the trailing space from each line, both
> > Johnny's and Michael's methods work for me on your sample file.
> >
> > Find= [:space:]{1,}$
> > Replace= empty
> >
> > Find= $
> > Replace= empty
> >
> > Use regular expression= checked
> > Steve
>
>
> Thanks Steve, but no it's NOT sorted.
>
> You have "Kinda" given me 1/2 a clue.
>
> What does {.1.} mean?
>

It means ”one or more of the previous character”. Well, it's {1,}, not
{.1.}.
You can also specify a maximum value, like this: {1,5}. This means ”at
least one and not more than 5 of the previous character.
For instance:
[0-9]{3,5}
This means at least three and not more than 5 numerical characters.


Kind regards

Johnny Rosenberg


>
> In all my researching of regular expressions, I have never encountered
> this option. The wonderful thing about *_STANDARDS_* is that there are
> such a wide variety of different ones to randomly chose and use.
>
> Dave
>
> --
> 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
>

-- 
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] Help with find & replace.

[Michael D. Setzer II]

On 16 Mar 2022 at 20:41, Dave Barton wrote:

Subject:Re: [libreoffice-users] Help with find & 
replace.
To: users@global.libreoffice.org
From:   Dave Barton 
Date sent:  Wed, 16 Mar 2022 20:41:43 +

> On 16/03/2022 20:01, Steve Edmonds wrote:
> > 
> > 
> > On 17/03/2022 08:34, Dave Barton wrote:
> >> On 16/03/2022 18:27, Brian Barker wrote:
> >>> At 16:29 16/03/2022 +, Dave Barton wrote:
> >>>> I am looking for a find & replace solution in Writer, where there is a
> >>>> blank space as the last character of a paragraph (eg. last word
> >>>> ). In the original OOo and most of the text editors I
> >>>> use the simple solution that worked/works perfectly is: Find =
> >>>> $ Replace = $ (Note: I use  here to represent a single
> >>>> space character). This does not work in LO Writer, so I am forced to
> >>>> fiddle around copying from LO and pasting into AOO, running F&R in
> >>>> AOO, then copy/paste back again. Any pointers would be welcome.
> >>> I'm surprised that exactly what you say works in OpenOffice. Don't you
> >>> need to find space-dollar, just as you describe, but to replace with
> >>> nothing? Replacing with dollar will surely insert an unwanted dollar
> >>> character?
> >>>
> >>> Or have you forgotten to click "Other options" in the Find and Replace
> >>> dialogue and to tick "Regular expressions"?
> >>>
> >>> I trust this helps.
> >>>
> >>> Brian Barker
> >> Hi Brian,
> >>
> >> After 22 Years of you and I being involved in this project, I genuinely
> >> bow to your superior knowledge in this area. However, I do assure you
> >> that the convoluted LO->AOO->LO  nonsense works for me, exactly as it
> >> did in the days of OOo.
> >>
> >> No, I have not forgotten to click "Other options in the Find and Replace
> >> dialogue and to tick "Regular expressions", please see my screen capture:
> >> https://www.mediafire.com/view/80552jkp3qw6o8x/F%2526R_LO.png/file
> >>
> >> Here is a very simplistic file illustrating the 
> >> paragraph endings:
> >> https://www.mediafire.com/file/vmixa9r4dhjpc9e/F%2526R_LO.odt/file
> >>
> >> Version: 7.3.1.3 (x64) / LibreOffice Community
> >> Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
> >> CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL:
> >> win
> >> Locale: es-ES (en_IE); UI: en-US
> >> Calc: threaded
> >>
> >> If you can please show me where I am going wrong, I would be extremely
> >> grateful.
> >>
> >> Dave Barton
> >>
> >>
> > May be this is sorted and I have received the emails out of order, but
> > assuming you just want to remove the trailing space from each line, both
> > Johnny's and Michael's methods work for me on your sample file.
> > 
> > Find= [:space:]{1,}$
> > Replace= empty
> > 
> > Find= $
> > Replace= empty
> > 
> > Use regular expression= checked
> > Steve
> 
> 
> Thanks Steve, but no it's NOT sorted.
> 
> You have "Kinda" given me 1/2 a clue.
> 
> What does {.1.} mean?
file:///opt/libreoffice7.3/help/en-US/text/shared/01/0211.html?&DbPAR=WRITER

{N}

The post-fix repetition operator that specifies an exact 
number of occurrences ("N") of the regular expression 
term immediately preceding it must be present for a 
match to occur. For example, "tre{2}" matches "tree".  

{N,M}   
 The post-fix repetition operator that specifies a range 
(minimum of "N" to a maximum of "M") of occurrences of 
the regular expression term immediately preceding it 
that can be present for a match to occur. For example, 
"tre{1,2}" matches "tre" and "tree".  

{N,}

The post-fix repetition operator that specifies a range 
(minimum "N" to an unspecified maximum) of 
occurrences of the regular expression term immediately 
preceding it that can be present for a match to occur. 
(The maximum number of occurrences is limited only by 
the size of the document). For example, "tre{2,}" 
matches "tree", "treee", and "tre".  

So, [:space:]{1,}$ matches one or more spaces at end of 
line.
{1,}$ does the same with  actually 
being a single space.
> 
> In all my researching of regular expressions, I have never enco

Re: [libreoffice-users] Help with find & replace.

[Dave Barton]

On 16/03/2022 20:01, Steve Edmonds wrote:
> 
> 
> On 17/03/2022 08:34, Dave Barton wrote:
>> On 16/03/2022 18:27, Brian Barker wrote:
>>> At 16:29 16/03/2022 +, Dave Barton wrote:
 I am looking for a find & replace solution in Writer, where there is a
 blank space as the last character of a paragraph (eg. last word
 ). In the original OOo and most of the text editors I
 use the simple solution that worked/works perfectly is: Find =
 $ Replace = $ (Note: I use  here to represent a single
 space character). This does not work in LO Writer, so I am forced to
 fiddle around copying from LO and pasting into AOO, running F&R in
 AOO, then copy/paste back again. Any pointers would be welcome.
>>> I'm surprised that exactly what you say works in OpenOffice. Don't you
>>> need to find space-dollar, just as you describe, but to replace with
>>> nothing? Replacing with dollar will surely insert an unwanted dollar
>>> character?
>>>
>>> Or have you forgotten to click "Other options" in the Find and Replace
>>> dialogue and to tick "Regular expressions"?
>>>
>>> I trust this helps.
>>>
>>> Brian Barker
>> Hi Brian,
>>
>> After 22 Years of you and I being involved in this project, I genuinely
>> bow to your superior knowledge in this area. However, I do assure you
>> that the convoluted LO->AOO->LO  nonsense works for me, exactly as it
>> did in the days of OOo.
>>
>> No, I have not forgotten to click "Other options in the Find and Replace
>> dialogue and to tick "Regular expressions", please see my screen capture:
>> https://www.mediafire.com/view/80552jkp3qw6o8x/F%2526R_LO.png/file
>>
>> Here is a very simplistic file illustrating the 
>> paragraph endings:
>> https://www.mediafire.com/file/vmixa9r4dhjpc9e/F%2526R_LO.odt/file
>>
>> Version: 7.3.1.3 (x64) / LibreOffice Community
>> Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
>> CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL:
>> win
>> Locale: es-ES (en_IE); UI: en-US
>> Calc: threaded
>>
>> If you can please show me where I am going wrong, I would be extremely
>> grateful.
>>
>> Dave Barton
>>
>>
> May be this is sorted and I have received the emails out of order, but
> assuming you just want to remove the trailing space from each line, both
> Johnny's and Michael's methods work for me on your sample file.
> 
> Find= [:space:]{1,}$
> Replace= empty
> 
> Find= $
> Replace= empty
> 
> Use regular expression= checked
> Steve


Thanks Steve, but no it's NOT sorted.

You have "Kinda" given me 1/2 a clue.

What does {.1.} mean?

In all my researching of regular expressions, I have never encountered
this option. The wonderful thing about *_STANDARDS_* is that there are
such a wide variety of different ones to randomly chose and use.

Dave

-- 
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] Help with find & replace.

[Michael D. Setzer II]

On 17 Mar 2022 at 9:01, Steve Edmonds wrote:

Date sent:  Thu, 17 Mar 2022 09:01:42 +1300
Subject:Re: [libreoffice-users] Help with find & 
replace.
To: users@global.libreoffice.org
From:   Steve Edmonds 


> 
> 
> On 17/03/2022 08:34, Dave Barton wrote:
> > On 16/03/2022 18:27, Brian Barker wrote:
> >> At 16:29 16/03/2022 +, Dave Barton wrote:
> >>> I am looking for a find & replace solution in Writer, where there is a
> >>> blank space as the last character of a paragraph (eg. last word
> >>> ). In the original OOo and most of the text editors I
> >>> use the simple solution that worked/works perfectly is: Find =
> >>> $ Replace = $ (Note: I use  here to represent a single
> >>> space character). This does not work in LO Writer, so I am forced to
> >>> fiddle around copying from LO and pasting into AOO, running F&R in
> >>> AOO, then copy/paste back again. Any pointers would be welcome.
> >> I'm surprised that exactly what you say works in OpenOffice. Don't you
> >> need to find space-dollar, just as you describe, but to replace with
> >> nothing? Replacing with dollar will surely insert an unwanted dollar
> >> character?
> >>
> >> Or have you forgotten to click "Other options" in the Find and Replace
> >> dialogue and to tick "Regular expressions"?
> >>
> >> I trust this helps.
> >>
> >> Brian Barker
> > Hi Brian,
> >
> > After 22 Years of you and I being involved in this project, I genuinely
> > bow to your superior knowledge in this area. However, I do assure you
> > that the convoluted LO->AOO->LO  nonsense works for me, exactly as it
> > did in the days of OOo.
> >
> > No, I have not forgotten to click "Other options in the Find and Replace
> > dialogue and to tick "Regular expressions", please see my screen capture:
> > https://www.mediafire.com/view/80552jkp3qw6o8x/F%2526R_LO.png/file
> >
> > Here is a very simplistic file illustrating the 
> > paragraph endings:
> > https://www.mediafire.com/file/vmixa9r4dhjpc9e/F%2526R_LO.odt/file
> >
> > Version: 7.3.1.3 (x64) / LibreOffice Community
> > Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
> > CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
> > Locale: es-ES (en_IE); UI: en-US
> > Calc: threaded
> >
> > If you can please show me where I am going wrong, I would be extremely
> > grateful.
> >
> > Dave Barton
> >
> >
> May be this is sorted and I have received the emails out of order, but 
> assuming you just want to remove the trailing space from each line, both 
> Johnny's and Michael's methods work for me on your sample file.
> 
> Find= [:space:]{1,}$
> Replace= empty
> 
> Find= $
> Replace= empty
> 
> Use regular expression= checked
> Steve

Just to make sure it is clear $ will only remove 1 
space at end of line {1,}$ or [:space:]{1,}$ will 
remove all spaces 1 to whatever.



> 
> 
> -- 
> 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] Help with find & replace.

[Dave Barton]

On 16/03/2022 18:27, Brian Barker wrote:
> At 16:29 16/03/2022 +, Dave Barton wrote:
>> I am looking for a find & replace solution in Writer, where there is a
>> blank space as the last character of a paragraph (eg. last word
>> ). In the original OOo and most of the text editors I
>> use the simple solution that worked/works perfectly is: Find =
>> $ Replace = $ (Note: I use  here to represent a single
>> space character). This does not work in LO Writer, so I am forced to
>> fiddle around copying from LO and pasting into AOO, running F&R in
>> AOO, then copy/paste back again. Any pointers would be welcome.
> 
> I'm surprised that exactly what you say works in OpenOffice. Don't you
> need to find space-dollar, just as you describe, but to replace with
> nothing? Replacing with dollar will surely insert an unwanted dollar
> character?
> 
> Or have you forgotten to click "Other options" in the Find and Replace
> dialogue and to tick "Regular expressions"?
> 
> I trust this helps.
> 
> Brian Barker

Hi Brian,

After 22 Years of you and I being involved in this project, I genuinely
bow to your superior knowledge in this area. However, I do assure you
that the convoluted LO->AOO->LO  nonsense works for me, exactly as it
did in the days of OOo.

No, I have not forgotten to click "Other options in the Find and Replace
dialogue and to tick "Regular expressions", please see my screen capture:
https://www.mediafire.com/view/80552jkp3qw6o8x/F%2526R_LO.png/file

Here is a very simplistic file illustrating the 
paragraph endings:
https://www.mediafire.com/file/vmixa9r4dhjpc9e/F%2526R_LO.odt/file

Version: 7.3.1.3 (x64) / LibreOffice Community
Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: es-ES (en_IE); UI: en-US
Calc: threaded

If you can please show me where I am going wrong, I would be extremely
grateful.

Dave Barton


-- 
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] Help with find & replace.

[Michael D. Setzer II]

[:space:]{1,}$ Seemed to work for me in find option and 
left replace completely blank. Than replace all.

On 16 Mar 2022 at 16:29, Dave Barton wrote:

To: LibreOffice Users 

From:   Dave Barton 
Subject:[libreoffice-users] Help with find & replace.
Date sent:  Wed, 16 Mar 2022 16:29:34 +

> I am looking for a find & replace solution in Writer, where there is a
> blank space as the last character of a paragraph
> (eg. last word ).
> 
> In the original OOo and most of the text editors I use the simple
> solution that worked/works perfectly is:
> Find = $ Replace = $
> (Note: I use  here to represent a single space character).
> 
> This does not work in LO Writer, so I am forced to fiddle around copying
> from LO and pasting into AOO, running F&R in AOO, then copy/paste back
> again.
> 
> Any pointers would be welcome.
> 
> Dave
> 
> -- 
> 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] Help with find & replace.

[Johnny Rosenberg]

Den ons 16 mars 2022 kl 17:56 skrev Dave Barton :

> I am looking for a find & replace solution in Writer, where there is a
> blank space as the last character of a paragraph
> (eg. last word ).
>

I think ␊␍ is Windows only, but maybe that doesn't matter in this case.


> In the original OOo and most of the text editors I use the simple
> solution that worked/works perfectly is:
> Find = $ Replace = $
> (Note: I use  here to represent a single space character).
>
> This does not work in LO Writer, so I am forced to fiddle around copying
> from LO and pasting into AOO, running F&R in AOO, then copy/paste back
> again.
>

It works perfectly for me. It replaces the space with a $ character, just
like expected (make sure ”☒ Regular expressions” is checked). If you don't
want the $ character, then just leave the Replace field empty.
I tried it a few seconds ago with LibreOffice 7.1.8.1 and it worked
perfectly. I suspect it works just as well with newer versions as well as
most older versions too.

In LibreOffice, the $ character doesn't mean a ”new line character”, it
doesn't work quite like that. A paragraph is kind of an object which
contains the actual text and all the properties of that paragraph (as far
as I understand it), so $ doesn't really mean ”a space followed by a
newline character”, it rather means ”a space at the end of a paragraph”. It
just specifies where to look for the space, nothing more. So you are not
replacing two characters with one, you are replacing one character with
nothing and you are doing it at the end of a paragraph.

At least that's the easiest way I can explain it.

I hope this helps.

Are you sure that replacing with $ actually worked in Apache OpenOffice?
I'm not sure, but it shouldn't, should it? Because Apache OpenOffice works
the same way as LibreOffice in this matter, working with objects and all
that. As I no longer have Apache OpenOffice installed I can't test it, so I
can't say for sure.


Kind regards

Johnny Rosenberg


>
> Any pointers would be welcome.
>
> Dave
>
> --
> 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
>

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

[libreoffice-users] Help with find & replace.

[Dave Barton]

I am looking for a find & replace solution in Writer, where there is a
blank space as the last character of a paragraph
(eg. last word ).

In the original OOo and most of the text editors I use the simple
solution that worked/works perfectly is:
Find = $ Replace = $
(Note: I use  here to represent a single space character).

This does not work in LO Writer, so I am forced to fiddle around copying
from LO and pasting into AOO, running F&R in AOO, then copy/paste back
again.

Any pointers would be welcome.

Dave

-- 
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] Help needed

[Italo Vignoli]

Hi Stephen,

On 4/14/21 3:20 PM, STEPHEN COLEMAN wrote:


   Fault Module Name: ucrtbase.DLL


The issue is related to ucrtbase.dll, which is a Windows module.

The gift_aid_schedule_libre_.ods file, which is easy to download from 
the UK Gov website, opens without any issue if that module is not faulty 
(I have just checked with Linux, macOS and Windows).


First, you should check if you LibreOffice installation conflicts with 
the faulty module by launching LibreOffice (double click on the program 
icon), without opening any file. If the software crashes, then there is 
a conflict, if the software opens, then there is a file specific conflict.


While you have to investigate with a Windows expert why your module is 
faulty, you can try one of the following workarounds:


1. Download the Excel version of the same file, which is available from 
the same page, and try to open it with LibreOffice (which is fully 
compatible with MS Office files).


2. Install the portable version of LibreOffice from the following page: 
https://www.libreoffice.org/download/portable-versions/. That version is 
not accessing system resources, so it should opeen the file without issues.


3. Uninstall LibreOffice 7.1.2 and reinstall LibreOffice 7.0.5 (the 
fourth digit is the release candidate version, so is not significant).


I hope one of these workaround works. Best regards.
--
Italo Vignoli - it...@vignoli.org
mobile/signal +39.348.5653829
GPG Key ID - 0xAAB8D5C0
DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0


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

[libreoffice-users] Help needed

[STEPHEN COLEMAN]

Hi -- I need your help.

We successfully downloaded LO 7.1.2.2 and am trying to use it to open an .ODS 
file received from UK Inland Revenue that is labelled 
'gift_aid_schedule_libre_.ods' however while it opens  up the LibreOffice 7.1 
Document Recovery and pulls up the document file with the status 'not recovered 
yet' then says press Start and the Recovery then finishes and say press Finish 
however my system only reports 'LO has stopped working (?)' with the reasons 
below. I am working with Window 7

Problem signature:
  Problem Event Name: APPCRASH
  Application Name: soffice.bin
  Application Version: 7.1.2.2
  Application Timestamp: 605d6647
  Fault Module Name: ucrtbase.DLL
  Fault Module Version: 10.0.10240.16390
  Fault Module Timestamp: 55a5bf73
  Exception Code: 4015
  Exception Offset: 0007d85a
  OS Version: 6.1.7601.2.1.0.768.3
  Locale ID: 2057
  Additional Information 1: 354c
  Additional Information 2: 354c5c2ffb9498215ae02fa9bbe1
  Additional Information 3: 1608
  Additional Information 4: 16088398a310afa223998f6862d82454

I need this doc to complete so as to obtain refunds of tax paid on donations 
received for our Destitute Asylum Seekers Charity in the UK.

Please advise and thank you

Stephen


-- 
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] Help installation via flatpak

[Stephan Bergmann]

On 14/05/2020 15:42, Stephan Bergmann wrote:

On 14/05/2020 13:24, asbaeza65 wrote:
Since a little while I sole to install/update libreoffice using 
flatpak. It
works just great, but it does not install the help system. Is there 
any way

to do that using flatpak?


You explicitly need to install the
org.libreoffice.LibreOffice.Help extension.

(See also the commit message of 
 
"Enable --help=html for flatpak".  That extension contains all 
localizations, so is rather larger.)


(I added some information to 
 now.)



--
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] Help installation via flatpak

[Stephan Bergmann]

On 14/05/2020 13:24, asbaeza65 wrote:

Since a little while I sole to install/update libreoffice using flatpak. It
works just great, but it does not install the help system. Is there any way
to do that using flatpak?


You explicitly need to install the
org.libreoffice.LibreOffice.Help extension.

(See also the commit message of 
 
"Enable --help=html for flatpak".  That extension contains all 
localizations, so is rather larger.)



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

[libreoffice-users] Help installation via flatpak

[asbaeza65]

Hello.

Since a little while I sole to install/update libreoffice using flatpak. It
works just great, but it does not install the help system. Is there any way
to do that using flatpak?

Thanks in advice.



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

-- 
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] Help please to delete an unwanted character.

[Budge]

On 05/12/2019 14:05, Budge wrote:

I have just started to try and learn about templates and I read that to
open the templates manager I should use Ctrl+Shift+E.

Well nothing happened but when I then opened writer for a new document
there was a lower case e underlined at the start of the letter.  I could
not delete it and what is even more strange is that this same underlined
lower case e appears in as the starting character in my To: field in
Thunderbird.

Clearly I have turned on something I do not understand but would
appreciate and suggestions.



Please forgive my rush to print.  Had to re-boot and that seems to have fixed 
problem!


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

[libreoffice-users] Help please to delete an unwanted character.

[Budge]

I have just started to try and learn about templates and I read that to
open the templates manager I should use Ctrl+Shift+E.

Well nothing happened but when I then opened writer for a new document
there was a lower case e underlined at the start of the letter.  I could
not delete it and what is even more strange is that this same underlined
lower case e appears in as the starting character in my To: field in
Thunderbird.

Clearly I have turned on something I do not understand but would
appreciate and suggestions.



-- 
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] Help with formula - number conversion

[libreoffice-ml . mbourne]

sc...@valuedinsights.com wrote:

I have unsubscribed numerous times. Stop sending me your junk!


Most of us receiving mail from this list are just other users, like you, 
and have no ability to remove you from the list. You should be able to 
remove yourself by sending an email to 
. Make sure you send the email 
from the address which is subscribed to the list. You should receive an 
email asking you to confirm that you want to unsubscribe, to which you 
need to reply to complete the unsubscribe. If you don't receive that 
message, check if it's ended up in your junk/spam folder.


If you still can't unsubscribe, there are further troubleshooting steps at:


--
Mark


--
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] Help with formula - number conversion

[scott]

I have unsubscribed numerous times. Stop sending me your junk!

-Original Message-
From: Harvey Nimmo  
Sent: Thursday, July 11, 2019 1:55 PM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Help with formula - number conversion

On Thu, 2019-07-11 at 14:05 -0400, Tanstaafl wrote:
> Hi everyone,
> 
> I need some help with converting a number (in a text field) to a 
> different type.
> 
> The type of number is time, and it is in the form of:
> 
> hh:mm:ss
> 
> I need to convert this to just minutes, rounded up, so if ss is more 
> than 30 it adds another minute.
> 
> I'm at a loss as to how to even start (I'm not a spreadsheet guy)...
> 
> I would appreciate any pointers on how to get this done...
> 
> Thanks!

You might like to try the following.
Given that your value is in field A1 in the form hh:mm:ss then you can do the 
conversion by entering the following in another field
=(HOUR(A1)*60)+MINUTE(A1)+ROUND(SEC(A1/60),0)

It doesn't seem to matter if the value in A1 is in time format or text format.

I'm sure there are buffs out there who could offer a more elegant solution, but 
the above seems to work all right for the cases I tried.

Cheers
Harvey




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


-- 
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] Help with formula - number conversion

[Harvey Nimmo]

On Fri, 2019-07-12 at 13:00 -0400, Tanstaafl wrote:
> On Thu Jul 11 2019 15:12:05 GMT-0400 (Eastern Standard Time), Harvey
> Nimmo  wrote:
> > Sorry, Tanstaafl! 
> > 
> > There is a slight error in the above. The formula should read
> > =HOUR(A1)*60+MINUTE(A1)+ROUND(SECOND(A1)/60,0)
> > 
> > 'SEC' is the secant function. Also 'MIN' would also be wrong since
> > it
> > calculates the minimum of a set of values.
> 
> awesome! Thanks very much Harvey! Worked like a charm...

You're welcome. But Brian Barker's suggestion is both more elegant and
simpler, because it considers takes account of times greater than 24
hours.

Say your time is in cell A1 in text format (e.g. '25:01:50)

Then adding the formula to another cell 
=ROUND(a1*1440,0) or just ROUND(a1*1440) gives the right answer (1502),
whereas my previous formula would wrongly return 1 (hour) instead of
25, giving total 62.

Cheers
Harvey






-- 
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] Help with formula - number conversion

[Brian Barker]

At 14:05 11/07/2019 -0400, Charles Marcus wrote:
I need some help with converting a number (in a text field) to a 
different type. The type of number is time, and it is in the form 
of: hh:mm:ss I need to convert this to just minutes, rounded up, so 
if ss is more than 30 it adds another minute.


At 20:55 11/07/2019 +0200, and at 21:12 11/07/2019 +0200, Harvey Nimmo wrote:
You might like to try the following. Given that your value is in 
field A1 in the form hh:mm:ss then you can do the conversion by 
entering the following in another field

=HOUR(A1)*60+MINUTE(A1)+ROUND(SECOND(A1)/60,0)
It doesn't seem to matter if the value in A1 is in time format or 
text format. I'm sure there are buffs out there who could offer a 
more elegant solution, but the above seems to work all right for the 
cases I tried.


I'm not sure if it is more elegant, but there is a simpler solution. 
Time values are represented internally as numbers and fractions of 
days, so it is unnecessary to unpack the separate hour, minute, and 
second values. If you just multiply by 1440, the number of minutes in 
a day, you will have the total number of minutes in the period:

=Xn*1440

Your rounding request is ambiguous.

o "Rounding up" would mean that any number of seconds other than zero 
would cause another whole minute to be indicated. For that, choose:

=ROUNDUP(Xn*1440)

o If you want the extra minute only when the seconds value is more 
than half a minute, normal rounding is appropriate:

=ROUND(Xn*1440)

o But note that normal rounding - as provided by the ROUND() function 
- will round 30 seconds up to the next minute, as well as values over 
30. If you really want exactly thirty seconds to be rounded down - a 
non-standard type of rounding - you will have to work around this 
yourself. But I guess that you probably don't mean that.


Incidentally, by mentioning the time format hh:mm:ss you imply that 
what you are handling are times of day, but when you convert these to 
minutes, they have the feel of time intervals, not times per se. 
After all, no-one specifies times of day just in minutes. If you have 
a period of time more than twenty-four hours, the hh:mm:ss format 
will display the time as it would appear in a later day. So 25 hours, 
for example, will appear as 01:00, or 1 a.m. the following day. You 
can display such time intervals using the alternative format code [HH]:MM:SS.


This produces a difference between the unpacking method and simple 
multiplication. If your time interval is 25 hours - 25:00:00 - the 
HOUR() function will return this as 1 hour - meaning one o'clock - 
whereas the multiplication method will respect the full 25 hours. 
Only you can know which you need or if this matters.


I trust this helps.

Brian Barker


--
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] Help with formula - number conversion

[Tanstaafl]

On Thu Jul 11 2019 15:12:05 GMT-0400 (Eastern Standard Time), Harvey
Nimmo  wrote:
> Sorry, Tanstaafl! 
> 
> There is a slight error in the above. The formula should read
> =HOUR(A1)*60+MINUTE(A1)+ROUND(SECOND(A1)/60,0)
> 
> 'SEC' is the secant function. Also 'MIN' would also be wrong since it
> calculates the minimum of a set of values.

awesome! Thanks very much Harvey! Worked like a charm...

-- 
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] Help with formula - number conversion

[Harvey Nimmo]

On Thu, 2019-07-11 at 20:55 +0200, Harvey Nimmo wrote:
> On Thu, 2019-07-11 at 14:05 -0400, Tanstaafl wrote:
> > Hi everyone,
> > 
> > I need some help with converting a number (in a text field) to a
> > different type.
> > 
> > The type of number is time, and it is in the form of:
> > 
> > hh:mm:ss
> > 
> > I need to convert this to just minutes, rounded up, so if ss is
> > more
> > than 30 it adds another minute.
> > 
> > I'm at a loss as to how to even start (I'm not a spreadsheet
> > guy)...
> > 
> > I would appreciate any pointers on how to get this done...
> > 
> > Thanks!
> 
> You might like to try the following.
> Given that your value is in field A1 in the form hh:mm:ss
> then you can do the conversion by entering the following in another
> field
> =(HOUR(A1)*60)+MINUTE(A1)+ROUND(SEC(A1/60),0)
> 
> It doesn't seem to matter if the value in A1 is in time format or
> text
> format.
> 
> I'm sure there are buffs out there who could offer a more elegant
> solution, but the above seems to work all right for the cases I
> tried.
> 
> Cheers
> Harvey

Sorry, Tanstaafl! 

There is a slight error in the above. The formula should read
=HOUR(A1)*60+MINUTE(A1)+ROUND(SECOND(A1)/60,0)

'SEC' is the secant function. Also 'MIN' would also be wrong since it
calculates the minimum of a set of values.

Cheers
Harvey



-- 
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] Help with formula - number conversion

[Harvey Nimmo]

On Thu, 2019-07-11 at 14:05 -0400, Tanstaafl wrote:
> Hi everyone,
> 
> I need some help with converting a number (in a text field) to a
> different type.
> 
> The type of number is time, and it is in the form of:
> 
> hh:mm:ss
> 
> I need to convert this to just minutes, rounded up, so if ss is more
> than 30 it adds another minute.
> 
> I'm at a loss as to how to even start (I'm not a spreadsheet guy)...
> 
> I would appreciate any pointers on how to get this done...
> 
> Thanks!

You might like to try the following.
Given that your value is in field A1 in the form hh:mm:ss
then you can do the conversion by entering the following in another
field
=(HOUR(A1)*60)+MINUTE(A1)+ROUND(SEC(A1/60),0)

It doesn't seem to matter if the value in A1 is in time format or text
format.

I'm sure there are buffs out there who could offer a more elegant
solution, but the above seems to work all right for the cases I tried.

Cheers
Harvey




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

[libreoffice-users] Help with formula - number conversion

[Tanstaafl]

Hi everyone,

I need some help with converting a number (in a text field) to a
different type.

The type of number is time, and it is in the form of:

hh:mm:ss

I need to convert this to just minutes, rounded up, so if ss is more
than 30 it adds another minute.

I'm at a loss as to how to even start (I'm not a spreadsheet guy)...

I would appreciate any pointers on how to get this done...

Thanks!

-- 
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] Help needed with Excel spreadsheet

[Luuk]

On 6-3-2019 17:48, Tom Williams wrote:

On 3/6/19 8:26 AM, Tom Williams wrote:

I know it's odd to ask for Excel help in this mailing list but I need
help locating a LibreOffice Calc function/feature in Excel.  :)

I'm helping a friend create a billing invoice and since I'm a Linux
user, I'm using Calc to build the template.  So far, it's working well
and given I'm not an Excel user, I find myself struggling some in
getting Excel to "behave".  Anyway, I recently discovered the "/Expand
reference when new rows are inserted/" in Calc.  It does exactly what I
needed.   When I add/remove a row in/from the spreadsheet, my total
"SUM()" formula is updated automagically.

Does the equivalent feature exist in Excel?  What I've found is, when
adding rows *after* the last row in my SUM() formula, the new row is
excluded from the SUM() formula.   So, my formula is "=SUM(D7:D27)".
Once I add row 28, I need the SUM() formula to be updated to
"=SUM(D7:D28)".  Conversely, when row 28 is removed, I want the SUM()
formula to be updated to "=SUM(D7:D27".   In Calc, the "/Expand
reference when new rows are inserted/" feature does this work for me.

I did some web searching and found this article:

https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html

but I hope to find an easier and more flexible way to accomplish what I
need.  Or is that approach what I really should use?

Thanks in advance!

Peace...

"The Other" Tom



Nevermind!  I found this:

https://bettersolutions.com/excel/formulas/automatic-expansion.htm

That should do what I need!

Thanks anyway!  :)

Peace...

"The Other" Tom


In EXCEL you can do this:

A   B   C
1   2   3
=A2+3   =B2+3   =C2+3

(I used CTRL+T to show formulas, you should see the values 4,5,6)

When you select A1:C3, and choose 'Insert'/'Table'

After this, typing the value 7 in cell 'A4', en pressing 'Enter' results 
in the fields B4 and C4 being updated with the same formula as in row 3.


How can this be achieved in LibreOffice Calc ?






--
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] Help needed with Excel spreadsheet

[Tom Williams]

On 3/6/19 5:42 PM, Tom Davies wrote:
> Hi :)
> Sounds like a perfect time to suggest they install LO too.
>
> If an Excel person hadn't immediately found what they were looking for in
> Calc they would have immediately claimed that Calc couldn't do the task.
>
> There are loads of articles about LO that have such posts in the comments
> section.  It can be fun to refute them in as few words as possible.
> Regards from a Tom :)


You know, I'm about ready to do that.   After doing some experimentation
with Excel today, I found it just doesn't want to "play nice" with what
I'm trying to do.  I want to have an image as the spreadsheet header and
have the basic formulas update when I add/remove rows.  I'm sure with
enough time, I could get Excel to behave but I've been able to get what
I needed working far more easily with Calc.

I haven't given up, just yet, but I'm really surprised at how stubborn
Excel is, when it comes to the things I'm trying to do with it.  :(

Peace...

"The Other" Tom

>
>
> On Wed, 6 Mar 2019 18:21 Luuk 
>> On 6-3-2019 17:48, Tom Williams wrote:
>>> On 3/6/19 8:26 AM, Tom Williams wrote:
 I know it's odd to ask for Excel help in this mailing list but I need
 help locating a LibreOffice Calc function/feature in Excel.  :)

 I'm helping a friend create a billing invoice and since I'm a Linux
 user, I'm using Calc to build the template.  So far, it's working well
 and given I'm not an Excel user, I find myself struggling some in
 getting Excel to "behave".  Anyway, I recently discovered the "/Expand
 reference when new rows are inserted/" in Calc.  It does exactly what I
 needed.   When I add/remove a row in/from the spreadsheet, my total
 "SUM()" formula is updated automagically.

 Does the equivalent feature exist in Excel?  What I've found is, when
 adding rows *after* the last row in my SUM() formula, the new row is
 excluded from the SUM() formula.   So, my formula is "=SUM(D7:D27)".
 Once I add row 28, I need the SUM() formula to be updated to
 "=SUM(D7:D28)".  Conversely, when row 28 is removed, I want the SUM()
 formula to be updated to "=SUM(D7:D27".   In Calc, the "/Expand
 reference when new rows are inserted/" feature does this work for me.

 I did some web searching and found this article:


>> https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html
 but I hope to find an easier and more flexible way to accomplish what I
 need.  Or is that approach what I really should use?

 Thanks in advance!

 Peace...

 "The Other" Tom


>>> Nevermind!  I found this:
>>>
>>> https://bettersolutions.com/excel/formulas/automatic-expansion.htm
>>>
>>> That should do what I need!
>>>
>>> Thanks anyway!  :)
>>>
>>> Peace...
>>>
>>> "The Other" Tom
>>>
>> When i was reading above, i thought you were search for subtotals.
>>
>> Excel has also a function named SUBTOTAL()
>>
>>
>> https://support.office.com/en-us/article/subtotal-function-7b027003-f060-4ade-9040-e478765b9939
>>
>>
>>
>>
>> --
>> 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
>>

-- 
/When I leave, I don't know what I'm hoping to find,
And when I leave, I don't know what I'm leaving behind.../

-- 
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] Help needed with Excel spreadsheet

[Tom Williams]

On 3/6/19 10:18 AM, Luuk wrote:
>
> On 6-3-2019 17:48, Tom Williams wrote:
>> On 3/6/19 8:26 AM, Tom Williams wrote:
>>> I know it's odd to ask for Excel help in this mailing list but I need
>>> help locating a LibreOffice Calc function/feature in Excel.  :)
>>>
>>> I'm helping a friend create a billing invoice and since I'm a Linux
>>> user, I'm using Calc to build the template.  So far, it's working well
>>> and given I'm not an Excel user, I find myself struggling some in
>>> getting Excel to "behave".  Anyway, I recently discovered the "/Expand
>>> reference when new rows are inserted/" in Calc.  It does exactly what I
>>> needed.   When I add/remove a row in/from the spreadsheet, my total
>>> "SUM()" formula is updated automagically.
>>>
>>> Does the equivalent feature exist in Excel?  What I've found is, when
>>> adding rows *after* the last row in my SUM() formula, the new row is
>>> excluded from the SUM() formula.   So, my formula is "=SUM(D7:D27)".
>>> Once I add row 28, I need the SUM() formula to be updated to
>>> "=SUM(D7:D28)".  Conversely, when row 28 is removed, I want the SUM()
>>> formula to be updated to "=SUM(D7:D27".   In Calc, the "/Expand
>>> reference when new rows are inserted/" feature does this work for me.
>>>
>>> I did some web searching and found this article:
>>>
>>> https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html
>>>
>>>
>>> but I hope to find an easier and more flexible way to accomplish what I
>>> need.  Or is that approach what I really should use?
>>>
>>> Thanks in advance!
>>>
>>> Peace...
>>>
>>> "The Other" Tom
>>>
>>>
>> Nevermind!  I found this:
>>
>> https://bettersolutions.com/excel/formulas/automatic-expansion.htm
>>
>> That should do what I need!
>>
>> Thanks anyway!  :)
>>
>> Peace...
>>
>> "The Other" Tom
>>
> When i was reading above, i thought you were search for subtotals.
>
> Excel has also a function named SUBTOTAL()
>
> https://support.office.com/en-us/article/subtotal-function-7b027003-f060-4ade-9040-e478765b9939
>
>
>
>
>
Thanks for the info!  Sorry I wasn't more clear.  :(   I just needed the
SUM formulas to update as I added/deleted rows.  :)

Peace...

"The Other" Tom

-- 
/When I leave, I don't know what I'm hoping to find,
And when I leave, I don't know what I'm leaving behind.../

-- 
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] Help needed with Excel spreadsheet

[Tom Davies]

Hi :)
Sounds like a perfect time to suggest they install LO too.

If an Excel person hadn't immediately found what they were looking for in
Calc they would have immediately claimed that Calc couldn't do the task.

There are loads of articles about LO that have such posts in the comments
section.  It can be fun to refute them in as few words as possible.
Regards from a Tom :)


On Wed, 6 Mar 2019 18:21 Luuk 
> On 6-3-2019 17:48, Tom Williams wrote:
> > On 3/6/19 8:26 AM, Tom Williams wrote:
> >> I know it's odd to ask for Excel help in this mailing list but I need
> >> help locating a LibreOffice Calc function/feature in Excel.  :)
> >>
> >> I'm helping a friend create a billing invoice and since I'm a Linux
> >> user, I'm using Calc to build the template.  So far, it's working well
> >> and given I'm not an Excel user, I find myself struggling some in
> >> getting Excel to "behave".  Anyway, I recently discovered the "/Expand
> >> reference when new rows are inserted/" in Calc.  It does exactly what I
> >> needed.   When I add/remove a row in/from the spreadsheet, my total
> >> "SUM()" formula is updated automagically.
> >>
> >> Does the equivalent feature exist in Excel?  What I've found is, when
> >> adding rows *after* the last row in my SUM() formula, the new row is
> >> excluded from the SUM() formula.   So, my formula is "=SUM(D7:D27)".
> >> Once I add row 28, I need the SUM() formula to be updated to
> >> "=SUM(D7:D28)".  Conversely, when row 28 is removed, I want the SUM()
> >> formula to be updated to "=SUM(D7:D27".   In Calc, the "/Expand
> >> reference when new rows are inserted/" feature does this work for me.
> >>
> >> I did some web searching and found this article:
> >>
> >>
> https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html
> >>
> >> but I hope to find an easier and more flexible way to accomplish what I
> >> need.  Or is that approach what I really should use?
> >>
> >> Thanks in advance!
> >>
> >> Peace...
> >>
> >> "The Other" Tom
> >>
> >>
> > Nevermind!  I found this:
> >
> > https://bettersolutions.com/excel/formulas/automatic-expansion.htm
> >
> > That should do what I need!
> >
> > Thanks anyway!  :)
> >
> > Peace...
> >
> > "The Other" Tom
> >
> When i was reading above, i thought you were search for subtotals.
>
> Excel has also a function named SUBTOTAL()
>
>
> https://support.office.com/en-us/article/subtotal-function-7b027003-f060-4ade-9040-e478765b9939
>
>
>
>
> --
> 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
>

-- 
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] Help needed with Excel spreadsheet

[Luuk]

On 6-3-2019 17:48, Tom Williams wrote:

On 3/6/19 8:26 AM, Tom Williams wrote:

I know it's odd to ask for Excel help in this mailing list but I need
help locating a LibreOffice Calc function/feature in Excel.  :)

I'm helping a friend create a billing invoice and since I'm a Linux
user, I'm using Calc to build the template.  So far, it's working well
and given I'm not an Excel user, I find myself struggling some in
getting Excel to "behave".  Anyway, I recently discovered the "/Expand
reference when new rows are inserted/" in Calc.  It does exactly what I
needed.   When I add/remove a row in/from the spreadsheet, my total
"SUM()" formula is updated automagically.

Does the equivalent feature exist in Excel?  What I've found is, when
adding rows *after* the last row in my SUM() formula, the new row is
excluded from the SUM() formula.   So, my formula is "=SUM(D7:D27)".
Once I add row 28, I need the SUM() formula to be updated to
"=SUM(D7:D28)".  Conversely, when row 28 is removed, I want the SUM()
formula to be updated to "=SUM(D7:D27".   In Calc, the "/Expand
reference when new rows are inserted/" feature does this work for me.

I did some web searching and found this article:

https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html

but I hope to find an easier and more flexible way to accomplish what I
need.  Or is that approach what I really should use?

Thanks in advance!

Peace...

"The Other" Tom



Nevermind!  I found this:

https://bettersolutions.com/excel/formulas/automatic-expansion.htm

That should do what I need!

Thanks anyway!  :)

Peace...

"The Other" Tom


When i was reading above, i thought you were search for subtotals.

Excel has also a function named SUBTOTAL()

https://support.office.com/en-us/article/subtotal-function-7b027003-f060-4ade-9040-e478765b9939




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