[libreoffice-users] Re: Problems opening LibreOffice

[Wendy Becker]

To continue…
The version I have is 6.1.4.2 last modified December 22, 2018.

> On May 1, 2024, at 11:56 AM, Wendy Becker  wrote:
> 
> I recently got a new MacBook Air and I am not able to open LibreOffice on my 
> new computer. I have had it on my old iMac for years. After speaking with 
> Apple they suggested I contact you so that I don’t have to pay the $8.99 fee 
> to get the latest updates.
> I would appreciate you assistance.
> Thank you,
> Wendy Becker


-- 
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] Re: Writer, how to replace Manual Page Breaks (CNTRL-ENTER) with a printable character string.

[Ian Bertram]

I use the alternative find and replace add-on and can recommend it.

On Tue, 26 Mar 2024, 13:15 W. Robert J. Funnell, Prof., <
robert.funn...@mcgill.ca> wrote:

> Honorato -
>
> I missed seeing your message. I think you can do what you want using the
> Alternative Find & Replace extension (
> https://extensions.libreoffice.org/en/extensions/show/alternative-dialog-find-replace-for-writer).
> As described at http://macrojtb.hys.cz/HelpAltSearch_en.html, specify \m
> to find manual page breaks and specify \r (in the Replace field) to remove
> them.
>
> - Robert
>
> 
> From: Mike Flannigan 
> Sent: March 26, 2024 08:59
> To: users@global.libreoffice.org 
> Cc: honoratomor...@yahoo.es 
> Subject: [libreoffice-users] Re: Writer, how to replace Manual Page Breaks
> (CNTRL-ENTER) with a printable character string.
>
>
> You did a good job of explaining your problem.
> Sorry we do not have an answer to your question.
>
>
> Mike
>
>
> On 3/20/24 09:09, users+h...@global.libreoffice.org wrote:
> > Subject:
> > [libreoffice-users] Writer, how to replace Manual Page Breaks
> > (CNTRL-ENTER) with a printable character string.
> > From:
> > honorato moreno ruiz 
> > Date:
> > 3/19/24, 14:04
> >
> > To:
> > "users@global.libreoffice.org" 
> >
> >
> >   Good afternoon. Sorry my English
> > I need to replace Manual Page Breaks (CNTRL-ENTER) with a printable
> character string.
> > My problem is that the "Search" function does not distinguish the Manual
> Page Break from the Paragraph Break (ENTER). That is, putting the
> expression "$" in the "Search" field gives me both the Page Breaks and the
> Paragraph Breaks. This way it replaces all of them, the page ones and the
> paragraph ones, which is not what I want (I need to keep the paragraph
> ones).
> > In other words, I can't find the regular expression to search for Page
> Break and it doesn't give me paragraph breaks at the same time.
> > There is a similar question in April 2023, which can be found by "Remove
> manual page breaks in Writer". But the solution does not work for me,
> because my colleague pjferra needed to replace the page breaks with
> paragraph breaks, and Kyodake responds, correctly, to that need in which it
> does not matter to replace the two types of breaks in the operation, since
> they are replaced by paragraph breaks.
> > Has this situation arisen before for you? Have you managed to solve it?
> > Thank you so much for your attention.
> > Honorato Moreno
>
>
>
> --
> 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] Re: Writer, how to replace Manual Page Breaks (CNTRL-ENTER) with a printable character string.

[W. Robert J. Funnell, Prof.]

Honorato -

I missed seeing your message. I think you can do what you want using the 
Alternative Find & Replace extension 
(https://extensions.libreoffice.org/en/extensions/show/alternative-dialog-find-replace-for-writer).
 As described at http://macrojtb.hys.cz/HelpAltSearch_en.html, specify \m to 
find manual page breaks and specify \r (in the Replace field) to remove them.

- Robert


From: Mike Flannigan 
Sent: March 26, 2024 08:59
To: users@global.libreoffice.org 
Cc: honoratomor...@yahoo.es 
Subject: [libreoffice-users] Re: Writer, how to replace Manual Page Breaks 
(CNTRL-ENTER) with a printable character string.


You did a good job of explaining your problem.
Sorry we do not have an answer to your question.


Mike


On 3/20/24 09:09, users+h...@global.libreoffice.org wrote:
> Subject:
> [libreoffice-users] Writer, how to replace Manual Page Breaks
> (CNTRL-ENTER) with a printable character string.
> From:
> honorato moreno ruiz 
> Date:
> 3/19/24, 14:04
>
> To:
> "users@global.libreoffice.org" 
>
>
>   Good afternoon. Sorry my English
> I need to replace Manual Page Breaks (CNTRL-ENTER) with a printable character 
> string.
> My problem is that the "Search" function does not distinguish the Manual Page 
> Break from the Paragraph Break (ENTER). That is, putting the expression "$" 
> in the "Search" field gives me both the Page Breaks and the Paragraph Breaks. 
> This way it replaces all of them, the page ones and the paragraph ones, which 
> is not what I want (I need to keep the paragraph ones).
> In other words, I can't find the regular expression to search for Page Break 
> and it doesn't give me paragraph breaks at the same time.
> There is a similar question in April 2023, which can be found by "Remove 
> manual page breaks in Writer". But the solution does not work for me, because 
> my colleague pjferra needed to replace the page breaks with paragraph breaks, 
> and Kyodake responds, correctly, to that need in which it does not matter to 
> replace the two types of breaks in the operation, since they are replaced by 
> paragraph breaks.
> Has this situation arisen before for you? Have you managed to solve it?
> Thank you so much for your attention.
> Honorato Moreno



-- 
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] Re: Writer, how to replace Manual Page Breaks (CNTRL-ENTER) with a printable character string.

[Mike Flannigan]

You did a good job of explaining your problem.
Sorry we do not have an answer to your question.


Mike


On 3/20/24 09:09, users+h...@global.libreoffice.org wrote:

Subject:
[libreoffice-users] Writer, how to replace Manual Page Breaks 
(CNTRL-ENTER) with a printable character string.

From:
honorato moreno ruiz 
Date:
3/19/24, 14:04

To:
"users@global.libreoffice.org" 


  Good afternoon. Sorry my English
I need to replace Manual Page Breaks (CNTRL-ENTER) with a printable character 
string.
My problem is that the "Search" function does not distinguish the Manual Page Break from the 
Paragraph Break (ENTER). That is, putting the expression "$" in the "Search" field gives 
me both the Page Breaks and the Paragraph Breaks. This way it replaces all of them, the page ones and the 
paragraph ones, which is not what I want (I need to keep the paragraph ones).
In other words, I can't find the regular expression to search for Page Break 
and it doesn't give me paragraph breaks at the same time.
There is a similar question in April 2023, which can be found by "Remove manual page 
breaks in Writer". But the solution does not work for me, because my colleague 
pjferra needed to replace the page breaks with paragraph breaks, and Kyodake responds, 
correctly, to that need in which it does not matter to replace the two types of breaks in 
the operation, since they are replaced by paragraph breaks.
Has this situation arisen before for you? Have you managed to solve it?
Thank you so much for your attention.
Honorato Moreno


--
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] Re: putting text in 2 or 3 columns on a single page

[Remy Gauthier]

Greetings,

Your easiest solution is sections. To create them, highlight the text
you want to place in columns and then use Format > Columns... Enter the
number of columns you want, with optional spacing (I suggest 0,1 cm),
and the format of a separator line if you want. Then hit OK. You can
force a column break by using Insert > More Breaks > Insert Column
break (this will make the text move to the next column). If you want to
change the look & feel of your columns after, you can use Format >
Sections, then select your section and click Options.

I hope this helps.
Rémy.

Le mardi 19 mars 2024 à 17:10 +, W. Robert J. Funnell, Prof. a
écrit :
> The detail is interesting, and also helps to understand the context.
> I'm more familiar with page styles than with sections, but a quick
> search suggests that sections will do what you need. If your changes
> in the number of columns always occur at page breaks, page styles
> might be more elegant, but whatever works for you ... :-) Good luck
> with getting your father's poems printed the way you want them.
> - Robert
> 
> 
> From: Keith Jackson 
> Sent: March 19, 2024 12:55
> To: W. Robert J. Funnell, Prof. 
> Cc: users@global.libreoffice.org 
> Subject: Re: [libreoffice-users] Re: putting text in 2 or 3 columns
> on a single page
> 
> I wanted to avoid defining page styles since this requires, I assume,
> switching back and forth between styles on some pages and is more
> sophistication than I want to get into.  Also it would require me to
> thoroughly understand styles.
> 
> My father, or maybe my stepmother, had typed in his collection of
> poems years ago on a semi-fancy paper and assembled them into a
> “book” held together by a cerlox binding.  He gave copies to his sons
> and daughter and possible to one or two other family members or
> family friends.  I’m trying to retain the appearance of his pages in
> my digital copy.  Unfortunately, my father died in 2018 so asking him
> about any of this is impossible.
> 
> I had planned to type and enter his poems into a text document of
> some kind years ago but entering it all by hand was onerous since I’m
> not a touch typist and I stopped this endeavour.
> 
> But more recently I have discovered that OCR (optical character
> recognition) has improved vastly since the last time I tried it.  I
> discovered, while doing something else, that I could photo the pages
> of his book with my cell phone, then use Google Lens to select and
> copy just the text from these pages. I mailed the text to myself.
> Then saved the text into page files (rtf (rich text format) files)
> and the text was preserved and there was almost never any extraneous
> characters.
> 
> Because this capture process lost the line structure of the poems, I
> had to edit every page file and re-establish the poem line
> structure.  That’s all done (including correcting some minor spelling
> and grammatical mistakes in the process) and I am now trying to
> assemble the poems into a single Word document using LibreOffice.
> 
> My ultimate plan is to use this file to print copies of his poems
> into hardcover book copies.  One of my brothers has lost or misplaced
> his copy of the cerlox book already.  I know there are relatively
> inexpensive places to get a small number of books like this printed
> so I will distribute his poems to family members and possibly friends
> as a more durable medium for his poetry.
> 
> Sorry for the detail but just thought you might be interested.
> Another person was very helpful and suggested using sections for the
> 2 and 3 column pages.  So, I’m going to try that approach since it
> sounds excellent.
> 
> Keith
> 
> 
> 
> On Mar 19, 2024, at 12:18 PM, W. Robert J. Funnell, Prof.
> mailto:robert.funn...@mcgill.ca>> wrote:
> 
> Keith -
> 
> Have you considered defining 2-column and 3-column page styles? Press
> F11 to see the Styles dialogue; click on the icon for Page Styles;
> right-click on 'Default Page Style'; and click on 'New'. There's a
> tab for Columns. When you want to switch page styles, you can do
> Insert > More Breaks > Manual Break. Then select 'Page break' and the
> desired style for the next page.
> 
> - Robert
> 
> ____
> From: Keith Jackson
> mailto:kmjack...@sympatico.ca>>
> Sent: March 19, 2024 11:56
> To: Mike Flannigan mailto:mf...@mflan.com>>
> Cc: users@global.libreoffice.org<mailto:users@global.libreoffice.org>
> mailto:users@global.libreoffice.org>>
> Subject: [libreoffice-users] Re: putting text in 2 or 3 columns on a
> single page
> 
> [You don't often get email from
> kmjack...@sympatico.ca<mailto:k

Re: [libreoffice-users] Re: putting text in 2 or 3 columns on a single page

[W. Robert J. Funnell, Prof.]

The detail is interesting, and also helps to understand the context. I'm more 
familiar with page styles than with sections, but a quick search suggests that 
sections will do what you need. If your changes in the number of columns always 
occur at page breaks, page styles might be more elegant, but whatever works for 
you ... :-) Good luck with getting your father's poems printed the way you want 
them.
- Robert


From: Keith Jackson 
Sent: March 19, 2024 12:55
To: W. Robert J. Funnell, Prof. 
Cc: users@global.libreoffice.org 
Subject: Re: [libreoffice-users] Re: putting text in 2 or 3 columns on a single 
page

I wanted to avoid defining page styles since this requires, I assume, switching 
back and forth between styles on some pages and is more sophistication than I 
want to get into.  Also it would require me to thoroughly understand styles.

My father, or maybe my stepmother, had typed in his collection of poems years 
ago on a semi-fancy paper and assembled them into a “book” held together by a 
cerlox binding.  He gave copies to his sons and daughter and possible to one or 
two other family members or family friends.  I’m trying to retain the 
appearance of his pages in my digital copy.  Unfortunately, my father died in 
2018 so asking him about any of this is impossible.

I had planned to type and enter his poems into a text document of some kind 
years ago but entering it all by hand was onerous since I’m not a touch typist 
and I stopped this endeavour.

But more recently I have discovered that OCR (optical character recognition) 
has improved vastly since the last time I tried it.  I discovered, while doing 
something else, that I could photo the pages of his book with my cell phone, 
then use Google Lens to select and copy just the text from these pages. I 
mailed the text to myself. Then saved the text into page files (rtf (rich text 
format) files) and the text was preserved and there was almost never any 
extraneous characters.

Because this capture process lost the line structure of the poems, I had to 
edit every page file and re-establish the poem line structure.  That’s all done 
(including correcting some minor spelling and grammatical mistakes in the 
process) and I am now trying to assemble the poems into a single Word document 
using LibreOffice.

My ultimate plan is to use this file to print copies of his poems into 
hardcover book copies.  One of my brothers has lost or misplaced his copy of 
the cerlox book already.  I know there are relatively inexpensive places to get 
a small number of books like this printed so I will distribute his poems to 
family members and possibly friends as a more durable medium for his poetry.

Sorry for the detail but just thought you might be interested.
Another person was very helpful and suggested using sections for the 2 and 3 
column pages.  So, I’m going to try that approach since it sounds excellent.

Keith



On Mar 19, 2024, at 12:18 PM, W. Robert J. Funnell, Prof. 
mailto:robert.funn...@mcgill.ca>> wrote:

Keith -

Have you considered defining 2-column and 3-column page styles? Press F11 to 
see the Styles dialogue; click on the icon for Page Styles; right-click on 
'Default Page Style'; and click on 'New'. There's a tab for Columns. When you 
want to switch page styles, you can do Insert > More Breaks > Manual Break. 
Then select 'Page break' and the desired style for the next page.

- Robert


From: Keith Jackson mailto:kmjack...@sympatico.ca>>
Sent: March 19, 2024 11:56
To: Mike Flannigan mailto:mf...@mflan.com>>
Cc: users@global.libreoffice.org<mailto:users@global.libreoffice.org> 
mailto:users@global.libreoffice.org>>
Subject: [libreoffice-users] Re: putting text in 2 or 3 columns on a single page

[You don't often get email from 
kmjack...@sympatico.ca<mailto:kmjack...@sympatico.ca>. Learn why this is 
important at https://aka.ms/LearnAboutSenderIdentification ]

Thanks, Mike, for your suggestion.

I had 3 ideas actually based on what I saw in the LibreOffice Writer manual.
I wondered if Frames, or Sections, or Tables were the best approach since it 
looked like any of these might work.
Having 3 tables side by side on the same page might work but I think text for 
that page would have to be manually inserted into the tables and it wouldn’t 
flow automatically from the first to the second and to the third table.

I wasn’t clear on the application of frames or sections to do this which is why 
I thought I’d ask the support email.
another person wrote me and basically suggested a section as the best solution.

But your suggestion was much appreciated.

Thanks,
Keith


> On Mar 19, 2024, at 11:28 AM, Mike Flannigan 
> mailto:mf...@mflan.com>> wrote:
>
>
> Setting individual tables that are left aligned, or center
> aligned, or right aligned may be a good option.
>
>
> Mike
>
>
> On 3/19/24 

Re: [libreoffice-users] Re: putting text in 2 or 3 columns on a single page

[Keith Jackson]

I wanted to avoid defining page styles since this requires, I assume, switching 
back and forth between styles on some pages and is more sophistication than I 
want to get into.  Also it would require me to thoroughly understand styles.

My father, or maybe my stepmother, had typed in his collection of poems years 
ago on a semi-fancy paper and assembled them into a “book” held together by a 
cerlox binding.  He gave copies to his sons and daughter and possible to one or 
two other family members or family friends.  I’m trying to retain the 
appearance of his pages in my digital copy.  Unfortunately, my father died in 
2018 so asking him about any of this is impossible.

I had planned to type and enter his poems into a text document of some kind 
years ago but entering it all by hand was onerous since I’m not a touch typist 
and I stopped this endeavour.

But more recently I have discovered that OCR (optical character recognition) 
has improved vastly since the last time I tried it.  I discovered, while doing 
something else, that I could photo the pages of his book with my cell phone, 
then use Google Lens to select and copy just the text from these pages. I 
mailed the text to myself. Then saved the text into page files (rtf (rich text 
format) files) and the text was preserved and there was almost never any 
extraneous characters.

Because this capture process lost the line structure of the poems, I had to 
edit every page file and re-establish the poem line structure.  That’s all done 
(including correcting some minor spelling and grammatical mistakes in the 
process) and I am now trying to assemble the poems into a single Word document 
using LibreOffice.

My ultimate plan is to use this file to print copies of his poems into 
hardcover book copies.  One of my brothers has lost or misplaced his copy of 
the cerlox book already.  I know there are relatively inexpensive places to get 
a small number of books like this printed so I will distribute his poems to 
family members and possibly friends as a more durable medium for his poetry.

Sorry for the detail but just thought you might be interested.
Another person was very helpful and suggested using sections for the 2 and 3 
column pages.  So, I’m going to try that approach since it sounds excellent.

Keith

 

> On Mar 19, 2024, at 12:18 PM, W. Robert J. Funnell, Prof. 
>  wrote:
> 
> Keith -
> 
> Have you considered defining 2-column and 3-column page styles? Press F11 to 
> see the Styles dialogue; click on the icon for Page Styles; right-click on 
> 'Default Page Style'; and click on 'New'. There's a tab for Columns. When you 
> want to switch page styles, you can do Insert > More Breaks > Manual Break. 
> Then select 'Page break' and the desired style for the next page.
> 
> - Robert
> 
> From: Keith Jackson mailto:kmjack...@sympatico.ca>>
> Sent: March 19, 2024 11:56
> To: Mike Flannigan mailto:mf...@mflan.com>>
> Cc: users@global.libreoffice.org <mailto:users@global.libreoffice.org> 
> mailto:users@global.libreoffice.org>>
> Subject: [libreoffice-users] Re: putting text in 2 or 3 columns on a single 
> page
>  
> [You don't often get email from kmjack...@sympatico.ca 
> <mailto:kmjack...@sympatico.ca>. Learn why this is important at 
> https://aka.ms/LearnAboutSenderIdentification 
> <https://aka.ms/LearnAboutSenderIdentification> ]
> 
> Thanks, Mike, for your suggestion.
> 
> I had 3 ideas actually based on what I saw in the LibreOffice Writer manual.
> I wondered if Frames, or Sections, or Tables were the best approach since it 
> looked like any of these might work.
> Having 3 tables side by side on the same page might work but I think text for 
> that page would have to be manually inserted into the tables and it wouldn’t 
> flow automatically from the first to the second and to the third table.
> 
> I wasn’t clear on the application of frames or sections to do this which is 
> why I thought I’d ask the support email.
> another person wrote me and basically suggested a section as the best 
> solution.
> 
> But your suggestion was much appreciated.
> 
> Thanks,
> Keith
> 
> 
> > On Mar 19, 2024, at 11:28 AM, Mike Flannigan  > <mailto:mf...@mflan.com>> wrote:
> >
> >
> > Setting individual tables that are left aligned, or center
> > aligned, or right aligned may be a good option.
> >
> >
> > Mike
> >
> >
> > On 3/19/24 09:06, users+h...@global.libreoffice.org 
> > <mailto:users+h...@global.libreoffice.org> 
> > <mailto:users+h...@global.libreoffice.org 
> > <mailto:users+h...@global.libreoffice.org>> wrote:
> >>
> >> users_59192.eml
> >> Subject: [libreoffice-users] putting text in 2 or 3 columns on a single 
> >> pag

Re: [libreoffice-users] Re: putting text in 2 or 3 columns on a single page

[W. Robert J. Funnell, Prof.]

Keith -

Have you considered defining 2-column and 3-column page styles? Press F11 to 
see the Styles dialogue; click on the icon for Page Styles; right-click on 
'Default Page Style'; and click on 'New'. There's a tab for Columns. When you 
want to switch page styles, you can do Insert > More Breaks > Manual Break. 
Then select 'Page break' and the desired style for the next page.

- Robert


From: Keith Jackson 
Sent: March 19, 2024 11:56
To: Mike Flannigan 
Cc: users@global.libreoffice.org 
Subject: [libreoffice-users] Re: putting text in 2 or 3 columns on a single page

[You don't often get email from kmjack...@sympatico.ca. Learn why this is 
important at https://aka.ms/LearnAboutSenderIdentification ]

Thanks, Mike, for your suggestion.

I had 3 ideas actually based on what I saw in the LibreOffice Writer manual.
I wondered if Frames, or Sections, or Tables were the best approach since it 
looked like any of these might work.
Having 3 tables side by side on the same page might work but I think text for 
that page would have to be manually inserted into the tables and it wouldn’t 
flow automatically from the first to the second and to the third table.

I wasn’t clear on the application of frames or sections to do this which is why 
I thought I’d ask the support email.
another person wrote me and basically suggested a section as the best solution.

But your suggestion was much appreciated.

Thanks,
Keith


> On Mar 19, 2024, at 11:28 AM, Mike Flannigan  wrote:
>
>
> Setting individual tables that are left aligned, or center
> aligned, or right aligned may be a good option.
>
>
> Mike
>
>
> On 3/19/24 09:06, users+h...@global.libreoffice.org 
> <mailto:users+h...@global.libreoffice.org> wrote:
>>
>> users_59192.eml
>> Subject: [libreoffice-users] putting text in 2 or 3 columns on a single page
>> From: Keith Jackson  <mailto:kmjack...@sympatico.ca>
>> Date: 3/18/24, 20:57
>> To: users@global.libreoffice.org <mailto:users@global.libreoffice.org>
>> You may have seen this question many times so I will apologize in advance 
>> for asking it.
>>
>> I have a Writer document formatted as docx.  It will contain some of my 
>> father’s poems but I have a need on a few pages to have the poem appear in 
>> two or three columns on a page continuing from the bottom of, or a specified 
>> point in, the first column to the second column and, in one case, to a third 
>> column.  The text must not wrap within each column because it is lines of 
>> poetry.
>>
>> Can you tell me the best way to do this?   I’ve checked the manual and have 
>> some ideas but would appreciate someone guiding me to the best  method to do 
>> this.
>>
>> Thank you for your time in advance.   Oh, and in case it is important, I am 
>> using LibreOffice 7.3.7.2.
>>
>> Keith Jackson
>> Toronto, Ontario, Canada
>>
>


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? 
https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.libreoffice.org%2Fget-help%2Fmailing-lists%2Fhow-to-unsubscribe%2F=05%7C02%7Crobert.funnell%40mcgill.ca%7Ccb11f71baa8449a071bb08dc482e836c%7Ccd31967152e74a68afa9fcf8f89f09ea%7C0%7C0%7C638464611827315437%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C=2DeC0WpP%2Bsw2uqhnIFejzGeQ6MAv5nbqgNIKmDpEjdY%3D=0<https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more: 
https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.documentfoundation.org%2FNetiquette=05%7C02%7Crobert.funnell%40mcgill.ca%7Ccb11f71baa8449a071bb08dc482e836c%7Ccd31967152e74a68afa9fcf8f89f09ea%7C0%7C0%7C638464611827333484%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C=4TwCUEQI%2F%2F%2BW2xqXmfKHE6J%2Fx13gtjmXDw3H17lujWs%3D=0<https://wiki.documentfoundation.org/Netiquette>
List archive: 
https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flistarchives.libreoffice.org%2Fglobal%2Fusers%2F=05%7C02%7Crobert.funnell%40mcgill.ca%7Ccb11f71baa8449a071bb08dc482e836c%7Ccd31967152e74a68afa9fcf8f89f09ea%7C0%7C0%7C638464611827348541%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C=%2BEw2uYmxvXcbFBqO2MilMWx6ylB6VWBWQEKdD6LUxo4%3D=0<https://listarchives.libreoffice.org/global/users/>
Privacy Policy: 
https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.documentfoundation.org%2Fprivacy=05%7C02%7Crobert.funnell%40mcgill.ca%7Ccb11f71baa8449a071bb08dc482e836c%7Ccd31967152e74a68afa9fcf8f89f09ea%7C0%7C0%7C638464611827361877%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C

[libreoffice-users] Re: putting text in 2 or 3 columns on a single page

[Keith Jackson]

Thanks, Mike, for your suggestion. 

I had 3 ideas actually based on what I saw in the LibreOffice Writer manual.  
I wondered if Frames, or Sections, or Tables were the best approach since it 
looked like any of these might work.
Having 3 tables side by side on the same page might work but I think text for 
that page would have to be manually inserted into the tables and it wouldn’t 
flow automatically from the first to the second and to the third table.

I wasn’t clear on the application of frames or sections to do this which is why 
I thought I’d ask the support email.
another person wrote me and basically suggested a section as the best solution.

But your suggestion was much appreciated.

Thanks,
Keith
 

> On Mar 19, 2024, at 11:28 AM, Mike Flannigan  wrote:
> 
> 
> Setting individual tables that are left aligned, or center
> aligned, or right aligned may be a good option.
> 
> 
> Mike
> 
> 
> On 3/19/24 09:06, users+h...@global.libreoffice.org 
>  wrote:
>> 
>> users_59192.eml
>> Subject: [libreoffice-users] putting text in 2 or 3 columns on a single page
>> From: Keith Jackson  
>> Date: 3/18/24, 20:57
>> To: users@global.libreoffice.org 
>> You may have seen this question many times so I will apologize in advance 
>> for asking it.
>> 
>> I have a Writer document formatted as docx.  It will contain some of my 
>> father’s poems but I have a need on a few pages to have the poem appear in 
>> two or three columns on a page continuing from the bottom of, or a specified 
>> point in, the first column to the second column and, in one case, to a third 
>> column.  The text must not wrap within each column because it is lines of 
>> poetry.
>> 
>> Can you tell me the best way to do this?   I’ve checked the manual and have 
>> some ideas but would appreciate someone guiding me to the best  method to do 
>> this.
>> 
>> Thank you for your time in advance.   Oh, and in case it is important, I am 
>> using LibreOffice 7.3.7.2.
>> 
>> Keith Jackson
>> Toronto, Ontario, Canada
>> 
> 


-- 
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] Re: putting text in 2 or 3 columns on a single page

[Mike Flannigan]

Setting individual tables that are left aligned, or center
aligned, or right aligned may be a good option.


Mike


On 3/19/24 09:06, users+h...@global.libreoffice.org wrote:


users_59192.eml

Subject:
[libreoffice-users] putting text in 2 or 3 columns on a single page
From:
Keith Jackson 
Date:
3/18/24, 20:57

To:
users@global.libreoffice.org


You may have seen this question many times so I will apologize in advance for 
asking it.

I have a Writer document formatted as docx.  It will contain some of my 
father’s poems but I have a need on a few pages to have the poem appear in two 
or three columns on a page continuing from the bottom of, or a specified point 
in, the first column to the second column and, in one case, to a third column.  
The text must not wrap within each column because it is lines of poetry.

Can you tell me the best way to do this?   I’ve checked the manual and have 
some ideas but would appreciate someone guiding me to the best  method to do 
this.

Thank you for your time in advance.   Oh, and in case it is important, I am 
using LibreOffice 7.3.7.2.

Keith Jackson
Toronto, Ontario, Canada




--
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] Re: Subject: Digest of users@global.libreoffice.org issue 4217 (59187-59188)

[Nathan Perkins]

I agree. I have successfully used Scribus for that purpose.

On 3/14/2024 12:06 AM, users+h...@global.libreoffice.org wrote:

Topics (messages 59187 through 59188):
- [libreoffice-users] Creating forms with math
-   59187 - "Thane K. Sherrington"
-
- [libreoffice-users] Creating forms with math
-   59188 - Robert Großkopf
-


--
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] Re: Master document and styles.

[Michael Tiernan]

On Wed, Jan 31, 2024, 6:03 PM Michael Tiernan 
wrote:

>
> 1) I'm going to (next time I try this) start by duplicating any style I
> want to use and prefix it with my project name so I can keep them easier to
> identify.
>


Now that I understand it better I'll answer the two questions I got in the
mail.

If one of my styles uses a predefined style like default paragraph text and
someone else changes that they won't know that it affects the rest of the
document so if I use a prefixed name cut off any connection to the other
formats.

So, yes I use a prefix with my styles and I tried to separate the "inherit
from thing and chain them to each other as best I can.

I have a template for each chapter/topic and I am trying to load changes in
styles into that and then I can propagate that across the sections. It's
ugly but the best I cand with my limited experience. (It also allows me to
document the procedure for updating the manual for those less versed in it.)

>

-- 
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] Re: Master document and styles.

[Michael Tiernan]

Okay, here's what I've "figured out so far." Based on some *very* limited
knowledge. Just from my point of view.

1) I'm going to (next time I try this) start by duplicating any style I
want to use and prefix it with my project name so I can keep them easier to
identify. (I don't have to go through the "did I modify that style" for my
project if I do that.)

2) My current mess was/is caused by not being clear on where the
"authority" of the styles resides. So, I'll keep a page template (an .odt
file) and *NEVER* modify the styles pages in the book. I have to modify the
master template then import it to my current document. Once I like it, then
import it into each separate part of the book. Each import using the
"overwrite" option.

3) The very first thing I'll duplicate is the default settings when I open
the blank page.

I will reiterate the desire, should it become an option, I want to "export"
a/some/all of the styles as a separate file, maybe a json, etc. where I can
then manage only the settings I care about.

Thanks for everyone's time and help!

-- 
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] Re: MISMO Classifier: how to set Instance Weights?

[Ulrich Mayring]

Hi Peter,

thank you very much, I will try this.

However, there is also an API method setChecksTurnedOff 
(https://weka.sourceforge.io/doc.packages/multiInstanceLearning/index.html?weka/classifiers/mi/MISMO.html) 
as well as a command-line option -no-checks. Are these the same?


Because I've already tried those two methods and the error still happened.

Kind regards,

Ulrich

Am 04.01.24 um 07:28:14 schrieb Peter Reutemann:

The only workaround would be to disable the capabilities testing
framework altogether (which I'd normally not advise to do).
Create the file "Capabilities.props" in the $HOME/wekafiles/props
directory with the following content:
Test=true


I meant:
Test=false

The other one enables the tests again. :-)

Cheers, Peter




--
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] Re: Welcome to users@global.libreoffice.org

[Jim Cunning]

LibreOffice shows printers in the print menu that no longer exist on
my system.  They do not appear in the print menus of any other
applications.  How do I remove them from LibreOffice?Version: 7.3.7.2 / 
LibreOffice CommunityBuild ID: 30(Build:2)CPU threads: 12; OS: Linux 6.2; UI 
render: default; VCL: kf5
(cairo+xcb)Locale: en-US (en_US.UTF-8); UI: en-USUbuntu package version: 
1:7.3.7-0ubuntu0.22.04.4Calc: threaded
-- 
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] Re: Subject: Digest of users@global.libreoffice.org issue 4156 (59012-59014)

[Nathan Perkins]

If Ctrl-click works to follow a link then you can change that behavior 
by going to Tools>Options>Security>Security Options and Warnings and 
uncheck the box for "Ctrl-click required to open hyperlinks"


On 11/18/2023 3:06 PM, users+h...@global.libreoffice.org wrote:

Topics (messages 59012 through 59014):
- [libreoffice-users] LO Writer master document defaults.
-   59012 - "Chris J."
-
- [libreoffice-users] Cross ref problem
-   59013 - Pat Brown
-
- [libreoffice-users] LO 7.6 and Win7pro
-   59014 - Pat Brown
-


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

[Madhu Patel]

Hi folks,

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

Ref: 
https://stackoverflow.com/questions/77163622/convert-a-multi-page-text-word-file-to-png-using-libreoffice-api-in-java

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

Re-writing, the question again:-
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-";


From: Eike Rathke 
Date: Tuesday, 26 September 2023 at 12:54 AM
To: Madhu Patel 
Cc: caol...@gmail.com , vmik...@collabora.com 
, markus.mohrh...@googlemail.com 
, sberg...@redhat.com 
Subject: Re: Convert a Multi-Page Text/word file to PNG using LibreOffice API 
in JAVA
EXTERNAL: Use caution when clicking on links or opening attachments.





-- 
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] Re: MY DOCX WAS AUTOMATICALLY REDECTED

[DaveB]

Reposted - Originally sent from non-subscribed address.

Swatee Garsa Wrote:
Hey, I Need your support. Yesterday i had saved a file as odt format 
today when I opened the file, it also completely changed pages were 
reduced, font style and size was changed. I am a freelancer, I need 
this file asap. Please give your support.


There is no conversion of the original file when you open a non-native 
file type and Libre|Office does not have the facility to redact or 
delete documents. Possibly, what you did was to open a .docx file then 
save it in .odt format, which means your original .docx file is still 
somewhere on your computer. If your original .docx file has been 
deleted/redacted, then you would have to have done that with another 
program (eg. your OS file manager). If you are saying that the new .odf 
document does not render with exactly the same appearance as the 
original .docx file it could be that the original had a complex 
structure that the save/export filter was unable to accurately translate 
it with the same appearance as the original. Unfortunately, the newer MS 
formats are something of a moving target for the creators of our 
save/export filters and there can be no guarantee of a a perfect 
translation.


Note: When posting for support on this mailing list, it is very helpful 
for our volunteers if you give as much information as possible, at least 
your OS (Operating System - eg. Linux, Mac, Solaris, Windows, etc.) and 
and the version of LibreOffice you are using.


Regards 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

[libreoffice-users] Re: [writer] bullets numbering

[Michael Powell]

On Fri, Apr 28, 2023 at 12:19 PM Michael Powell 
wrote:

>
>
> On Fri, Apr 28, 2023 at 11:24 AM Michael Powell 
> wrote:
>
>> Hello,
>>
>> How do I persuade LO Writer to present bullets and numbering in a style,
>> i.e.,
>>
>> 1. ...
>>   1.1 ...
>>   1.2 ...
>>   (i) ...
>>   (ii) ...
>> (a) ...
>>
>> And so forth.
>>
>
> By contrast, using the latest Apache OpenOffice 4.1.14, outline numbering
> appears to be correct, at least halfway what I would expect.
>

AH! (light bulb), I think I finally sorted it out... was getting confused
over what I think were Paragraph, levels, B+N choices. I can configure the
sublevels now along the lines what I was wanting.

Okay, it seems like perhaps Outline may work in LO versus OO... they key
> is, I think, if you customize B+N, need to be able to adjust "Show
> sublevels" ad hominem, but it seems to be disabled, regardless.
>
> Note especially the first couple of levels, 1.1, 1.2, I am so far
>> unsuccessful in doing so.
>>
>> At the moment running a somewhat older version, 7.0.1.2 (x64), so maybe
>> this has been addressed since, I do not know.
>>
>> Version: 7.0.1.2 (x64)
>> Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
>> CPU threads: 32; OS: Windows 10.0 Build 19041; UI render: Skia/Raster;
>> VCL: win
>> Locale: en-US (en_US); UI: en-US
>> Calc: CL
>>
>> Cheers, thank you,
>>
>> Michael
>>
>>

-- 
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] Re: [writer] bullets numbering

[Michael Powell]

On Fri, Apr 28, 2023 at 11:24 AM Michael Powell 
wrote:

> Hello,
>
> How do I persuade LO Writer to present bullets and numbering in a style,
> i.e.,
>
> 1. ...
>   1.1 ...
>   1.2 ...
>   (i) ...
>   (ii) ...
> (a) ...
>
> And so forth.
>

By contrast, using the latest Apache OpenOffice 4.1.14, outline numbering
appears to be correct, at least halfway what I would expect.

Okay, it seems like perhaps Outline may work in LO versus OO... they key
is, I think, if you customize B+N, need to be able to adjust "Show
sublevels" ad hominem, but it seems to be disabled, regardless.

Note especially the first couple of levels, 1.1, 1.2, I am so far
> unsuccessful in doing so.
>
> At the moment running a somewhat older version, 7.0.1.2 (x64), so maybe
> this has been addressed since, I do not know.
>
> Version: 7.0.1.2 (x64)
> Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
> CPU threads: 32; OS: Windows 10.0 Build 19041; UI render: Skia/Raster;
> VCL: win
> Locale: en-US (en_US); UI: en-US
> Calc: CL
>
> Cheers, thank you,
>
> Michael
>
>

-- 
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] Re: Combining vertical text direction of page with ‘right-to-left’ text direction of a table

[Regina Henschel]

Hi Eyal,

Eyal Rozenberg schrieb am 11.04.2023 um 11:59:
Anyway, with this being the state of affairs, I do not even know how the 
ODF spec _expects_ Vertical LTR or RTL text to be rendered - if at all. 
If you can point us to what it says about this, perhaps I could fully 
answer.


Text direction of the page and text direction of the table are both 
written with attribute style:writing-mode in the file markup. That is 
specified in 20.404 style:writing-mode in part 3.
The meaning is not directly specified in ODF but by reference to §7.27.7 
of [XSL]. That is 
https://www.w3.org/TR/2001/REC-xsl-20011015/slice7.html#writing-mode


For rl-tb (RTL) XSL has: "Inline components and text within a line are 
written right-to-left. Lines and blocks are placed top-to-bottom."
For tb-rl (Asian, 'right-to-left (vertical)' in UI) XSL has: "Inline 
components and text within a line are written top-to-bottom. Lines and 
blocks are placed right-to-left."
And for use with tables it has: "Table-rows use the 
block-progression-direction as the row-stacking direction. The 
inline-progression-direction is used to determine the stacking direction 
for columns (and cell order within the row)."


If you take that literally, you would get a horizontal table on a 
vertical page, if the page is set to "right-to-left (vertical)" and the 
table to "right-to-left (RTL)".


But LibreOffice does not render it that way. Therefore my question 
whether the way LibreOffice renders it, is actually used. Or to be more 
specific: Do you use tables, were the origin of the table is 
bottom-right, the columns are stacked bottom-to-top and the rows are 
stacked from right-to-left?


Kind regards,
Regina













Hello Regina,

First, note that very few active RTL users are subscribed to the users' 
mailing list; at least - to my knowledge. For discussions of RTL 
considerations, it is often more useful to try:


irc://libera.chat/libreoffice-rtl
Telegram Group "LibreOffice RTL"
Matrix room https://matrix.to/#/#libreoffice-rtl:libera.chat

(these are now all bridged together.)

Second (and again not answering your questions...) let let me give some 
context info.


To the best om my understanding, the "RTL Vertical" and "LTR Vertical" 
exist to accommodate CJK scripts in which the glyphs appear in columns, 
and RTL/LTR is about the order of the columns of glyphs. i.e. the 
vertical axis is minor and the horizontal is major. I am not aware of 
proper-RTL scripts in which glyphs are written from top to bottom.


An exception could be those RTL scripts which have common non-connected 
forms (Hebrew, N'Ko, Mende), where some vertical billboards can in 
theory show one glyph after another in vertical order. This is extremely 
rare for the case of Hebrew, and will certainly not be used for anything 
that's multi-line. I don't know people from Western Africa, so in theory 
they could have that. In Arabic and related scripts I am assuming - 
based on some, but partial, knowledge - that this is considered irrelevant.


It is more common however - but still rare - for RTL text to be rotated, 
so that the glyphs progress horizontally in their own coordinate system, 
but vertically in the page's coordinate system. This is what you get if 
you set the Text Direction to "Right-to-Left (Vertical)" in LO Writer. I 
actually believe that this is an inappropriate state of affairs, because 
in CJK, the glyphs are _not_ rotated in Vertical text direction. I would 
have filed a bug about this, but actually I just tried this today for 
the first time, since the vertical text direction is not offered for RTL 
unless you also enable CJK languages...


Anyway, with this being the state of affairs, I do not even know how the 
ODF spec _expects_ Vertical LTR or RTL text to be rendered - if at all. 
If you can point us to what it says about this, perhaps I could fully 
answer.


I will say, though, that in principle there is no reason why a CJK 
vertical-direction page of text cannot have a table with Hebrew or 
Arabic text. For example, a public space sign in an Asian country's 
airport might have vertical-direction progression and a small 
translation table of terms containing RTL text.


But I don't think that the RTL'ness itself is the real issue here, 
because almost all of the problems such situations present would also 
face us with LTR text.


Eyal



Hi all,

I’m on working to specify the property “style:writing-mode” for ODF. 
That property is called “text direction” in the UI of LibreOffice.



A page in a text document has the setting “Text direction” in section 
“Paper Format” on tab “Page” of the “Page Style” dialog. Possible 
values are


Left-to-right (horizontal)
Right-to-left (horizontal)
Right-to-left (vertical)
Left-to-right (vertical)

A table has the setting “Text direction” in section “Properties” on 
tab “Table” in “Table Properties” dialog. Possible values are


Left-to-right (LTR)
Right-to-left (RTL)
Use superordinate object settings

[libreoffice-users] Re: Combining vertical text direction of page with ‘right-to-left’ text direction of a table

[Eyal Rozenberg]

Hello Regina,

First, note that very few active RTL users are subscribed to the users' 
mailing list; at least - to my knowledge. For discussions of RTL 
considerations, it is often more useful to try:


irc://libera.chat/libreoffice-rtl
Telegram Group "LibreOffice RTL"
Matrix room https://matrix.to/#/#libreoffice-rtl:libera.chat

(these are now all bridged together.)

Second (and again not answering your questions...) let let me give some 
context info.


To the best om my understanding, the "RTL Vertical" and "LTR Vertical" 
exist to accommodate CJK scripts in which the glyphs appear in columns, 
and RTL/LTR is about the order of the columns of glyphs. i.e. the 
vertical axis is minor and the horizontal is major. I am not aware of 
proper-RTL scripts in which glyphs are written from top to bottom.


An exception could be those RTL scripts which have common non-connected 
forms (Hebrew, N'Ko, Mende), where some vertical billboards can in 
theory show one glyph after another in vertical order. This is extremely 
rare for the case of Hebrew, and will certainly not be used for anything 
that's multi-line. I don't know people from Western Africa, so in theory 
they could have that. In Arabic and related scripts I am assuming - 
based on some, but partial, knowledge - that this is considered irrelevant.


It is more common however - but still rare - for RTL text to be rotated, 
so that the glyphs progress horizontally in their own coordinate system, 
but vertically in the page's coordinate system. This is what you get if 
you set the Text Direction to "Right-to-Left (Vertical)" in LO Writer. I 
actually believe that this is an inappropriate state of affairs, because 
in CJK, the glyphs are _not_ rotated in Vertical text direction. I would 
have filed a bug about this, but actually I just tried this today for 
the first time, since the vertical text direction is not offered for RTL 
unless you also enable CJK languages...


Anyway, with this being the state of affairs, I do not even know how the 
ODF spec _expects_ Vertical LTR or RTL text to be rendered - if at all. 
If you can point us to what it says about this, perhaps I could fully 
answer.


I will say, though, that in principle there is no reason why a CJK 
vertical-direction page of text cannot have a table with Hebrew or 
Arabic text. For example, a public space sign in an Asian country's 
airport might have vertical-direction progression and a small 
translation table of terms containing RTL text.


But I don't think that the RTL'ness itself is the real issue here, 
because almost all of the problems such situations present would also 
face us with LTR text.


Eyal



Hi all,

I’m on working to specify the property “style:writing-mode” for ODF. That 
property is called “text direction” in the UI of LibreOffice.


A page in a text document has the setting “Text direction” in section “Paper 
Format” on tab “Page” of the “Page Style” dialog. Possible values are

Left-to-right (horizontal)
Right-to-left (horizontal)
Right-to-left (vertical)
Left-to-right (vertical)

A table has the setting “Text direction” in section “Properties” on tab “Table” 
in “Table Properties” dialog. Possible values are

Left-to-right (LTR)
Right-to-left (RTL)
Use superordinate object settings

LibreOffice can combine a vertical text direction at the page with RTL text 
direction of the table.


Are such combinations actually used in documents?
Does LibreOffice render the texts in the way users need it?
What is the intended behavior of such combinations?

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

[libreoffice-users] Re: Combining vertical text direction of page with ‘right-to-left’ text direction of a table

[Battsengel Ichinnorov (Bachka)]

Dear Regina,

thank you very much that you still remembering our talk at German 
Community Meeting.


- Yes, we need it in Mongolian old script. These information was for me 
very useful for Mongolian old script, which uses top-to-down with 
left-to-right.


I mean like in your example document "Page mongolianVert Table RTL.odt". 
I will test it later the full functionality of this settings and respond 
you back.


- Yes, for the second question too. Because our Cyrillic script uses 
normal left-to-right with top-to-down. I think both scripts in one 
document combined are at the moment usual usage.


- For other questions i need more tests to answer those.

Best regards

Bachka

PS: I have at moment less time for testing (Mother in my House from 
Mongolia for 2 months, :D), sorry. but it has piqued my interest and 
motivates me to do more, ;). Thank you for your effort!


Battsengel Ichinnorov
--
Web: https://tsengel.de

On 10.04.23 18:38, Regina Henschel wrote:

Hi all,

I’m on working to specify the property “style:writing-mode” for ODF. 
That property is called “text direction” in the UI of LibreOffice.


A page in a text document has the setting “Text direction” in section 
“Paper Format” on tab “Page” of the “Page Style” dialog. Possible 
values are

Left-to-right (horizontal)
Right-to-left (horizontal)
Right-to-left (vertical)
Left-to-right (vertical)

A table has the setting “Text direction” in section “Properties” on 
tab “Table” in “Table Properties” dialog. Possible values are

Left-to-right (LTR)
Right-to-left (RTL)
Use superordinate object settings

LibreOffice can combine a vertical text direction at the page with RTL 
text direction of the table.


Are such combinations actually used in documents?
Does LibreOffice render the texts in the way users need it?
What is the intended behavior of such combinations?

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

[libreoffice-users] Re: Opening new file from same path as current open document

[Mike Flannigan]

/
//I am using LibreOffice 7.3.5.2 on Windows 11./
I am using 6.4.7.2 on Linux Mint.

/I often have several LO files open at once./
Me too.

/I find that, when I click to open another file, the “open file dialog” 
defaults to the path of the most recent file I opened, even if I am no 
longer working on that file and may have closed it./

Me too.
/
//What I would prefer is to have the “open file dialog” default to the 
path of the LO document that is in the active window on which I am 
currently working./

Me too.

/Is there any way to accomplish this?/
I don't think so.  At least not simply.  I am not sure if it
is due to LO or the windows manager program, but probably
LO since it happens on both windows and Linux.


Mike


On 3/4/23 14:05, users+h...@global.libreoffice.org wrote:

I am using LibreOffice 7.3.5.2 on Windows 11.

I often have several LO files open at once. I may have a Calc spreadsheet open, 
an Impress slide presentation, and one or more Writer documents, all open at 
the same time as I bounce back and forth between files.

I find that, when I click to open another file, the “open file dialog” defaults 
to the path of the most recent file I opened, even if I am no longer working on 
that file and may have closed it.

What I would prefer is to have the “open file dialog” default to the path of 
the LO document that is in the active window on which I am currently working. 
Is there any way to accomplish this?

Virgil



--
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] Re: LibreOffice parent company

[Amn Ojee Uw]

Thanks folks!
I got it now.

On 2023-02-18 7:36 a.m., Amn Ojee Uw wrote:

New comer here!
What is the parent company of LibreOffice? Apache?


--
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] Re: Removal of Previously Marked Page Breaks

[Vince@Verizon]

I have found a solution to my problem.

To reset/remove all existing manual page breaks within a .ods file:

 * use View > Page Break,
 * hover mouse cursor somewhere within the displayed Page 1 area,
 * right click on the mouse,
 * select  Delete Page Breaks.

This effectively resets the .ods file to default without manual manual 
page breaks. The print output will flow onto pages that are consistent 
in area size, which is what I needed.


I must remember in the future that there is no button involved, but 
rather a requirement of mouse pointer position and a right-click on the 
mouse device.





--
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] Re: Removal of Previously Marked Page Breaks

[Vince@Verizon]

Edited:

On 1/20/2023 3:33 PM, Vince@Verizon wrote:

LibreOffice 7.3.2.2 (x64) Calc spreadsheet on Win10 desktop

--
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] Re: Threading [was: Header beginning on page 2?]

[John Kaufmann]

And yet... this time your reply (containing *both* In-reply-to and References 
headers, for the first time) threaded! Be it ever so curious, I withdraw my 
question. Thanks for satisfying my curiosity.

BTW, my prior post used Reply-All (rather than Reply-List) because I was not 
sure about how you were receiving. Now that I see Reply-List works for you, 
that [my norm on this list] is what I'm using - so you won't see double ;-)

On 2022-11-29 23:58, RealNameTBA wrote:

Truly don't know. It's never been an issue. And for a long time now replyto: 
has had issues such that I considered its use to be bad practice -- indeed, it 
screws up many mailing lists. (For example, this is the one list I'm on that 
seems to reply to both the original poster and to the list, resulting in 
duplicates. There may be sound reasons for this, but elsewhere it's been seen 
as a misconfiguration and has been eradicated almost immediately.) Not 
complaining, just explaining why my mailer is configured as it is.

On Tue, Nov 29, 2022 at 11:51 PM, John Kaufmann  wrote:


Dear RealNameTBA-as an aside to questions about LO operation: One can't help 
notice that none of your posts are threaded (because of the absence of 
In-reply-to and References headers). Does ProtonMail not support (a) 
Reply-to-List and (b) threading generally?


--
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] Re: Threading [was: Header beginning on page 2?]

[RealNameTBA]

Truly don't know. It's never been an issue. And for a long time now replyto: 
has had issues such that I considered its use to be bad practice -- indeed, it 
screws up many mailing lists. (For example, this is the one list I'm on that 
seems to reply to both the original poster and to the list, resulting in 
duplicates. There may be sound reasons for this, but elsewhere it's been seen 
as a misconfiguration and has been eradicated almost immediately.) Not 
complaining, just explaining why my mailer is configured as it is.

On Tue, Nov 29, 2022 at 11:51 PM, John Kaufmann  wrote:

> Dear RealNameTBA-as an aside to questions about LO operation: One can't help 
> notice that none of your posts are threaded (because of the absence of 
> In-reply-to and References headers). Does ProtonMail not support (a) 
> Reply-to-List and (b) threading generally?
-- 
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] Re: Explanation of Formula that was used in Excel

[Vince@Verizon]

On 10/30/2022 12:37 PM, Vince@Verizon wrote:


Hi:

Version: 7.3.2.2 (x64) / LibreOffice Community
Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; 
VCL: win

Locale: en-US (en_US); UI: en-US
Calc: CL

I am attempting to understand a formula that was suggested for use 
within MSExcel2016 so I might us it within LibreOffice Calc.


The formula is:

=INDEX(IF(INDEX(A:A,LARGE(IF($A$4:$B$43=$G$2,ROW($A$4:$A$43),""),ROW(1:1)))=$G$2,E:E,F:F),LARGE(IF($A$4:$B43=$G$2,ROW($A$4:$A$43),""),ROW(1:1))). 



When I copy/paste this formula first into Notepad and then copy/paste 
from Notepad into a LO Calc spreadsheet, a  #VALUE!  error is returned.


I have not ever used e.g., INDEX(A:A) nor ROW(1:1) as a range 
identifier/specifier within a formula, so I wonder if they are 
acceptable within LO Calc, or is that causing the error,  #VALUE! ?  I 
believe those identify/specify the entire [A] column and the entire 
[1] row; is there an equivalent within LO Calc.


Once the error is cleared then I will continue to attempt to 
understand what the formula is calculating/doing within LO Calc. I can 
see that it is evaluating the data within cell $G$2, the LARGEST value 
within A:A, within E:E, and within F:F; but not much else is making 
any sense for me to understand. A simplified example would be 
appreciated here.


Thanks for reading about my problem and for your comments/reply.


VinceB.




Update:

Here is a link to the original MSExcel spreadsheet, the OP posted at the 
Excel Forum; the OP was seeking "Best formula to lookup most recent and 
second most recent result from list of data" on 01-04-2016, 02:50 AM:


https://www.excelforum.com/attachments/excel-general/438242d1451890188-best-formula-to-lookup-most-recent-and-second-most-recent-result-from-list-of-data-lookup-formula.xlsx

__


Unfortunately, I do not understand the significance of:  ROW(1:1) within 
the original formula.


Error #519 says in part,


The formula yields a value that does not correspond to the definition;
Or a cell that is referenced in the formula contains text instead of a 
number.


No result (#VALUE is in the cell rather than Err:519!)





and it is true that columns H:J for row1 contain text strings, not 
numerical data.


I am still at a loss of understanding .








--
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] Re: Debian Suicide Team, Elio Qoshi (Ubuntu, Fedora Ambassador) underage girlfriend

[Wade Smart]

I have no idea who that is.
That is completely off topic.

-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Mon, Jul 11, 2022 at 11:50 AM Anja Xhakani  wrote:
>
> In memory of Ian Murdock we are creating the Debian Suicide Team
>
> People are dying to join us
>
> Full members are Ian Murdock and Frans Pop
>
> Apprentices are Lucy Wayland, Thiemo Seufer and Molly de Blanc. Molly has 
> bipolar so she will join us sooner or later.
>
> This is the only team where Molly de Blanc can't expel you
>
> I am the Ubuntu underage girl
>
> I started dating the Fedora ambassador Elio Qoshi in Albania when I was 16.  
> He brought me to the OSCAL conference sponsored by Red Hat.
>
> Elio had to resign as a Fedora ambassador but he had no problems getting a 
> new job at Ubuntu
>
> When he started paying me to be the 17 year old sysadmin, this wasn't a 
> payment for sex
>
> Chris Lamb started spreading gossip about abuse because he wanted an Albanian 
> girlfriend too
>
>
>
>
> --
> ubuntu-users mailing list
> ubuntu-us...@lists.ubuntu.com
> Modify settings or unsubscribe at: 
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-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] Re: Adding Videos to Impress Presentation Not Possible

[John Iliffe]

I have no experience with this problem but the error "Permission to ..."
suggests that the system is blocking things.  Is the permission for the file
executable?  Reason I ask is that there must be some sort of a driver to play
the file.  Read permission would probably let you load it and look at the first
frame.

Good luck!

John
=
On Sat, 2022-05-07 at 06:45 -0500, Mike Flannigan wrote:
> With mine I need to do Insert - Audio or Video.
> Then it places the video on the slide, but I have no way to play it.
> http://www.mflan.com/temp/vid.png
> 
> So inserting an image works fine, but not a video.
> 
> 
> Mike
> 
> 
> On 5/6/22 23:08, users+h...@global.libreoffice.org wrote:
> > Subject:
> > [libreoffice-users] Adding Videos to Impress Presentation Not Possible
> > From:
> > 7mrbk...@duck.com
> > Date:
> > 5/6/22, 10:40
> > 
> > To:
> > users@global.libreoffice.org
> > 
> > 
> > Hi everyone!
> > 
> > I've migrated to Linux a couple months ago and have continued to enjoy 
> > Libre Office:)
> > 
> > However, I can't figure out why Impress won't let me add videos to my 
> > presentation. I couldn't find a solution to the problem by looking it up.
> > 
> > Here's what happens:
> > I go to slide where I want the video to appear in
> > Select Insert
> > Select Video
> > [File Navigator opens] I navigate to the video file and select Open
> > Nothing happens, not even an error message is displayed:(
> > What I've tried to fix it:
> > Drag-and-drop
> > Dropping a .mp4 file into the slide displays a square with a music note in 
> > it, not the actual video. Nothing happens when starting the 
> > presentation.Create OLE object from file
> > After selecting the video file, two error messages appear (finally!)
> > "Permission to [path of file] denied"
> > This confuses me, because inserting images, for example, works just fine 
> > (also true for images located in the same folder where the videos are 
> > located)
> > "Object from file [path of file] couldn't be inserted"The folder I'm using 
> > is actually a syslink, so I tried copying the video file to my desktop 
> > first and then inserting it into the presentation
> > Different file formats (mp4, m4v, webm)
> > Inserting GIFs results in only one frame of them being shown (nothing 
> > happens when starting the presentation either), although I'm not sure if 
> > Impress has the capability to display GIFs.
> > I'm running...- Linux Mint 20.3 (with Cinnamon 5.2.7)
> > - Linux Kernel: 5.4.0-109-generic
> > 
> > Thank you for trying to help!
> 
> 


-- 
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] Re: Adding Videos to Impress Presentation Not Possible

[Mike Flannigan]

With mine I need to do Insert - Audio or Video.
Then it places the video on the slide, but I have no way to play it.
http://www.mflan.com/temp/vid.png

So inserting an image works fine, but not a video.


Mike


On 5/6/22 23:08, users+h...@global.libreoffice.org wrote:

Subject:
[libreoffice-users] Adding Videos to Impress Presentation Not Possible
From:
7mrbk...@duck.com
Date:
5/6/22, 10:40

To:
users@global.libreoffice.org


Hi everyone!

I've migrated to Linux a couple months ago and have continued to enjoy Libre 
Office:)

However, I can't figure out why Impress won't let me add videos to my 
presentation. I couldn't find a solution to the problem by looking it up.

Here's what happens:
I go to slide where I want the video to appear in
Select Insert
Select Video
[File Navigator opens] I navigate to the video file and select Open
Nothing happens, not even an error message is displayed:(
What I've tried to fix it:
Drag-and-drop
Dropping a .mp4 file into the slide displays a square with a music note in it, 
not the actual video. Nothing happens when starting the presentation.Create OLE 
object from file
After selecting the video file, two error messages appear (finally!)
"Permission to [path of file] denied"
This confuses me, because inserting images, for example, works just fine (also 
true for images located in the same folder where the videos are located)
"Object from file [path of file] couldn't be inserted"The folder I'm using is 
actually a syslink, so I tried copying the video file to my desktop first and then 
inserting it into the presentation
Different file formats (mp4, m4v, webm)
Inserting GIFs results in only one frame of them being shown (nothing happens 
when starting the presentation either), although I'm not sure if Impress has 
the capability to display GIFs.
I'm running...- Linux Mint 20.3 (with Cinnamon 5.2.7)
- Linux Kernel: 5.4.0-109-generic

Thank you for trying to help!



--
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] Re: LibreOffice Impress sounds or music

[Michael Powell]

> > Hello,
> >
> > This probably answers the question, which seems a bit limited to me,
but whatever.
> >
> > "When you show an Impress presentation, the embedded sound or video on
the
> > current slide plays automatically until it's over or until you leave the
> > slide."
> >
> > I'm sure this has probably been asked before, I would like to extend the
> > playback of a track over several slides, loop if necessary, and such as
> > this, if possible. Is any of that possible, or do I have to consider a
more
> > elaborate approach, like a Blender 'slide show' rendering, or similar
> > approach?
>
> In the /Slide transitions pane/ in the /Modify Transition area/:
>
> Add some music or whatever to the first slide.
>
> Set Sound to "No sound" for the next slide(s).
>
> The sound you selected for the first slide will play until it is ended
> or until you add a new sound track.

Does not work; which per the documentation 'makes sense'. 'No sound' is the
choice on the second slide, but the music cuts off. But my goal of the
music spanning slides, does not seem that doable.

Which is fine.

Looks like my options are to dive into Blender for what I want to
accomplish.

Cheers,

Michael

-- 
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] Re: Script to parse spreadsheet and send to own database as CSV or JSON

[Andrew Pitonyak]

I cannot comment on things that are online, but I believe that you can automate 
LibreOffice using Python; even though I have never done it. Well I guess I 
don't remember if I've done it or not and done a lot of things I don't remember 
just a long time ago. Most of the automation I have done is been in basic.

⁣Get BlueMail for Android ​

On Apr 20, 2022, 12:58 PM, at 12:58 PM, Albin  wrote:
>Hello,
>
>Just wondering if you've received this question?
>
>Respectfully,
>
>-albin
>___
>Digital Wizard | NeuroLeap Corp | San Jose, CA, USA
>*Special Power for Special Children!*
>The content of this email is confidential and intended for the
>recipient
>specified in message only. It is strictly forbidden to share any part
>of
>this message with any third party, without a written consent of the
>sender.
>If you received this message by mistake, please reply to this message
>and
>follow with its deletion, so that we can ensure such a mistake does not
>occur in the future.
>
>
>On Fri, Apr 15, 2022 at 10:51 PM Albin  wrote:
>
>> Hello,
>>
>> We have spreadsheets filled out by our psychologists and other
>> specialists, which are periodically (in the background) parsed and
>sent to
>> a database on our servers.
>> Currently, we are using Google Sheets and Google Cloud, however, we
>need
>> to migrate to another solution. Since we have no profits and no
>budget to
>> buy anything, I was wondering if we could accomplish the parsing via
>> scripts (preferably using Python) using LibreOffice Calc Online?
>>
>> Thank you.
>>
>> Respectfully,
>>
>> -albin
>> ___
>> Digital Wizard | NeuroLeap Corp | San Jose, CA, USA
>> *Special Power for Special Children!*
>> The content of this email is confidential and intended for the
>recipient
>> specified in message only. It is strictly forbidden to share any part
>of
>> this message with any third party, without a written consent of the
>sender.
>> If you received this message by mistake, please reply to this message
>and
>> follow with its deletion, so that we can ensure such a mistake does
>not
>> occur in the future.
>>
>
>-- 
>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] Re: Script to parse spreadsheet and send to own database as CSV or JSON

[Albin]

Hello,

Just wondering if you've received this question?

Respectfully,

-albin
___
Digital Wizard | NeuroLeap Corp | San Jose, CA, USA
*Special Power for Special Children!*
The content of this email is confidential and intended for the recipient
specified in message only. It is strictly forbidden to share any part of
this message with any third party, without a written consent of the sender.
If you received this message by mistake, please reply to this message and
follow with its deletion, so that we can ensure such a mistake does not
occur in the future.


On Fri, Apr 15, 2022 at 10:51 PM Albin  wrote:

> Hello,
>
> We have spreadsheets filled out by our psychologists and other
> specialists, which are periodically (in the background) parsed and sent to
> a database on our servers.
> Currently, we are using Google Sheets and Google Cloud, however, we need
> to migrate to another solution. Since we have no profits and no budget to
> buy anything, I was wondering if we could accomplish the parsing via
> scripts (preferably using Python) using LibreOffice Calc Online?
>
> Thank you.
>
> Respectfully,
>
> -albin
> ___
> Digital Wizard | NeuroLeap Corp | San Jose, CA, USA
> *Special Power for Special Children!*
> The content of this email is confidential and intended for the recipient
> specified in message only. It is strictly forbidden to share any part of
> this message with any third party, without a written consent of the sender.
> If you received this message by mistake, please reply to this message and
> follow with its deletion, so that we can ensure such a mistake does not
> occur in the future.
>

-- 
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] Re: LibreOffice Impress sounds or music

[Kolbjørn Stuestøl]

Den 20.04.2022 13:06, skreiv Michael Powell:

Hello,

This probably answers the question, which seems a bit limited to me, but
whatever.

"When you show an Impress presentation, the embedded sound or video on the
current slide plays automatically until it's over or until you leave the
slide."

I'm sure this has probably been asked before, I would like to extend the
playback of a track over several slides, loop if necessary, and such as
this, if possible. Is any of that possible, or do I have to consider a more
elaborate approach, like a Blender 'slide show' rendering, or similar
approach?


In the /Slide transitions pane/ in the /Modify Transition area/:

Add some music or whatever to the first slide.

Set Sound to "No sound" for the next slide(s).

The sound you selected for the first slide will play until it is ended 
or until you add a new sound track.


I thought "Repeat until next sound" would loop, but it does not. I have 
no idea of what it does.


I'm using version 7.2.5.2 on Windows 10.

Kolbjørn



Thanks!

Cheers,

Michael

https://help.libreoffice.org/Common/Movie_and_Sound


--
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] Re: LibreOffice Impress sounds or music

[Michael Powell]

Hello,

This probably answers the question, which seems a bit limited to me, but
whatever.

"When you show an Impress presentation, the embedded sound or video on the
current slide plays automatically until it's over or until you leave the
slide."

I'm sure this has probably been asked before, I would like to extend the
playback of a track over several slides, loop if necessary, and such as
this, if possible. Is any of that possible, or do I have to consider a more
elaborate approach, like a Blender 'slide show' rendering, or similar
approach?

Thanks!

Cheers,

Michael

https://help.libreoffice.org/Common/Movie_and_Sound

-- 
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] Re: [EXTERNAL] Special Character - checkmark

[V Stuart Foote]

Charles,

Well you could try the Unicode combining glyphs -- U+035F COMBINING DOUBLE 
MACRON BELOW

Enter "U+0059U+035fU+006fU+035fU+0075U+035fU+0072" and then toggle with 
+X, effectiveness will vary by font.

Alternatively, LO provides an artificial underline effect from the 'Format 
Chracter' dialog (Format -> Character on main menu) on the 'Font Effects' tab: 
Underlining decoration.




-- 
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] RE: LibreOffice to LyX

[Virgil Arrington]

I don’t know your particular situation, but it seems to me that most common 
whack-a-mole problems come from mixing formatting-by-styles and direct 
formatting. This is especially common in collaborated documents. One co-author 
works with styles and the other works with direct formatting, which creates a 
hot mess.

I have never had a problem with LO when I have controlled the formatting. I use 
my own styles that I have created and everything works smoothly. But if someone 
else touches my work and starts inserting direct formatting, then it’s 
whack-a-mole time. I don’t fault the program for this, whether its LO Writer or 
MS Word.

I recall years ago, another FOSS program, AbiWord had a feature called “lock 
styles,” which prevented direct formatting. I haven’t looked at AbiWord in 
years so I don’t know if it is still there. I can only imagine the average user 
being frustrated by being locked out of direct formatting, which highlights an 
inherent problem with programs like LO and Word.

They work best when used with styles, yet I dare say most users don’t want to 
take the time to learn how to use styles. I tried in vain to teach styles to my 
secretary and she couldn’t be bothered. She complained that, while I was 
spending time creating and editing styles, she was actually getting work done. 
I could never persuade her that, once learned, styles make things so much 
faster and easier. I suspect that her attitude is more prevalent than LO’s 
developers would like to admit. Hence…

Whack-a-mole!!

Virgil

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows


From: Mike Flannigan 
Sent: Tuesday, October 5, 2021 8:27:37 AM
To: users@global.libreoffice.org 
Subject: Re: [libreoffice-users] RE: LibreOffice to LyX


I haven't dealt with long wordprocessing documents on LO,
but I have in MSWord.  And I have seen the exact same
whack-a-mole behavior.  Going through the whole document
and explicitly setting each section font size and style.
Numbered lists seem to cause the most problems.


Mike


On 10/4/21 5:06 PM, users+h...@global.libreoffice.org wrote:
> On October 3, Steve Litt<mailto:sl...@troubleshooters.com>  (on the LyX User 
> List) wrote:
>
>> Several times, on long wordprocessing documents, I personally have had
>> LibreOffice writer styles spontaneously change. At one point my
>> personal problem with LibreOffice style prevented me from converting a
>> 300 page doc made in MS Word to LibreOffice. The import went just fine,
>> but the styles kept changing, and keeping them all intact was like
>> playing whack-a-mole.


--
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] RE: LibreOffice to LyX

[Mike Flannigan]

I haven't dealt with long wordprocessing documents on LO,
but I have in MSWord.  And I have seen the exact same
whack-a-mole behavior.  Going through the whole document
and explicitly setting each section font size and style.
Numbered lists seem to cause the most problems.


Mike


On 10/4/21 5:06 PM, users+h...@global.libreoffice.org wrote:

On October 3, Steve Litt  (on the LyX User 
List) wrote:


Several times, on long wordprocessing documents, I personally have had
LibreOffice writer styles spontaneously change. At one point my
personal problem with LibreOffice style prevented me from converting a
300 page doc made in MS Word to LibreOffice. The import went just fine,
but the styles kept changing, and keeping them all intact was like
playing whack-a-mole.



--
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] Re: LibreOffice to LyX

[Scott Kostyshak]

On Mon, Oct 04, 2021 at 12:55:34PM +, Virgil Arrington wrote:
> On October 3, Steve Litt (on the LyX User 
> List) wrote:
> 
> > Several times, on long wordprocessing documents, I personally have had
> > LibreOffice writer styles spontaneously change. At one point my
> > personal problem with LibreOffice style prevented me from converting a
> > 300 page doc made in MS Word to LibreOffice. The import went just fine,
> > but the styles kept changing, and keeping them all intact was like
> > playing whack-a-mole.
> 
> > I had an even worse personal failure involving changing styles in
> > LibreOffice's Impress, which contained the 90+ slide presentation I
> > license to companies for their internal Universal Troubleshooting
> > Process course, that now I need to rewrite the entire thing in Beamer.
> 
> At the risk of joining in a flame war, I feel a need to share my experiences 
> with LyX and LibreOffice. As I am on both LyX’s and LibreOffice’s user lists, 
> I am posting this message to both lists.
> 
> I have used both LyX and LibreOffice for decades, the former going back to 
> version 1.4 and the latter going back to its origins as StarOffice and later 
> as OpenOffice.org. Over the years I have found myself having a love/hate 
> relationship with both. I have had to learn that each has its own way of 
> working, and when I try to make either work like the other, I run into 
> problems.
> 
> My current work is primarily with slide presentations, and I bounce back and 
> forth between LyX/Beamer and LO Impress (as well as 
> RMarkdown/Slidy/Ioslides). I have found that with LyX, I can very happily 
> change formatting after composing my content and, so long as I am satisfied 
> with Beamer’s slide designs and themes, it works very well. But, I usually 
> find myself getting very frustrated when I want to change some design detail. 
> It often requires a Google search to learn the right LaTeX command to achieve 
> the change I want. After spending hours trying to achieve a certain result 
> and editing preamble and/or LaTeX code, I often find I just give up and move 
> it all to LO Impress just to get the job done.
> 
> On the flip side, I have had to learn that LO Impress doesn’t like having 
> slide formats changed *after* the presentation substance has been composed. 
> While my styles haven’t suddenly changed on me, I have learned that changes 
> made to Impress master slides do not always get to all slides in a 
> presentation. Through painful experience, I have learned that, if I ever make 
> any direct changes to a particular slide’s format, it seems to disassociate 
> that slide from the master slide. So, after hours of composing and wrestling 
> with Impress’s master slides trying to get it all to behave, I find I often 
> just give up and move it all to LyX/Beamer just to get the job done.
> 
> And in those cases where my slide design needs are particularly simple, I run 
> to Rstudio and Slidy to create a quick and dirty (and well behaved) slide 
> presentation.
> 
> And, so I bounce back and forth between the programs using the one that will 
> let me get the job done efficiently. I find they all require considerable 
> commitment of time and effort to achieve the desired results. Each has some 
> feature I find maddening and each has some feature I find indispensable. In 
> short, despite my obsessive search for the perfect document processing 
> system, I have learned it doesn’t exist. I will continue to use whatever tool 
> best meets the need at hand. Sometimes it’s LyX, sometimes it’s LibreOffice 
> and sometimes it’s
> RMarkdown.

Thanks for this helpful comparison, Virgil! It was interesting for me to read 
about your experience and workflow.

I'm happy to have both LyX and LO and I'm very thankful to all of the 
developers giving their free time for these open source programs!

Scott

-- 
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] RE: LibreOffice to LyX

[Virgil Arrington]

On October 3, Steve Litt (on the LyX User 
List) wrote:

> Several times, on long wordprocessing documents, I personally have had
> LibreOffice writer styles spontaneously change. At one point my
> personal problem with LibreOffice style prevented me from converting a
> 300 page doc made in MS Word to LibreOffice. The import went just fine,
> but the styles kept changing, and keeping them all intact was like
> playing whack-a-mole.

> I had an even worse personal failure involving changing styles in
> LibreOffice's Impress, which contained the 90+ slide presentation I
> license to companies for their internal Universal Troubleshooting
> Process course, that now I need to rewrite the entire thing in Beamer.

At the risk of joining in a flame war, I feel a need to share my experiences 
with LyX and LibreOffice. As I am on both LyX’s and LibreOffice’s user lists, I 
am posting this message to both lists.

I have used both LyX and LibreOffice for decades, the former going back to 
version 1.4 and the latter going back to its origins as StarOffice and later as 
OpenOffice.org. Over the years I have found myself having a love/hate 
relationship with both. I have had to learn that each has its own way of 
working, and when I try to make either work like the other, I run into problems.

My current work is primarily with slide presentations, and I bounce back and 
forth between LyX/Beamer and LO Impress (as well as RMarkdown/Slidy/Ioslides). 
I have found that with LyX, I can very happily change formatting after 
composing my content and, so long as I am satisfied with Beamer’s slide designs 
and themes, it works very well. But, I usually find myself getting very 
frustrated when I want to change some design detail. It often requires a Google 
search to learn the right LaTeX command to achieve the change I want. After 
spending hours trying to achieve a certain result and editing preamble and/or 
LaTeX code, I often find I just give up and move it all to LO Impress just to 
get the job done.

On the flip side, I have had to learn that LO Impress doesn’t like having slide 
formats changed *after* the presentation substance has been composed. While my 
styles haven’t suddenly changed on me, I have learned that changes made to 
Impress master slides do not always get to all slides in a presentation. 
Through painful experience, I have learned that, if I ever make any direct 
changes to a particular slide’s format, it seems to disassociate that slide 
from the master slide. So, after hours of composing and wrestling with 
Impress’s master slides trying to get it all to behave, I find I often just 
give up and move it all to LyX/Beamer just to get the job done.

And in those cases where my slide design needs are particularly simple, I run 
to Rstudio and Slidy to create a quick and dirty (and well behaved) slide 
presentation.

And, so I bounce back and forth between the programs using the one that will 
let me get the job done efficiently. I find they all require considerable 
commitment of time and effort to achieve the desired results. Each has some 
feature I find maddening and each has some feature I find indispensable. In 
short, despite my obsessive search for the perfect document processing system, 
I have learned it doesn’t exist. I will continue to use whatever tool best 
meets the need at hand. Sometimes it’s LyX, sometimes it’s LibreOffice and 
sometimes it’s
RMarkdown.

Virgil

-- 
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] Re: Default file name for Export Directly as PDF is now blank.

[Steve Edmonds]

I think I have this worked out.
If the PDF exists already the Name field is blank.
If the PDF doesn't exist the Name field is filled with the name of the file.

The older files that were working before saving (as .odt) were .sxw.
It would save time hunting down the PDF file to overwrite and avoid a 
mistake of overwriting a wrong file if the Name field was filled by default.


Steve

On 31/08/2021 09:59, Steve Edmonds wrote:

Hi.
For a while now I have noticed when I Export Directly as PDF from 
writer (7.1.5.2) the Name field for the file in the file dialogue is 
blank when once it defaulted to the odt file name but with a pdf 
extension.


I have just been updating some older documents and with these, as long 
as I have not saved them, Export Directly as PDF has the Name field 
pre-filled with the file name. As soon as I save the odt file the Name 
field is no longer pre-filled.


I thought may be this was some setting in LO options but it seems 
document specific.


Should the Name field in file dialogue to Export Directly as PDF be 
prefilled with the file name or is this discontinued, if it should be 
how do I get this to happen.


TIA steve



--
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] Re: Multi-column Format

[John Kaufmann]

Dave,

On 16-Feb-2021 you started a thread ["How to ask a question on Ask 
LibreOffice?"] in this forum mentioning that you also [like Rob now] have a problem 
with the Ask system, and so tend to use this list instead -- which is fine: as noted in 
an earlier thread, Ask and this list are alternative communities to get help, and should 
serve the same purpose. But, as Sophi noted in reply to you, TDF hopes to combine those 
communities (web and mailing list) with an implementation of Discourse (which would also 
eliminate nabble, which existed mostly as an archive for this list).

So far, the plan has only been executed as far as eliminating nabble; Ask and 
this list are still both alive and not combined, so Rob can subscribe here (as 
an alternative to ask.libreoffice.org) to ask questions, and keep an open (and 
patient) mind about whatever succeeds this list.

Meanwhile, to answer Rob's question: This sounds like what is usually called "n-up 
printing" (with, in Rob's case, n=2) or "combination printing" -- that is, putting n 
(2 or more) pages on a sheet, where a sheet is one side of a piece of paper.  As such, that is 
usually a function of the printer driver.

If I have misunderstood the issue, maybe Rob can reply to the list?

John


On 2021-08-08 13:40, Dave Barton wrote:

I don't know the answer to Rob's question.

Can someone on this list offer any suggestions?

Please cc Rob in any reply.

Thanks & Regards
Dave

 Original Message 
From: Rob MM [mailto:robm...@hotmail.com]
Sent: Friday, August 6, 2021, 18:06 UTC
To: Dave Barton
Subject: Multi-column Format


I can't make Ask.LibreOffice work so I'm sending this to you.  Thank
you for your past support.

How can I make a four-column spread sheet print in two parts, side by
side?  I am currently cutting the last half of the spread-sheet and
pasting it into the columns to the right of the original sheet.

I used to do this in Excell but can't find any information about it in
Libre.



--
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] Re: Multi-column Format

[Dave Barton]

I don't know the answer to Rob's question.

Can someone on this list offer any suggestions?

Please cc Rob in any reply.

Thanks & Regards
Dave

 Original Message 
From: Rob MM [mailto:robm...@hotmail.com]
Sent: Friday, August 6, 2021, 18:06 UTC
To: Dave Barton
Subject: Multi-column Format

> I can't make Ask.LibreOffice work so I'm sending this to you.  Thank
> you for your past support.
> 
> How can I make a four-column spread sheet print in two parts, side by
> side?  I am currently cutting the last half of the spread-sheet and
> pasting it into the columns to the right of the original sheet.
> 
> I used to do this in Excell but can't find any information about it in
> Libre.


-- 
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] Re: Adapting row height is slow

[Mike Flannigan]

Thank you.  I'll check this out when I get home.


Mike


On 8/1/21 3:06 PM, users+h...@global.libreoffice.org wrote:

As the sheet opens on the status bar at bottom of the Calc UI, a 
"Loading document" and progress bar appears, followed by the "Adapting 
row height" and its progress bar--when applicable to the spreadsheet.

Appearance is timer based, so high row counts and formatting being applied for 
large sheets trigger appearance of the progress bar. It often won't show for 
short sheets.

There is no manual control, nor other way to observe sheet loading directly.


From: Mike Flannigan
Sent: Sunday, August 1, 2021 6:42 AM


How do you view the progress and activities during the
opening of a large file?



--
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: [EXTERNAL] [libreoffice-users] Re: Adapting row height is slow

[V Stuart Foote]

As the sheet opens on the status bar at bottom of the Calc UI, a "Loading 
document" and progress bar appears, followed by the "Adapting row height" and 
its progress bar--when applicable to the spreadsheet.

Appearance is timer based, so high row counts and formatting being applied for 
large sheets trigger appearance of the progress bar. It often won't show for 
short sheets.

There is no manual control, nor other way to observe sheet loading directly.


From: Mike Flannigan
Sent: Sunday, August 1, 2021 6:42 AM


How do you view the progress and activities during the
opening of a large file?



-- 
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] Re: Adapting row height is slow

[Mike Flannigan]

How do you view the progress and activities during the
opening of a large file?


Mike

On 7/30/21 11:05 AM, users+h...@global.libreoffice.org wrote:
When loading and, sometimes, editing it appears to take longer 
"Adapting row height" than the rest of the processing put together.



--
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] Re: Strange new behavior in LO Calc

[MR ZenWiz]

Further update:

I happened to copy my MFU spreadsheet to my laptop, which is running LO 7.0.4.2.

The problem I'm seeing in 7.2.0 of not remembering previous column
entries and supplying the last one (or earliest one - can't remember
which) as the default and fill-in option works fine in 7.0.4.2.

I think it may be a bug and I'll gather the necessary data and submit
a bug when I get a spare minute or fifteen...

Thanks.

On Wed, Jul 21, 2021 at 10:24 PM MR ZenWiz  wrote:
>
> Update:
>
> I noticed that some columns work this way just fine, but others do not.
>
> I checked the format of the cells in those columns and they are all the same.
>
> I don't get it.
>
> Mark
>
> On Tue, Jul 20, 2021 at 5:08 PM MR ZenWiz  wrote:
> >
> > I recently install LO version 7.2.0 on my Xubuntu 20.04.2 main
> > desktop, something I rarely do (install a .0 release).
> >
> > In Calc, where it used to recognize the beginning of a preceding value
> > higher up in the column to autofill it, now it simply does not.  At
> > all.
> >
> > Has anyone else seen this or is it a new feature?
> >
> > Most curious.
> >
> > Thanks.
> >
> > 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

[libreoffice-users] Re: Strange new behavior in LO Calc

[MR ZenWiz]

Update:

I noticed that some columns work this way just fine, but others do not.

I checked the format of the cells in those columns and they are all the same.

I don't get it.

Mark

On Tue, Jul 20, 2021 at 5:08 PM MR ZenWiz  wrote:
>
> I recently install LO version 7.2.0 on my Xubuntu 20.04.2 main
> desktop, something I rarely do (install a .0 release).
>
> In Calc, where it used to recognize the beginning of a preceding value
> higher up in the column to autofill it, now it simply does not.  At
> all.
>
> Has anyone else seen this or is it a new feature?
>
> Most curious.
>
> Thanks.
>
> 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

[libreoffice-users] Re: Where are my files?

[Dan Lewis]

   You sent this request to the wrong mailing list. It should have been 
to users@global.libreoffice.org. where general questions like yours are 
sent. You sent it to the mailing list for developers, the people who 
work on the code for LibreOffice. I have done so for you. How have you 
searched for these files, and do you know the names of them? Also, were 
you doing something in LibreOffice when it restarted? Have you used your 
operating system to search for the files, or did you just use 
LibreOffice? If you use windows, the files should be in your Document 
folder which is the default setting.


   For others on the mailing list: any replies you make to this 
question should include a CC to zhangyviv...@gmail.com as he is not 
likely yet subscribed to it.


  Dan

On 6/29/21 5:27 PM, Vivian Zhang wrote:

Hello.

LibreOffice restarted and now I can't find the files I have been 
working on for months now.


Very upsetting.

Not pleased.

Will be happy if you help me find my irreplaceable files.

Thank you.

___
LibreOffice mailing list
libreoff...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice


--
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] Re: Unformated text copy of Calc cells containing line breaks

[Patch]

In case anyone is wondering, I have posted a bug report for this

https://bugs.documentfoundation.org/show_bug.cgi?id=142561



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

[libreoffice-users] Re: Calc: Formatting cell with decimal point but no decimal digits

[Joel Roth]

On Mon, May 10, 2021 at 06:44:32AM -0500, Mike Flannigan wrote:
> 
> Type
> locale
> in a terminal.  What locale are you?
> I am 'en_US'.
> 
> This works for me:
> Type 123.45 in a cell
> Highlight the cell
> Format - Cells - 'Numbers' tab -
> Make 'Decimal places:' under Options zero (0).

Thanks for replying. I do this and get 123 displayed, but
not "123." with the decimal.
 
regards

> Mike
> 
> 
> 
> On 5/10/21 1:04 AM, users+h...@global.libreoffice.org wrote:
> > Hi list,
> > 
> > I'd like to input 123.45 and format it with a decimal point
> > but no decimal digits, in this example "123." . Previously I
> > used the formatting code #,##0"." but now it causes an input
> > of 123.45 to be received as 12,345, losing the decimal.
> > 
> > Any ideas?
> > 
> > Thanks in advance.
> 

-- 
Joel Roth

-- 
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] Re: Autocorrect Problem in Arch_Linux Versions of Libreoffice

[das]

I got a link here that thinks it is a problem in arch_linux kernel, not a
problem in libreoffice.

https://ask.libreoffice.org/en/question/293254/autocorrect-has-stopped-working/

-- 
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] Re: LO not finding my scanner

[insomniacno1]

I have been posting in this thread regarding my tests and tries to slve this:
https://github.com/Ordissimo/scangearmp2/issues/35
  

To cut it short, either it is how Libreoffice interacts with the canon_pixma
driver or it is the driver itself causing this problem.

Yester day I dicovered that although the snap of newer version of
Libreoffice can be installed on 16.04 from snap store, it doesn't mean
everything is working - in this case the discovery of my canon scanner.
Removing the snap version and using the latest version available for 16.04,
Libreoffice 6.2.8.2 - I can now get the scan dialog, and it can scan -
somewhat - because there are still a problem.

So I uninstalled and removed all Libreoffice from my system, by purging
everything and downloaded older versions in App images to see if the problem
were identical in all versions: 

LibreOffice-3.6.7.2.help-x86_64.AppImage
LibreOffice-4.4.7.2.help-x86_64.AppImage
LibreOffice-5.4.7-x86_64.AppImage
LibreOffice-6.0.0-x86_64.AppImage
LibreOffice-6.0.1-x86_64.AppImage
LibreOffice-6.2.6-x86_64.AppImage
LibreOffice-6.2.7-x86_64.AppImage
LibreOffice-6.2.8-x86_64.AppImage

and even tried 

LibreOffice-6.4.7-x86_64.AppImage


I tested them all, and the common thing is that in the scan dialog(not
showing on newer than 6.4.7 Version 7.0 Fresh App image doesn't even open up
on 16.04, snap 7.1.2.2 work but not scan dialog after selecting source),
when selecting the area to scan by mouse is not kept, it jumps back to
default after 1 second(right: 90mm bottom: 54mm), only when setting this
manually will it keep -  that is until you either chose Generate preview or
select to Scan, in both cases it jumps back to default again. 

Setting everything up and selecting Scan, ends up in it jumping back to
default just before exiting the Scan dialog, and only scanning right: 90mm
bottom: 54mm.

Extremely frustrating not to mention annoying!

Hope this will get things going in solving this problem, maybe the Document
Foundation could talk with the author of the driver?

With kind regards

Jan



--
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] Re: [libreoffice-users] cells don’t auto-wrap

[Eric Beversluis]

It seems I want to set “Optimal Row Height” as the default. I thought that’s 
what I had and for some reason certain rows or certain cells weren’t following 
that setting. If I have the trouble again, I’ll check if the affected cell has 
a different row height setting for some reason. If so, it sounds like Girvin’s 
trick is the easy solution.

Thanks.
Eric Beversluis
Short fiction at www.ericbeversluis.com

On April 6, 2021 at 16:20:46, Girvin Herr (ghe...@fastmail.com) wrote:
>  
> On 4/6/21 1:04 PM, Brian Barker wrote:
> > At 14:11 06/04/2021 -0400, Eric Beversluis wrote:
> >> I've got a spreadsheet with all cells formatted to auto-wrap, yet
> >> when I enter stuff into certain cells, it doesn't autowrap. And
> >> sometimes the cell just shows the last bit of what I've entered. When
> >> I right-click and check the cell, it does show it's set to auto-wrap.
> >
> > I think the answer may be simple: that you have set the row height for
> > the relevant cells to be insufficient to allow wrapping to happen. In
> > this case, the last line of wrapped text is indeed what will appear in
> > the cell. You need to tinker with row height to enable Calc to expand
> > the row sufficiently to accept all your text.
> >
> > I trust this helps.
> >
> > Brian Barker
> >
> >
> Double-click on the bottom line of the far left column (the row number
> column, not column "A") of the row needing enlargement. If you are on
> the line, the mouse pointer will change to the up-down arrow icon. Doing
> so should increase the row height to accommodate the text. (It will also
> decrease the row height if the text will allow it.)
>  
> Girvin
>  
> --
It seems I want to set “Optimal Row Height” as the default. I thought that’s 
what I had and for some reason certain rows or certain cells weren’t following 
that setting. If I have the trouble again, I’ll check if the affected cell has 
a different row height setting for some reason. If so, it sounds like Girvin’s 
trick is the easy solution.

Thanks.
Eric Beversluis
Short fiction at www.ericbeversluis.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

[libreoffice-users] Re: [libreoffice-users] cells don’t auto-wrap

[Girvin Herr]

On 4/6/21 1:04 PM, Brian Barker wrote:

At 14:11 06/04/2021 -0400, Eric Beversluis wrote:
I've got a spreadsheet with all cells formatted to auto-wrap, yet 
when I enter stuff into certain cells, it doesn't autowrap. And 
sometimes the cell just shows the last bit of what I've entered. When 
I right-click and check the cell, it does show it's set to auto-wrap.


I think the answer may be simple: that you have set the row height for 
the relevant cells to be insufficient to allow wrapping to happen. In 
this case, the last line of wrapped text is indeed what will appear in 
the cell. You need to tinker with row height to enable Calc to expand 
the row sufficiently to accept all your text.


I trust this helps.

Brian Barker


Double-click on the bottom line of the far left column (the row number 
column, not column "A") of the row needing enlargement. If you are on 
the line, the mouse pointer will change to the up-down arrow icon. Doing 
so should increase the row height to accommodate the text. (It will also 
decrease the row height if the text will allow it.)


Girvin



--
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] Re: LO not finding my scanner

[Dan Lewis]

   I also can scan something into Writer without any problem. I use 
7.1.2.1 at the present time using Ubuntu 20.04. This is on a notebook.


   My printer is connected through a network which also includes a 
tower computer. I have notice that when scanning to the tower does not 
have the ability to produce a preview; the laptop has not problem doing 
this. Both use the same O/S version using the same CD to install it on 
both of them. It is likely some setting that differs between the two.


Dan

On 4/5/21 4:42 AM, insomniacno1 wrote:

Version: 7.1.2.2 / LibreOffice Community
Build ID: 5751006d328844ba3fa6124ed263bbf122f0788a
CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded

Even after update I still can't scan into Lo writer, is anyone looking into
why this is happening?

With kind regards

Jan



--
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] Re: LO not finding my scanner

[Philip Jackson]

On 15/02/2021 13:41, insomniacno1 wrote:

2 years later and this is still an issue not only on Linux but also on
Windows XP up to Windows 10, People on the net in various forums have
reported that while scanning does not work in LibreOffice they had it
working in OpenOffice(I have not yet tested that).

I have had this issue since Libreoffice 6.2.2.8 which came installed with my
Peach OSI TW 16.04 LTS(Xubuntu) 64bit, i also tried 6.3.

I just removed all instances of LibeOffice today and installed the snap
version of 7.0.4.2 to see if the problem were solved, but no it's still
there. In Writer, I go to insert-Media-Scan-select source and nothing
happens.


I'd never noticed that this option existed, so I thought I'd give it a try.

My old Epson V200 scanner was plugged into my Windows 10 box so I fired it up, 
Writer as well (LO 7.0.2.2).

It worked first go and scanned a page right into a new document.

An interesting discovery, thanks.

Philip



--
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] Re: LO not finding my scanner

[insomniacno1]

Version: 7.1.2.2 / LibreOffice Community
Build ID: 5751006d328844ba3fa6124ed263bbf122f0788a
CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded

Even after update I still can't scan into Lo writer, is anyone looking into
why this is happening?

With kind regards

Jan



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

[libreoffice-users] Re: Crash creating DB from Spreadsheet.

[Michael Tiernan]

On 4/2/21 7:36 AM, Michael Tiernan wrote:

Just checking before I file a bug report,


As someone pointed out, I wasn't at the newest version.

My apologies for wasting folk's time.

I'll update and revisit this.

--
  << MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


--
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] Re: libreoffice crash on windows 10 related to a lock file

[xplaster]

Hi Luuk,
>Which file did you delete ?
I deleted a file named ".Lock" or very similar in this folder:
C:\Users\\AppData\Roaming\libreoffice\4

instruction you gived in:
>LibreOffice user profile - The Document Foundation Wiki
> 
doesn't include the deletion of profile or lock file, that was useful for me
becouse the libreoffice crash produced a blue screen windows10 crash and the
consequent restart of laptop and wasn't impossible to start libreoffice in
safe mode, its very boring that for a libreoffice error windows crash.
I don't know but it seems that the profile make an autoreset becouse some
options I set before now result different as I well remember to have set
(for example the not move selection after return in calc) )Now the problem
seems soved



--
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] Re: Autocorrect Problem

[John Kaufmann]

Thanks for posting what you found - it led to learning something really useful 
.

On 2021-03-12 00:51, das wrote:


(Though no one responded to my mail, I am replying with the solution, for
information service.)

For around two months I was facing this problem with both the two versions
of libreoffice in arch linux -- the 'still' one and the 'fresh' one. With
none of them Autocorrect was working. I tried en_US, en_Gb, and obviously
my own language bn_IN. Nowhere it was working. So, I wrote to this mailing
list.

This morning I got the solution. I installed snap and then enabled
snapd.socket with systemctl and installed libreoffice with snap. And now it
is working exactly as it should.



On Thu, Mar 4, 2021 at 1:43 PM das wrote:


Dear Friends

My Libreoffice is 7.0.4.2 on Arch Linux, Kernel is 5.10.19-1-lts. My
default language is en_US. And I also use Indic Language Bangla with it.

Autocorrect was working fine some time back. But these days I am seeing
that they are not working anymore.

Any help?

Thanks in Advance

Dipankar Das


--
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] Re: Autocorrect Problem

[das]

(Though no one responded to my mail, I am replying with the solution, for
information service.)

For around two months I was facing this problem with both the two versions
of libreoffice in arch linux -- the 'still' one and the 'fresh' one. With
none of them Autocorrect was working. I tried en_US, en_Gb, and obviously
my own language bn_IN. Nowhere it was working. So, I wrote to this mailing
list.

This morning I got the solution. I installed snap and then enabled
snapd.socket with systemctl and installed libreoffice with snap. And now it
is working exactly as it should.



On Thu, Mar 4, 2021 at 1:43 PM das  wrote:

> Dear Friends
>
> My Libreoffice is 7.0.4.2 on Arch Linux, Kernel is 5.10.19-1-lts. My
> default language is en_US. And I also use Indic Language Bangla with it.
>
> Autocorrect was working fine some time back. But these days I am seeing
> that they are not working anymore.
>
> Any help?
>
> Thanks in Advance
>
> Dipankar Das
>
>

-- 
দাশ das
http://ddts.randomink.org/

-- 
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] Re: File Explorer – Day-week-month search for Libre files

[Brian Barker]

At 00:41 24/02/2021 -0700, Luuk Noname wrote:
 



Clicking just right of 'Date modified' still shows a calendar  
(I admit never seen that calendar before)


I tried that a few hours ago (before I wrote) and it wouldn't show; 
now it does! Weird.


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

[libreoffice-users] Re: File Explorer – Day-week-month search for Libre files

[Luuk]

 

Clicking just right of 'Date modified' still shows a calendar  (I admit
never seen that calendar before)





-
Windows10 / LibreOffice  (latest?)
--
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

[libreoffice-users] Re: LO not finding my scanner

[insomniacno1]

Could be a problem with certain scanners only, I only have the Canon Pixma
MG3070S to test with.



--
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] Re: LO not finding my scanner

[Roderick Anderson]

Interesting.  I never noticed the scan option before.

So I gave it a try.

Linux Mint 19.3, LO 6.0.73, Xsane 0.999 (graphic front end to SANE), 
Brother MFC-L3750 CDW.


Slow-ish but let me scan.

Device (Brother) doesn't support a preview but LO faked it.  Set to 300 
DPI, is scanned and inserted the image.



Rod
--
On 2/15/21 4:41 AM, insomniacno1 wrote:

2 years later and this is still an issue not only on Linux but also on
Windows XP up to Windows 10, People on the net in various forums have
reported that while scanning does not work in LibreOffice they had it
working in OpenOffice(I have not yet tested that).

I have had this issue since Libreoffice 6.2.2.8 which came installed with my
Peach OSI TW 16.04 LTS(Xubuntu) 64bit, i also tried 6.3.

I just removed all instances of LibeOffice today and installed the snap
version of 7.0.4.2 to see if the problem were solved, but no it's still
there. In Writer, I go to insert-Media-Scan-select source and nothing
happens.

I managed to get SANE working to see my scanner and it now works flawless. I
tried some other Office suites but they didn't have scanning options, so
back to LibreOffice in hope that you guys here can figure out a solution.

Printer/All-in-one set up as network printer in my home, Canon Pixma MG3070S
work with their own tool Scangearmp2 and now SANE. I do not run it, and
don't want to, as USB scanner, only network.  I would like to be able to
scan directly in to LibreOffice Writer and other apps of the office pack.

There must be a setting or script somewhere, were this option has been
disabled or written wrong, ex. an # where its not suppose to be.

Hope you will look into this and come up with a solution. Thank you in
advance.

Jan
Solution to the SANE problem, where it can find USB Scanner but not network
Scanner:

1. Open Terminal/Console Shell emulator window
  
2. Download Canon MG3000 Scanner Linux Drivers

Here https://ph.canon/support/PIXMA%20MG3070__%20MG3070S__%20MG3077/model
  
Download Canon MG3070S Scanner Driver for Ubuntu Linux 32/64-bit.


3. Also grab Canon ScanGear MP .deb Driver.

4. Confirm to Open with Archive Manager on Browser
Or after Double-Click/Right-Click on Scanner Driver
(When Downloaded with Firefox may be located in /tmp/mozilla* Dir)
  
5. Extract into the /tmp directory
  
6. Now to Install Canon Scanner Driver


First, access the Target directory with:

cd /tmp/scangear*

And then Run the Installation Script:

sudo ./install.sh

Note: During installation You may be Asked to Connect & Power On your
Scanner…

Now if in the Output you find trace of some Missing Package then try first
to execute:

cd /tmp/scangear*/packages

sudo su -c "apt-get install gdebi"

sudo su -c "gdebi ./*.deb"

When finished, restart the laptop


7. Head over to
https://launchpad.net/~thierry-f/+archive/ubuntu/fork-michael-gruz and
install the ppa as described:

sudo add-apt-repository ppa:thierry-f/fork-michael-gruz
sudo apt-get update

8. Go to /etc/sane.d/ and edit dll.conf as root. Under canon, add
canon_pixma and save the document and close the editor.

9. Open terminal and type sudo sane-find-scanner – it will not find the
scanner

9. In terminal type scanimage -L – scanner is now found and all SANE apps
work. LibreOffice do not work.

Hope this helps someone out there :)




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

[libreoffice-users] Re: LO not finding my scanner

[insomniacno1]

2 years later and this is still an issue not only on Linux but also on
Windows XP up to Windows 10, People on the net in various forums have
reported that while scanning does not work in LibreOffice they had it
working in OpenOffice(I have not yet tested that).

I have had this issue since Libreoffice 6.2.2.8 which came installed with my
Peach OSI TW 16.04 LTS(Xubuntu) 64bit, i also tried 6.3. 

I just removed all instances of LibeOffice today and installed the snap
version of 7.0.4.2 to see if the problem were solved, but no it's still
there. In Writer, I go to insert-Media-Scan-select source and nothing
happens.

I managed to get SANE working to see my scanner and it now works flawless. I
tried some other Office suites but they didn't have scanning options, so
back to LibreOffice in hope that you guys here can figure out a solution.

Printer/All-in-one set up as network printer in my home, Canon Pixma MG3070S
work with their own tool Scangearmp2 and now SANE. I do not run it, and
don't want to, as USB scanner, only network.  I would like to be able to
scan directly in to LibreOffice Writer and other apps of the office pack.

There must be a setting or script somewhere, were this option has been
disabled or written wrong, ex. an # where its not suppose to be.

Hope you will look into this and come up with a solution. Thank you in
advance.

Jan
Solution to the SANE problem, where it can find USB Scanner but not network
Scanner:

1. Open Terminal/Console Shell emulator window
 
2. Download Canon MG3000 Scanner Linux Drivers
Here https://ph.canon/support/PIXMA%20MG3070__%20MG3070S__%20MG3077/model
 
Download Canon MG3070S Scanner Driver for Ubuntu Linux 32/64-bit.

3. Also grab Canon ScanGear MP .deb Driver. 

4. Confirm to Open with Archive Manager on Browser
Or after Double-Click/Right-Click on Scanner Driver
(When Downloaded with Firefox may be located in /tmp/mozilla* Dir)
 
5. Extract into the /tmp directory
 
6. Now to Install Canon Scanner Driver

First, access the Target directory with:

cd /tmp/scangear*

And then Run the Installation Script:

sudo ./install.sh

Note: During installation You may be Asked to Connect & Power On your
Scanner…

Now if in the Output you find trace of some Missing Package then try first
to execute:

cd /tmp/scangear*/packages

sudo su -c "apt-get install gdebi"

sudo su -c "gdebi ./*.deb"

When finished, restart the laptop


7. Head over to
https://launchpad.net/~thierry-f/+archive/ubuntu/fork-michael-gruz and
install the ppa as described:

sudo add-apt-repository ppa:thierry-f/fork-michael-gruz
sudo apt-get update

8. Go to /etc/sane.d/ and edit dll.conf as root. Under canon, add
canon_pixma and save the document and close the editor.

9. Open terminal and type sudo sane-find-scanner – it will not find the
scanner

9. In terminal type scanimage -L – scanner is now found and all SANE apps
work. LibreOffice do not work.

Hope this helps someone out there :)




--
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] Re: Meet the 2020 IEEE PES Wanda Reder Pioneer Power Award Recipient

[Paul D. Mirowsky]

An engineer, a statistician, and a physicist are out hunting. They spot 
a buck, and each take turns to try and bag it. The physicist goes first. 
He pulls out his lab book and quickly calculates the trajectory of the 
bullet, assuming it is a perfect sphere in a vacuum.


The bullet falls *20m* short of the deer.

The engineer goes second. He pulls out his engineer's pad and book of 
projectile assumptions. After a few minutes he’s ready, he takes aim, 
and fires.


The bullet lands 20m passed the deer. The statistician leaps in the air 
shouting, “We got it!”



The error is always in the middle.

Thanks to all the engineers and IEEE and to my father who was one.


On 1/28/21 5:42 PM, John Kaufmann wrote:

On 2021-01-28 16:47, John Kaufmann wrote:

What is sychropopular?  Do you mean synchrophasor? ...


My profound apologies to the list for that. I have no idea how this 
list was added to the distribution of that reply to an (HMTL) mail 
from IEEE Power and Energy Society.




--
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] re: calc: index column A with column B

[James]

I want to find the row in column A that corresponds to the row of a

value in column B.

eg.

rowAB
1  10   22
2  20   15
3  30   3000
4  40   10

=some_function('A',minimum_function(B));

where minimum_function(B) returns 4 and some_function('A',4) returns the

value in column A at row 4.

I asked the previous and someone gave me the formula:

=INDIRECT("$A"(MIN(B:B);B:B;0))


It worked fine but now I have some rows with zeros (more than one row):
row A   B
1   10  22
2   20  15
3   30  3000
4   40  10
5   50  0
6   60  0

Is there a MINBUTGREATERTHANZERO function?



--
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] Re: Meet the 2020 IEEE PES Wanda Reder Pioneer Power Award Recipient

[John Kaufmann]

On 2021-01-28 16:47, John Kaufmann wrote:

What is sychropopular?  Do you mean synchrophasor? ...


My profound apologies to the list for that. I have no idea how this list was 
added to the distribution of that reply to an (HMTL) mail from IEEE Power and 
Energy Society.

--
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] Re: Meet the 2020 IEEE PES Wanda Reder Pioneer Power Award Recipient

[John Kaufmann]

What issychropopular?  Do you meansynchrophasor?-John Kaufmann1-724-433-0459On 
2021-01-28 16:00, IEEE Power and Energy Society wrote:
#outlook a {
  padding: 0;
}.ReadMsgBody {
  width: 100%;
}.ExternalClass {
  width: 100%;
}.ExternalClass,
.ExternalClass p,
.ExternalClass span,
.ExternalClass font,
.ExternalClass td,
.ExternalClass div {
  line-height: 100%;
}html { -webkit-text-size-adjust:none; }body{font-family:Arial, Helvetica, 
sans-serif;}p, .undoreset div p, .undoreset p {
margin-top: 14px;
margin-bottom:14px;  
}img{border:0px !important;}a[x-apple-data-detectors] {
color: inherit !important;
text-decoration: none !important;
font-size: inherit !important;
font-family: inherit !important;
font-weight: inherit !important;
line-height: inherit !important;
}ul.webinar {
padding: 0; margin-left: 1em;
}.textColor {color:#33  !important;outline: none !important; 
text-decoration:none !important; }.btnLine{text-decoration:underline  
!important;}a{outline: none !important; text-decoration:none !important; 
}.mktoVideo a table{width:100% !important;}To view this
  email as a web page,click here
  


  

  At IEEE PowerEnergy Society
  (PES), we are incredibly
  proud to spotlight the
  finale of our series with
  Yilu Lu, the 2020 IEEE PES
  Wanda Reder Pioneer Power
  Award Recipient.
Yilu Lu is a
  Professor at the
  University of
  Tennessee, Knoxville
  (UTK) and Governer’s
  Chair at Oak Ridge
  National Laboratory.
  We thank Yilu for
  innovative
  contributions and
  leadership in
  sychropopular-based
  wide area monitoring
  and control systems.


  Learn
more about Yilu and other
IEEE PES Award recipientsby 
downloading the awards
program here.



Join
  PES todayand receive
complimentary access to our
continuingeducation
program content in ourResource
  Center, PDF downloadsof
our PES magazines 
-ElectrificationandPowerEnergy,
exclusive reduced rates to
PES financially sponsored
events, and more!


  
Join
  PowerEnergy
  Society!


Reduced
IEEE membership
available, to those who
qualify. Learn morehere.


  
  
  


You received this
  communication because you have
  expressed interest in learning
  more about IEEE PowerEnergy related 
topics.
If you no longer wish to
  receive all communications
  related to this technical
  interest, please update yourTechnical
Interest Profile.To unsubscribe 
from PES Awards
  communicationsclick
here.


  
 © 2021
  IEEE– All
  rights
  reserved.


 Website | Privacy
  Policy | Contact


Access
  Your Free
  Papers




  
-- 
To unsubscribe e-mail to: 

[libreoffice-users] Re: [libreoffice-documentation] Metadata Loss LO 7.1.0.2

[Dave Barton]

On 21/01/2021 12:59, Ilmari Lauhakangas wrote:
> On 21.1.2021 14.50, Dave Barton wrote:
>> Version: 7.1.0.2 (x64) / LibreOffice Community
>> Build ID: 53d68d29d90fd16448721a60aad68c28ff0809f5
>> CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster;
>> VCL: win
>> Locale: en-US (en_US); UI-Language: en-US
>> Calc: threaded
>>
>> Before raising a bug report I would like to know if anyone else is
>> seeing this issue:
>>
>> * Normally when a new document is created in Writer the Document
>> Properties Title field is automatically filled with the name of the
>> template (eg. Default) upon which the document is based.
>>
>> * Changing the Document Properties Title field in a new or existing
>> document blanks the field in the saved file.
>>
>> * Opening the saved file in any other version of LO restores the field
>> lost in version 7.1.0.2
> 
> Are you sure you are getting "Default" in the title? I only get a
> pre-filled title with some template like Modern business letter. Works
> fine with 7.2 at least.
> 
> Ilmari

Yes I get "Default" in the title field with 7.0.4.2 (x64) and all 6.x
versions, but that is down to my profile, otherwise I get the same as you.

The real issue is that 7.1.0.2 anything entered in the title field of a
new or existing document is lost (more accurately disappears) on save.

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

[libreoffice-users] Re: Calc calendar in xlsx file format - day numbers disappeared suddenly

[Regina3000]

Ok, so increasingly strange. I looked back at the PDFs for previous years,
and it looks like the numbers have been marching across the cell towards the
right for 3 years, after having started off on the left.

I've reset the base spreadsheet and this year's to zero indent, and made a
note. We'll see if it changes.



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

[libreoffice-users] Re: Calc calendar in xlsx file format - day numbers disappeared suddenly

[Regina3000]

Interestingly, the base spreadsheet that I copy and edit, has an indent of
193 pt, 30 pt less than this one. The one for 2020 has an indent of 53 pt,
and rather than being to the right, where I wanted the numbers to be,
they're somewhere to right of center. I don't have 2019 any longer, or I'd
check that, too.

This is really weird.



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

[libreoffice-users] Re: Calc calendar in xlsx file format - day numbers disappeared suddenly

[Regina3000]

Oh, wow! Good catch! I don't know how that happened, since I didn't
deliberately do that.

I'll also try out your formula suggestion. Thanks!

Any idea how that indent could have slipped in there? I know for sure I
didn't put it there.



--
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] Re: Calc calendar in xlsx file format - day numbers disappeared suddenly

[Remy Gauthier]

Hi Regina,I found your issue: the indent on your cells (like F3) is
223pt which places the text more or less 3 inches (7.9cm) to the right
of the cell. This seems to be something that was done as formatting to
the cells individually because the Default style calls for a zero
indent. Looking at your setup, the long but easier option will be for
you to select the day cells (using CTRL-drag to select more than one)
and then Format > Cells... and go to the Alignment tab: there, set the
Indent value to 0. This should bring your numbers back and they should
be left justified. Excel is not as flexible as LO when it comes time to
format the cells, so if you want to maintain the compatibility with
Excel, do not use the padding that is available on Format > Cells...
Borders if you want to move the numbers around: just use left, right,
center justification.
Some suggestions to make your life easier:You can replace the drop-down 
entry of cell J1 with this formula: =TEXT(DATE(L1,1,1),""), and the
yes/no for leap year in J2 with =IF(DATE(L1+1,1,1)-
DATE(L1,1,1)>365,"yes","no"). And those should work correctly in Excel
as well.Don't hesitate if you have any other questions.Rémy.
Le mardi 12 janvier 2021 à 17:20 -0700, Regina3000 a écrit :
> Hi,It is a bit hard to guess what is going on without actually
> seeingthe file. Can you e-mail it to me?Two things come to mind:-
> Calculations are in manual mode and the cells are not re-
> calculated.You can see the status in Data > Calculate (or try F9 to
> forcerecalculation)- Conditional formatting that overrides the cell
> textcolor because an entry is invalid (year greater than 2020?). You
> cantry to copy a blank cell and paste the value in the cell
> elsewhere(using Paste Special). You can then see if the calculation
> is done andif it's only a formatting issue.- A calculation or data
> element iswrong and the cell formula prevents wrong outputs to be
> shown(something like =IFERROR(something,"")). You can use the
> Detective(Tools > Detective > Trace Precendents) to find which cells
> controlwhich and find the source issueI hope this helps.Rémy.
> Thanks.
> I tried copy/paste special-numbers and the number showed up.
> I tried Data/Calculate/Recalculate hard and that did nothing.
> I tried Tools/Detective/Trace Precedents, and nothing obvious showed
> up.
> I think it's a formatting issue, but it's strange that it would show
> up outof the blue, all of a sudden, when before, it was working just
> fine.
> I've attached a copy of the file with (I hope) sensitive
> informationdeleted. I am seeing the same problems in this file as in
> the original. Iwould be interested to see whether you find that the
> numbers show up foryou. I have a suspicion that they will.
> I'll be able to reboot my computer shortly, and I will report back as
> towhether that fixed the issue. Of course, that won't tell me what
> the issueis...
> 
> 
> --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

[libreoffice-users] Re: Calc calendar in xlsx file format - day numbers disappeared suddenly

[Regina3000]

Hi,It is a bit hard to guess what is going on without actually seeing
the file. Can you e-mail it to me?Two things come to mind:-
Calculations are in manual mode and the cells are not re-calculated.
You can see the status in Data > Calculate (or try F9 to force
recalculation)- Conditional formatting that overrides the cell text
color because an entry is invalid (year greater than 2020?). You can
try to copy a blank cell and paste the value in the cell elsewhere
(using Paste Special). You can then see if the calculation is done and
if it's only a formatting issue.- A calculation or data element is
wrong and the cell formula prevents wrong outputs to be shown
(something like =IFERROR(something,"")). You can use the Detective
(Tools > Detective > Trace Precendents) to find which cells control
which and find the source issueI hope this helps.Rémy.

Thanks.

I tried copy/paste special-numbers and the number showed up.

I tried Data/Calculate/Recalculate hard and that did nothing.

I tried Tools/Detective/Trace Precedents, and nothing obvious showed up.

I think it's a formatting issue, but it's strange that it would show up out
of the blue, all of a sudden, when before, it was working just fine.

I've attached a copy of the file with (I hope) sensitive information
deleted. I am seeing the same problems in this file as in the original. I
would be interested to see whether you find that the numbers show up for
you. I have a suspicion that they will.

I'll be able to reboot my computer shortly, and I will report back as to
whether that fixed the issue. Of course, that won't tell me what the issue
is...



--
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] Re: Fit last column in spreadsheet to print

[Brian Barker]

At 00:21 11/01/2021 -0500, John Kaufmann wrote:
Sorry, but I don't follow: What does it mean for a spreadsheet to 
print one sheet wide?


See "Printing options for page styles" in Chapter 6, "Printing, 
Exporting, E-mailing, and Signing" of the Calc Guide.


o Go to Format | Page... | Sheet | Scale.
o Set "Scaling mode" to "Fit print range(s) to width/height" and 
"Width in pages" to 1.


... (especially in an environment where a sheet could be a million 
columns wide)


In that case, you would have chosen to make your printed data 
probably illegible! (Er, sorry, but maximum columns per sheet is 1024.)


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] Re: Fit last column in spreadsheet to print

[John Kaufmann]

On 2021-01-11 01:14, John Kaufmann wrote:

On 2021-01-11 00:45, Brian Barker wrote:

At 00:21 11/01/2021 -0500, John Kaufmann wrote:

Sorry, but I don't follow: What does it mean for a spreadsheet to print one 
sheet wide?


See "Printing options for page styles" in Chapter 6, "Printing, Exporting, 
E-mailing, and Signing" of the Calc Guide.

o Go to Format | Page... | Sheet | Scale.
o Set "Scaling mode" to "Fit print range(s) to width/height" and "Width in 
pages" to 1.


Very nice! I had overlooked that. Thanks, Brian.


... (especially in an environment where a sheet could be a million columns wide)


... (Er, sorry, but maximum columns per sheet is 1024.)


I did exaggerate, didn't I? 10^6 high, but only 10^3 (AMJ) wide. I should have 
checked.


Um, sorry: That should be 2^20 high by 2^10 (AMJ) wide.
[That was sloppy.]

--
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] Re: Fit last column in spreadsheet to print

[John Kaufmann]

On 2021-01-11 00:45, Brian Barker wrote:

At 00:21 11/01/2021 -0500, John Kaufmann wrote:

Sorry, but I don't follow: What does it mean for a spreadsheet to print one 
sheet wide?


See "Printing options for page styles" in Chapter 6, "Printing, Exporting, 
E-mailing, and Signing" of the Calc Guide.

o Go to Format | Page... | Sheet | Scale.
o Set "Scaling mode" to "Fit print range(s) to width/height" and "Width in 
pages" to 1.


Very nice! I had overlooked that. Thanks, Brian.
 

... (especially in an environment where a sheet could be a million columns wide)


... (Er, sorry, but maximum columns per sheet is 1024.)


I did exaggerate, didn't I? 10^6 high, but only 10^3 (AMJ) wide. I should have 
checked.


I trust this helps.


You bet. Thanks again,
John

--
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] Re: Fit last column in spreadsheet to print

[John Kaufmann]

On 2021-01-10 18:07, Alan B wrote:

...
Your initial question was "...see how I can fit the last column in to print
on  8/12 x 11..." which to me is equivalent to "fit all columns on a single
sheet". So the answer is to set the page width of the printout to one sheet
wide.


? Sorry, but I don't follow: What does it mean for a spreadsheet to print one 
sheet wide?
(especially in an environment where a sheet could be a million columns wide)

--
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] Re: Fit last column in spreadsheet to print

[Alan B]

Hi Charles,

Your initial question was "...see how I cna fit the last column in to print
on  8/12 x 11..." which to me is equivalent to "fit all columns on a single
sheet". So the answer is to set the page width of the printout to one sheet
wide.

Not sure what to say to your follow up, "...I have no idea what I would set
the “Width in pages” to fir this spreadsheet...", because width will ALWAYS
BE set to one sheet if you want the printout to fit across one sheet. If it
has many rows then be sure to set the #of pages high by a number that will
fit everything. If set to 100 the output won't be stretched to be 100 pages
tall.

And you hit on the real trick, "...with all columns across the same page
and also in readable print..." Readable print depends on the number of
columns and the width of the sheet.

If the print isn't legible, try printing the sheet landscape. Now there's
immediately 2½" more paper to scale your columns across. If the print is
still too small then try landscape on a legal page or reduce the number of
columns that need to be seen or both.

p.s. moved back to the list. meant to reply there the first time

On Mon, Jan 4, 2021 at 2:52 PM charles meyer  wrote:

> Hi Alan,
>
>
>
> I hope you’re enjoying a good new year.
>
>
>
> In Calc, I opened the spreadsheet and then held d own the mouse to
> highlight all the columns and rows of content to print.
>
>
>
> I then selected Format > Page and the Sheet tab and selected “Fit print
> range wit width/height” but I have no idea what I would set the “Width in
> pages” to fir this spreadsheet both with all columns across the same page
> and also in readable print.
>
>
>
> I tried this in Excel and I can either get all the columns across the page
> on one page but in tiny print or I can cat the font size in readable size
> but not all the columns align across the one page.
>
>
>
> Any further thoughts re: the “Width in pages” to be set to in Calc?
>
>
>
> I can’t even see how many pages this spread sheet is on as unlike Libre
> Writer or Word there is no page indicator in either Calc or Excel.
>
>
>
> Thank you.
>
>
>
> Charles.
>
>
>
> From: Alan B 
> Date: Tue, Dec 22, 2020 at 3:40 PM
> Subject: Re: [libreoffice-users] Fit last column in spreadsheet to print
> To: charles meyer 
>
> Charles,
>
>
>
> Both LibreOffice Calc and Microsoft Excel include a print feature to scale
> the print range by width and height. The width and height unit used is
> number of pages.
>
>
>
> From your question I expect you want the printout to be one page wide.
>
>
>
> In Calc, select the print range then the menu Format > Page Select the
> Sheet tab and for scaling mode select "Fit print range(s) to width/height"
> and then specify the desired "Width in pages:".
>
>
>
> Same for Excel though I'm sure the menu path would be different.
>
>
>
> On Tue, Dec 22, 2020 at 1:49 PM charles meyer 
> wrote:
>
> Hi all,
>
> Woulds anyone please be willing to look at my spreadsheet file to see how I
> cna fit the last column  in to print on  8/12 x 11.
>
> It's in Excel.
>
> Maybe Calc would do better?
>
> Thank you.
>
> --
> 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
>
>
>
> -- Forwarded message -
> From: Alan B 
> Date: Tue, Dec 22, 2020 at 3:40 PM
> Subject: Re: [libreoffice-users] Fit last column in spreadsheet to print
> To: charles meyer 
>
>
> Charles,
>
> Both LibreOffice Calc and Microsoft Excel include a print feature to scale
> the print range by width and height. The width and height unit used is
> number of pages.
>
> From your question I expect you want the printout to be one page wide.
>
> In Calc, select the print range then the menu Format > Page Select the
> Sheet tab and for scaling mode select "Fit print range(s) to width/height"
> and then specify the desired "Width in pages:".
>
> Same for Excel though I'm sure the menu path would be different.
>
>
> On Tue, Dec 22, 2020 at 1:49 PM charles meyer 
> wrote:
>
>> Hi all,
>>
>> Woulds anyone please be willing to look at my spreadsheet file to see how
>> I
>> cna fit the last column  in to print on  8/12 x 11.
>>
>> It's in Excel.
>>
>> Maybe Calc would do better?
>>
>> Thank you.
>>
>> --
>> 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
>
>

-- 
Alan 

[libreoffice-users] Re: How to Remove Read-Only Restriction

[aln]

Tim Deaton wrote
> When you send something as an attachment in an email, and the recipient 
> clicks on the file IN the email (without saving the file somewhere on 
> his machine first), then the computer opens the file as a "temporary" 
> creature in a "temporary" place.  That "temporary" file is always "read 
> only".  If the user can and does make any changes and wants to save the 
> result, he cannot just "save" the result.  Instead, he must choose "save 
> as", and give the file a permanent home and name on his machine.
> 
> Hope that helps,
> Tim
> 
> On 1/6/2021 12:07 AM, aln wrote:
>> When I send a spreadsheet (xxx.ods) as an attachment in an email (I use
>> Thunderbird), it is received as a "Read-Only" file.  The only Options
>> that I
>> know of don't appear to force it to be Read-Only (see attached). So how
>> do I
>> disable this restriction?
>> http://document-foundation-mail-archive.969070.n3.nabble.com/file/t495249/LibreO_Calc01.jpg;
>> http://document-foundation-mail-archive.969070.n3.nabble.com/file/t495249/LibreO_Calc02.jpg;
>>
>>
>>
>> --
>> Sent from:
>> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
>>
> 
> 
> -- 
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> 
> 
> -- 
> To unsubscribe e-mail to: 

> users+unsubscribe@.libreoffice

> 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

Thanks for the detailed explanation Tim. Problem solved!



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

[libreoffice-users] Re: How to Remove Read-Only Restriction

[aln]

Trying to open the attached file directly from Thunderbird was exactly the
problem. Thanks for your help Robert!



--
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] Re: Suggestion: 3D spreadsheets

[toki]

On 22/12/2020 19:23, James wrote:

On 2020-11-24 9:45 a.m., PaddleS wrote:
Something new an that would be really great is to add implementation 
for and potentially more) dimensional spreadsheets.

What it would look like :
Basically the same as a 2D spreadsheet. But by holding Alt+scrolling with
the mouse, you could change the third dimension, showing the 2D spreadsheet of 
that third index...

Give an example of what it could be used for.


x-axis is time;
y-axis is factory;
z-axis is specific-product;
w-axis is cost-to-manufacture/wholesale price/distributor price/MSRP;

I've seen, and used spreadsheets with 4+ dimensions. By every measurable 
metric, they were were a disaster to work with. Much simpler and easier 
to use an appropriate designed database, with SQL to extract the 
appropriate data, and R to analyze that data.


jonathon

--
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] Re: Suggestion: 3D spreadsheets

[James]

On 2020-11-24 9:45 a.m., PaddleS wrote:

Something new an that would be really great is to add implementation for 3
(and potentially more) dimensional spreadsheets.
What it would look like :
Basically the same as a 2D spreadsheet. But by holding Alt+scrolling with
the mouse, you could change the third dimension, showing the 2D spreadsheet
of that third index.

For instance let's say the third dimensions use greek characters. Then by
default you see the "α" 2D spreadsheet showing the numbers and letters grid
at that value "α".
You hold Alt and scroll once and it changes to "β" 2D spreadsheet. And so
on.

Also it would require a way to select the X and Y axis in order to visualize
the data. So for instance you could change the X axis to display the greek
letters dimension and show the numbers on Y axis.

This could be really powerful. What do you think?



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


Give an example of what it could be used for.



--
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] Re: Printing labels from a database is missing every other page

[Harvey Nimmo]

Thanks to all you guys for your help. It is possible to insert a page
break in the template, but there was none there in my case, so I still
have to ask myself: where does the blank page come from? There is a
setting, however, to print only left hand pages. That does the trick of
suppressing the blank pages.

Many thanks, again
Harvey   


On Tue, 2020-12-15 at 09:42 -0800, Richard England wrote:
> Is there a page break  inserted at the end of the template page?
> 
> ~~R
> 
> 
> On 12/15/20 8:53 AM, Harvey Nimmo wrote:
> > and finally
> > It is not as bad as I had surmised. All the is happening, is that
> > the
> > label printing process is generating an extra blank page between
> > valid
> > pages. All labels are actually printed. Only the blank label pages
> > have
> > to be extracted from the print job (and reused!);-)
> > On Tue, 2020-12-15 at 17:39 +0100, Harvey Nimmo wrote:
> > > Sorry, I forgot to provide the LO version I am using:
> > > LO Version: 6.4.5.2Build ID: 40(Build:2)CPU threads: 2; OS: Linux
> > > 5.3; UI render: default; VCL: gtk3; Locale: en-GB (en_GB.UTF-8);
> > > UI-
> > > Language: en-GBCalc: threaded
> > > And additionally, I should day that the odt label file generated
> > > shows 13 pages in the statistics at the foot of the window, but
> > > fails
> > > to show the blank pages, i.e. only 7 pages are shown.
> > > CheersHarvey
> > > On Tue, 2020-12-15 at 17:30 +0100, Harvey Nimmo wrote:
> > > > What could be going wrong here? Can anyone help?
> > > > I am trying to print a set of address labels (3x5 per page)
> > > > using
> > > > LO Base connected to a remote MariaDB. The report facilities
> > > > correctly show the data I want to be printed.
> > > > The label procedure apparently produces the label report
> > > > corresponding to selected db-records and correctly shows the
> > > > number
> > > > of A4 label pages  generated (13). However, on printing them to
> > > > actual labels, every second page is blank.
> > > > Inspection of the print file using print preview indeed shows
> > > > all
> > > > even pages to be blank, and exporting the file to PDF
> > > > compresses
> > > > the whole file automatically to 7 pages.
> > > > What must I do to get the labels from the even pages printed
> > > > out?
> > > > 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] Re: Printing labels from a database is missing every other page

[Richard England]

Is there a page break  inserted at the end of the template page?

~~R


On 12/15/20 8:53 AM, Harvey Nimmo wrote:

and finally
It is not as bad as I had surmised. All the is happening, is that the
label printing process is generating an extra blank page between valid
pages. All labels are actually printed. Only the blank label pages have
to be extracted from the print job (and reused!);-)
On Tue, 2020-12-15 at 17:39 +0100, Harvey Nimmo wrote:

Sorry, I forgot to provide the LO version I am using:
LO Version: 6.4.5.2Build ID: 40(Build:2)CPU threads: 2; OS: Linux
5.3; UI render: default; VCL: gtk3; Locale: en-GB (en_GB.UTF-8); UI-
Language: en-GBCalc: threaded
And additionally, I should day that the odt label file generated
shows 13 pages in the statistics at the foot of the window, but fails
to show the blank pages, i.e. only 7 pages are shown.
CheersHarvey
On Tue, 2020-12-15 at 17:30 +0100, Harvey Nimmo wrote:

What could be going wrong here? Can anyone help?
I am trying to print a set of address labels (3x5 per page) using
LO Base connected to a remote MariaDB. The report facilities
correctly show the data I want to be printed.
The label procedure apparently produces the label report
corresponding to selected db-records and correctly shows the number
of A4 label pages  generated (13). However, on printing them to
actual labels, every second page is blank.
Inspection of the print file using print preview indeed shows all
even pages to be blank, and exporting the file to PDF compresses
the whole file automatically to 7 pages.
What must I do to get the labels from the even pages printed out?
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] Re: Printing labels from a database is missing every other page

[Harvey Nimmo]

and finally 
It is not as bad as I had surmised. All the is happening, is that the
label printing process is generating an extra blank page between valid
pages. All labels are actually printed. Only the blank label pages have
to be extracted from the print job (and reused!);-)
On Tue, 2020-12-15 at 17:39 +0100, Harvey Nimmo wrote:
> Sorry, I forgot to provide the LO version I am using:
> LO Version: 6.4.5.2Build ID: 40(Build:2)CPU threads: 2; OS: Linux
> 5.3; UI render: default; VCL: gtk3; Locale: en-GB (en_GB.UTF-8); UI-
> Language: en-GBCalc: threaded
> And additionally, I should day that the odt label file generated
> shows 13 pages in the statistics at the foot of the window, but fails
> to show the blank pages, i.e. only 7 pages are shown.
> CheersHarvey
> On Tue, 2020-12-15 at 17:30 +0100, Harvey Nimmo wrote:
> > What could be going wrong here? Can anyone help?
> > I am trying to print a set of address labels (3x5 per page) using
> > LO Base connected to a remote MariaDB. The report facilities
> > correctly show the data I want to be printed. 
> > The label procedure apparently produces the label report
> > corresponding to selected db-records and correctly shows the number
> > of A4 label pages  generated (13). However, on printing them to
> > actual labels, every second page is blank. 
> > Inspection of the print file using print preview indeed shows all
> > even pages to be blank, and exporting the file to PDF compresses
> > the whole file automatically to 7 pages.
> > What must I do to get the labels from the even pages printed out?
> > 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] Re: Printing labels from a database is missing every other page

[Harvey Nimmo]

Sorry, I forgot to provide the LO version I am using:
LO Version: 6.4.5.2Build ID: 40(Build:2)CPU threads: 2; OS: Linux 5.3;
UI render: default; VCL: gtk3; Locale: en-GB (en_GB.UTF-8); UI-
Language: en-GBCalc: threaded
And additionally, I should day that the odt label file generated shows
13 pages in the statistics at the foot of the window, but fails to show
the blank pages, i.e. only 7 pages are shown.
CheersHarvey
On Tue, 2020-12-15 at 17:30 +0100, Harvey Nimmo wrote:
> What could be going wrong here? Can anyone help?
> I am trying to print a set of address labels (3x5 per page) using LO
> Base connected to a remote MariaDB. The report facilities correctly
> show the data I want to be printed. 
> The label procedure apparently produces the label report
> corresponding to selected db-records and correctly shows the number
> of A4 label pages  generated (13). However, on printing them to
> actual labels, every second page is blank. 
> Inspection of the print file using print preview indeed shows all
> even pages to be blank, and exporting the file to PDF compresses the
> whole file automatically to 7 pages.
> What must I do to get the labels from the even pages printed out?
> 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] Re: Question on getting a list of all the macro commands

[LibreOfficiant]

Hi Mike

Macro commands list as of TDF wiki
  

source  ask.libreoffice.org

  

Really HTH





-
cf. Designing and Developing Python Applications  - 
https://wiki.documentfoundation.org/Macros/Python_Design_Guide

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

[libreoffice-users] Re: Chapter and footnotes enumeration issues in LO Writer 7.0 and 7.0.3.1 beta

[UlfDunkel]

The relevant document was originally created in MS Word. I converted it into
a LO .odt and used to continue working on that document in .odt format.
After the issues occured, I saved it as .fodt and .rtf and it seems as if
the RTF conversion get rid of the inherited MS .doc issues.



--
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] Re: Chapter and footnotes enumeration issues in LO Writer 7.0 and 7.0.3.1 beta

[Michael H]

To confirm your issue, was this document with the problem ever a different
format?
That is, did it begin as a MS Word that you opened in LO and then saved?

Each time you save the document, are you saving it as ODT format or another
format?

On Sat, Nov 28, 2020 at 4:37 AM UlfDunkel  wrote:

> Self-reply:
> I deinstalled LO 7.x and returned to LO 6.4.7.2 but that didn't help. The
> issues (forgotten heading styles and footnote enumeration) seem to stick
> inside the document.
>
> What seemed to help was creating a new document and copying the whole
> content of my 650 pages book into that new document. After adjusting some
> applied paragraph styles, everything seems to work fine again. Saving the
> new document, quitting and relaunching LO brought the new document back as
> expected.
>
> What else could I have done to fix this issue?
>
>
>
> --
> 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
>
>

-- 
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] Re: Chapter and footnotes enumeration issues in LO Writer 7.0 and 7.0.3.1 beta

[UlfDunkel]

Self-reply:
I deinstalled LO 7.x and returned to LO 6.4.7.2 but that didn't help. The
issues (forgotten heading styles and footnote enumeration) seem to stick
inside the document.

What seemed to help was creating a new document and copying the whole
content of my 650 pages book into that new document. After adjusting some
applied paragraph styles, everything seems to work fine again. Saving the
new document, quitting and relaunching LO brought the new document back as
expected.

What else could I have done to fix this issue?



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

[libreoffice-users] Re: Libreoffice not able to write to Rclone mount points

[ashish128]

I found my Solution.

I was missing below flags

--vfs-cache-mode full



--
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] Re: [Calc] Convert GPS coords from DMS to decimals?

[Dave Howorth]

On Mon, 23 Nov 2020 07:18:48 +1000
"Michael D. Setzer II"  wrote:

> Time format is definitely the simplist option.

But semantically is entirely incorrect. It's [something more than] a
coincidence that spatial coordinates use the same notation as time
coordinates, but no more than that.

-- 
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] Re: [Calc] Convert GPS coords from DMS to decimals?

[Brian Barker]

At 10:02 22/11/2020 -0700, Gilles Noname wrote:

Brian Barker wrote
Yes, if your locale needs semicolons as separators commas will not 
do. That is definitely  what error 509 will be signalling.


Odd that the locale would change the sign used in functions.


Odd, maybe, but true. Sorry that my formulae did not exactly match your needs.


Brian Barker wrote
That is because you have - weirdly - chosen to mess up my formula, 
changing my "E" (for east) into "O" (for west). So *of course* the 
longitude signs are now reversed. Reinstate my "E" and everything will work.


Because in the document O = West, not East (which I forgot to point out).


I know that, but it seems you don't! You didn't need to point it out: 
I had realised - and explained so in my original message. But you are 
still missing the point here. You thought you needed to translate my 
formula, but you didn't: I wrote exactly what you needed here. My 
test mentions "E" for east (or "est") but properly distinguishes 
between "E and "O". By changing "E" to "O" you have not translated 
into French but changed east to west. I'm sure east in France is the 
same east as anywhere else, and similarly west - no matter that the 
names are different! (Or do French compasses point southwards?!) You 
need "E" for French "est" in my formula just as you would need "E" 
for English "east". Surely you can see that swapping east and west 
(as you chose to do) will swap the signs of your longitude values and 
introduce the error?



https://postimg.cc/QH0q5qmn


Yes: I based my formulae on that original picture! Note that includes 
"E" for east/est.


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