[libreoffice-users] Re: question: how can I make the scrollbars wider on LibreOffice?

[Mike Flannigan]

I don't know if there is a good answer to this
question.  If you don't get an answer consider
signing up to this forum:
https://forums.linuxmint.com


Mike


On 7/6/24 19:04, users+h...@global.libreoffice.org wrote:

Hello,
I just subscribed to this forum tonight so I could ask this question.
I am a long-time user of Linux Mint and LibreOffice.  I have low vision, so
I use a large default font size and have my default screen magnification
set to 150%.  Recently, I did a clean upgrade to Linux Mint 21.3.  I was
easily able to adjust the scrollbar width on my browsers, but the
scrollbars in LibreOffice are so narrow that I can barely see them.
Increasing the screen magnification unfortunately doesn't change the width
of the scrollbars.  I spent most of the day today working in LibreOffice
Calc, and I must have missed both the vertical and the horizontal
scrollbars hundreds of times.  Very frustrating!  I have spent the evening
researching fixes for this, but the suggestions I found were all several
years old, and none of them seem to be working on Mint 21.3.  Can you
suggest a way to make the scrollbars wider globally across 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

Re: [libreoffice-users] LibreOffice suite

[Mike Flannigan]

I didn't know tablets were so handicapped.
I guess I will stay away from those.


Mike


On 5/31/24 23:03, users+h...@global.libreoffice.org wrote:

I use LibreOffice suite on my desktop pc and can find my way around it
easily (sometimes I need to search your website for assistance).

I have recently bought a Lenovo P11 tablet (discontinued stock) and would
LOVE to be able to use LibreOffice on it! It is frustrating that if I do
not pay for Microsoft (I do not like their new operating system — or the
expense!), I am unable to use my tablet to its full capacity. I cannot open
any text documents on the tablet that I email myself from my pc! I cannot
use any document software, unless I use Microsoft.

Please, please create an office Suite for tablets! I cannot be the only
person that needs this in my life! At least the Writer element!

Thank you

Best wishes
Laura



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

[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

Re: [libreoffice-users] Copy-Paste from PDF to Writer modifies document metadata

[Mike Flannigan]

I have not seen that happen, but if it does happen I
think it has more to do with the way the PDF was
created, than with the operation of Libreoffice Writer.


Mike


On 11/20/23 14:06, users+h...@global.libreoffice.org wrote:

Subject:
[libreoffice-users] Copy-Paste from PDF to Writer modifies document 
metadata

From:
Pablo Sanxiao 
Date:
11/20/23, 12:56

To:
users@global.libreoffice.org


I would like to share this behaviour with you in order to make sure if 
it could be a Libreoffice bug or it is a desired behaviour. Or even if 
the problem exists but is not related with Libreoffice.


When I copy something from a PDF to Libreoffice Writer, metadata of 
PDF file is copied also to libreoffice document. I think this is weird 
but not sure if could be a bug. What do you think?


Thank you in advance.

Regards.


--
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] Save and Edit Text document

[Mike Flannigan]

On 10/29/23 20:12, Kenneth Groninga wrote:

When I scan a document how can I save if as a text rather tban an image?



By using OCR to turn it into text.  Often the
OCR is built-in to the scanning software.


Mike



--
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] Save and Edit Text document

[Mike Flannigan]

On 10/29/23 18:41, Kenneth Groninga wrote:
There are 2 instances.  I have an old written document that I want to 
edit.. So I scan it and file it in My Documents . Then I open it in 
Libre Office Writer to edit it and I can not edit the document.


That is normal.  If scanning turns the documents into
an image file, it cannot be edited by Writer or Draw.
I mean you can make marks on the document, but you
cannot change the text.



Also I type a document in Libre Office Writer and save it in My 
Documents.  Later I want to edit it so I open it in Libre Office 
Writer and again I can not edit it.  Why can I not edit these documents?



That is not normal.  You should be able to edit it.

So when you type something to edit it, does anything
happen?  Can you get a blinking cursor?




Kenneth Groninga

On Sun, Oct 29, 2023 at 3:58 PM Mike Flannigan  wrote:


What you are doing is not normal.  Why scan it?  Why not
just open the text file in anything and edit it?

If you want to go back and forth between text and image file,
you can.  On Linux I use tesseract to do ocr.


Mike


On 10/26/23 10:05, users+h...@global.libreoffice.org wrote:


How do I scan a text document and save it and then later open it and edit
it?

Kenneth Groninga





--
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] Save and Edit Text document

[Mike Flannigan]

What you are doing is not normal.  Why scan it?  Why not
just open the text file in anything and edit it?

If you want to go back and forth between text and image file,
you can.  On Linux I use tesseract to do ocr.


Mike


On 10/26/23 10:05, users+h...@global.libreoffice.org wrote:


How do I scan a text document and save it and then later open it and edit
it?

Kenneth Groninga



--
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] problems on Ubuntu

[Mike Flannigan]

Assuming you did not install the Flatpak version:

Go to the folder with the calc document in it.  Right click an empty 
space and select "Open in terminal".  Then type this in the terminal and 
enter:

libreoffice --calc

Does calc open?  If so, close it.  Is there any response in the terminal?

Then type this in the terminal and enter:
libreoffice --calc 

Replace  with the filename.
Does calc open?  If so, close it.  Is there any response in the terminal?

Mike


On 9/2/23 15:08, users+h...@global.libreoffice.org wrote:
This year, I switched to Ubuntu, and I am having a problem with the 
opening

of spreadsheet and other Libre Office files, though not with Writer, which
is what I use the most.

When I open a spreadsheet, the icon appears in the margin, but I cannot
actually open the document and get it to display. It must be a setting I
have somehow changed, for I used to be able to open up a spreadsheet, but
not any more.

Clearly, the file is somewhere, but I am not getting it to open up and
display on the screen.



--
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] Question about LibreOffice Calc 7.4.7 and hidden columns

[Mike Flannigan]

Hiding and unhiding columns or rows anywhere on the spreadsheet
works fine with my Calc 6.4.7.2 on Linux Mint, even with "Freeze
rows and columns" in effect.  So I would say you found a bug.


Mike


On 8/14/23 13:08, users+h...@global.libreoffice.org wrote:

Hi!  My dad just contacted me about a problem he had with a 
spreadsheet with some hidden rows and columns.  He's running Calc 
7.4.7 on Windows 11.  Anyway, when he attempts to unhide some hidden 
columns, they won't unhide.  He sent the spreadsheet to me and I found 
out the columns wouldn't unhide due to being "frozen".  By 
un-selecting "Freeze rows and columns", I was able to get the columns 
to appear.  I passed that information on to him and he was able to do 
the same.


Question:  should frozen columns be able to be hidden/shown when frozen?

He has since upgraded to LibreOffice 7.5.5.2.

Thanks in advance!

Peace...

Tom



--
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] Reading a crash report

[Mike Flannigan]

I don't know if cygwin is needed to print Avery labels, but
I can tell you that you can install cygwin on your computer
if you want to.  I had it installed when I was on windows,
and I believe it is a simple install and uninstall.


Mike


On 7/22/23 11:04, users+h...@global.libreoffice.org wrote:

LO (7.4.2.3, Windows 10) crashed when I tried to do a quick job with 
labels. To use sheet labels (Avery 5160) in a non-standard orientation 
(Landscape (W>H) for the page, which means Portrait (H>W) for the 
label), I simply defined a table (10-col x 3-row) to fill the page. 
Then I had text in labels, and Images (arrows) anchored To_Paragraph 
(to the cell's text paragraph). That seemed fine until it crashed -- 
and after Recovery, most of the Images were Hidden.


So I tried to "unhide" the Hidden Images using a 
copy-to-another-document method recommended in a thread from 
16.Oct.2020 at ask.libreoffice.org, and it crashed again -- at which 
point I turned my attention to the crash report 
. 
It shows:


Crash Reason EXCEPTION_ACCESS_VIOLATION_READ
Crash Address 0x148
Crash Thread 0
Signature 
IsSelectFrameAnchoredAtPara(SwPosition_const_&,SwPosition_const_&,SwPosition_const_&,DelContentType 
 



The record for Crash Thread 0 says:

Module    swlo.dll
Source 
C:\cygwin64\home\buildslave\source\libo-core\sw\source\core\undo\undobj.cxx:1672


But that leaves me seriously lost regarding how to read this and 
contribute to a report, because there is no C:\cygwin64\ on the 
system!  Besides moving this job to LO on Ubuntu 20 (my next step), 
can someone advise how to read and report this LO/Windows bug?


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] How to unsubscribe

[Mike Flannigan]

Thanks for the laugh :-)

On 5/25/23 07:14, users+h...@global.libreoffice.org wrote:

Subject:
[libreoffice-users] How to unsubscribe
From:
Amn Ojee Uw 
Date:
5/24/23, 15:40

To:
users@global.libreoffice.org


What is needed to unsubscribe from this list?

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.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] Calc default font size

[Mike Flannigan]

Go to Tools > Options > LibreOffice > Fonts and change it there.

Does that work?


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

Subject:
[libreoffice-users] Calc default font size
From:
Philip Jackson 
Date:
5/21/23, 12:53

To:
LibreOffice 


Using LO 7.3.7.2 in UbuntuStudio 22.04

These days, I need a minimum of  12pt font size in Calc. Creation of a 
new file via File > New > Spreadsheet opens always with settings at 
10pt.  I have edited a Default template in the .config/libreoffice/ 
directory with 12pt font size and creating a new file via File > New > 
Templates > Default  does get me a new spreadsheet with settings at 12 
pt for the first 4 sheets but any extra sheets I create are set at 10pt.


In Tools > Options > LibreOffice Calc > Defaults, there is only an 
option to specify the number of sheets in a new spreadsheet. I've 
searched under Tools > Options > LibreOffice > Advanced > Open Expert 
Configuration looking for a default font size setting but without 
success.


Can anyone advise how and where I can adjust the settings so that by 
default I always get new sheets set to 12pt, and preferably by default 
at the File > New > Spreadsheet without having to pass via the template ?


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

Re: [libreoffice-users] Insert Special Characters

[Mike Flannigan]

AutoHotKey might work for you, but I find it difficult.
You might find a clipboard manager easier to us.
I use CopyQ on Linux.  Copy, and then pin it to the list.



Mike


On 5/1/23 05:27, users+h...@global.libreoffice.org wrote:

Subject:
Re: [libreoffice-users] Insert Special Characters
From:
Jonathan Allen 
Date:
5/1/23, 01:52

To:
Johnny Rosenberg 
CC:
users@global.libreoffice.org


Johnny,


Another option would be to use something like AutoKey (on Linux) or
AutoHotKey (on Windows) to type those characters for you, or if you use
Linux you can just use the Compose key (a lot of information about that
online).

Thank you - I will check that out.  It sounds useful.

Jonathan



--
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] Importing a row from a spreadsheet

[Mike Flannigan]

I suggest you use the concatenate command, perhaps multiple
times with If commands included where needed to get the
A-L columns combined into a single cell in the output
format you desire.



Mike



On 4/27/23 03:04, users+h...@global.libreoffice.org wrote:

Subject:
[libreoffice-users] Importing a row from a spreadsheet
From:
Ian Graham 
Date:
4/26/23, 05:47

To:
users@global.libreoffice.org


Good morning from Wales, UK


I am a member of a local Heritage Society which some years ago created a
digital archive of several hundred photographs.

The archive is indexed in an Excel-type document, which was possibly not
very skilfully formated at the time. The index comprises 12 columns,
A>L, in an A4 Landscape layout, but the actual document seems to extend
rightwards almost to infinity.

I would now like to create new individual ‘slides’, probably as pdfs,
uniting each image with the information about it. But I have not yet
worked out the best method by which to import the information from the
*.ods.


One difficulty is that a ‘copy’ of a row from the dbase does not paste
neatly into a new document – it always seems to spill out to the right.

The other difficulty is choosing the best method of pasting. I have
tried all the ‘paste special’ options, and none of them seem to offer a
one-stop-shop route of import.


I have tried, for instance, creating a new table of 12 equal columns
that fits on my new page, with the idea of pasting into it, and then
sorting out the spacings, but I have not yet even found a way of so pasting.

The best method I have come up with so far is simply pasting the copied
row as unformated text, and then manually inserting the various elements
into the appropriate cell of a new table; which achieves the desired
result in the end, but is going to be cumbersome over several hundred
photos.

Any suggestions as to the most efficient way to proceed will be greatly
appreciated.

Sincerely

Ian Graham



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

Re: [libreoffice-users] Calc function COUNTA

[Mike Flannigan]

That is no surprise to me.
ISBLANK=0
is non-sensical and returns "#NAME?".  COUNTA counts
that as a non-empty value.  All is good.


Mike



On 6/25/22 15:05, users+h...@global.libreoffice.org wrote:

Subject:
[libreoffice-users] Calc function COUNTA
From:
Harvey Nimmo 
Date:
6/25/22, 14:41

To:
libreoffice-users 


I wanted to count the number of non-blank items in a list of items
using COUNTA.

Cell A1 has the formula =COUNTA(A$2:A$1, ISBLANK=0) above an
otherwise empty column.  It returns the value 1!

Is that supposed to mean something? Has anyone notice this?
It's obviously not a big problem, because a workaround is obvious.
But do I have to mistrust the results of the COUNTA function?

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] Nested Drop-down List

[Mike Flannigan]

Are you familiar with Auto Filter?
Highlight all column headers and all the data below -
then select Data - Autofilter.

Is that what you want?
You can set multiple filter criteria in the column header drop-downs.

Select Data - Autofilter again to turn it off, if you want it off.


Mike


On 5/21/22 15:07, users+h...@global.libreoffice.org wrote:

Subject:
[libreoffice-users] Nested Drop-down List
From:
"Vince@Verizon" 
Date:
5/21/22, 12:40

To:
users@global.libreoffice.org


Hi:

Hope that all are well.

I am using LO 7.3.2.2 (x64) on desktop Win10 Home.

I want to fine tune a LO Calc file by adding a column that includes a 
Category drop-down menu, but I find that I might have need for 
subcategories, in some cases, to avoid a very long list of items.


I recall viewing a tutorial about what I am calling "nested drop-down 
menu list", whereby if an option in the parent drop-down is selected, 
a second, a third, ... etc. drop-down list is then opened, if they 
exist. For example, if one option is utilities, a second drop-down is 
opened showing, e.g. telephone, electricity, heating fuel, water, 
etc., as further, optional, selections.


Unfortunately, I cannot recall if the tutorial was for Excel or Apache 
Open Office or Libre Office.


Can somebody point me to a */Libre Office/* video tutorial or within 
the LO Help that covers "nested drop down list"? "Nested drop-down 
menu list" is most probably an incorrect key word text string.


Thanks for reading this.

VinceB.


--
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] Extracting content out of table format received in an email

[Mike Flannigan]

Try pasting into a text file and then copying from
the text file.  Sometimes that works for me.

There are more elegant ways of doing the same thing,
but it usually involves writing a Perl script.


Mike


On 2/23/22 02:09, users+h...@global.libreoffice.org wrote:

Do you ever receive emails of mini-newsletters where you want to save some
of the content in the email but if you copy/paste it into Libre Writer it’s
all in a table?

Looks good but now you wish to delete 1/3 of the content except you have to
delete rows, etc.

So time consuming.

I’ve tried all 4 ways to Paste into Libre Writer (plain text loses all the
bullet  points)

Is there any shortcut to removing content from a table without losing all
the formatting (e.g. bullet points, graphics?


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

Re: [libreoffice-users] Buy/Sell Calculation

[Mike Flannigan]

I guess the slave column could be column G.

Can't you just copy the $15,25 'buy price' up
into cells C:2 to C:9?  Then you can just
calc the slave in column G with a consistent
formula.



Mike


On 10/13/21 1:04 AM, users+h...@global.libreoffice.org wrote:

Hello,

I have to calculate prices (buy/sell) and have a question to make it
easier. A little bit maybe:)

The file >http://status.sisi-systems.ovh/article_sample.csv

The file contains the columns Article number, text of the supplier,
purchase price, sales price, the lengths and master (1) slave (0).
The factor is for calculating the purchase price. The master (1)
can be ordered, the slave (0) items not. These are blanks.

The question is can I calculate the slaves automatically by
calculation on the basis of the master?

With  hand for example:

=C10/E10*E2
=C10/E10*E3
...

With multiple suppliers:
=(C35+C36/2)/E36*E20
=(C35+C36/2)/E36*E21
=(C35+C36/2)/E36*E22

For several articles, this is a monthly job. Isn't there a way to do this
a little automated? Comparison with article number + master / slave? When
it will only work with one supplier it will be okay.

Maybe someone have an idea? It would be great.

Thank you
Silvio



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

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

[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

Re: [libreoffice-users] Nabble users list down?

[Mike Flannigan]

I just read that nabble is going to be history.
Lets see - here you go:
https://support.nabble.com/The-Future-of-Nabble-td7605923.html


Mike


On 7/22/21 3:06 AM, users+h...@global.libreoffice.org wrote:

Subject:
[libreoffice-users] Nabble users list down?
From:
jerr...@gmx.com
Date:
7/21/21, 4:53 PM

To:
users@global.libreoffice.org


Does anyone know what has happened to the DocumentFoundation forum on 
nabble.com? I havent been able to access it for the past several days.


Just asking.



--
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] Calc how to display Autofilter values?

[Mike Flannigan]

Ahh.  Now I understand.  I can see how that might be useful.
Sorry, but I don't know a way to do that right now.
Seems like that might be a relatively easy thing to do,
but I don't know how.


Mike


On 6/9/21 8:24 PM, Alan B wrote:
Not at all what I'm trying to do. Distinct values have their uses. But 
I already knew how to do that.


I'm trying to display the AutoFilter values being applied to a table 
so they can be read without opening up each filter at the top of each 
column to see what the settings are.


For example, three columns Name, Weight, Dimensions. The table has 
1000 rows. AutoFilter is in use and 727 rows are displayed. What are 
the filter settings? Sure, can tell if a filter is applied by looking 
at the filter list widget and opening it if it shows the filter is in 
use. And even if all three are in use, no big deal. Only three to open 
and check the values.


When the table has 30+ columns and hundreds or thousands of rows, not 
such a simple task. Much more convenient just to have a formula that 
will display the settings of all applied filters.


If I'm not explaining the requirement clearly please look at the link 
to the Excel solution. That's got pictures along with an explanation 
of the problem and solution.


That's what I'd like to reproduce in Calc.



On Wed, Jun 9, 2021 at 6:49 AM Mike Flannigan <mailto:mf...@mflan.com>> wrote:



See this:

https://bytefreaks.net/applications/libreoffice-calc-get-the-distinct-unique-values-in-a-column-or-a-list-of-elements

You can use Ctrl-z to undo the command, but don't use Ctrl-Shift-y
to redo it
on another column.  You must go through the command again on
another column
and then do Ctrl-z again.


Mike


On 6/9/21 3:07 AM, users+h...@global.libreoffice.org
<mailto:users+h...@global.libreoffice.org> wrote:

Many moons ago I was using some Calc sheets with AutoFilter routinely. The
filter value would be changed, the sheet closed and sometime later opened
again.

To understand the displayed rows the filter values needed to be known. And
that involved opening each filter and checking the value.

So I asked, is there a way to display those values? No answers. And the
need went away.

Just recently had the same need in Excel. Found online the exact answer
needed to make it work.

https://www.extendoffice.com/documents/excel/1444-excel-display-show-filter-criteria.html
The section "Display / Show auto filter criteria in worksheet with VBA
code" is what I referenced.

I've used that info to try and extrapolate a similar method in Calc to no
avail.

Have done a limited amount of searching in Andrew Pitonyak's OpenOffice.org
Macros Explained book and searched through OASIS Open Document Format
documents using terms like "filter" and "range". The answer might have been
staring me in the face, I'm thinking in particular of section 15.6.3 of
Andrew Pitonyak's OpenOffice.org Macros Explained, but I just didn't
understand it.

Can anyone provide guidance to display the autofilter values in a Calc
sheet equivalent to the instructions provided for Excel at the link above?

Thank you.




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




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Calc how to display Autofilter values?

[Mike Flannigan]

See this:
https://bytefreaks.net/applications/libreoffice-calc-get-the-distinct-unique-values-in-a-column-or-a-list-of-elements

You can use Ctrl-z to undo the command, but don't use Ctrl-Shift-y to 
redo it

on another column.  You must go through the command again on another column
and then do Ctrl-z again.


Mike


On 6/9/21 3:07 AM, users+h...@global.libreoffice.org wrote:

Many moons ago I was using some Calc sheets with AutoFilter routinely. The
filter value would be changed, the sheet closed and sometime later opened
again.

To understand the displayed rows the filter values needed to be known. And
that involved opening each filter and checking the value.

So I asked, is there a way to display those values? No answers. And the
need went away.

Just recently had the same need in Excel. Found online the exact answer
needed to make it work.
https://www.extendoffice.com/documents/excel/1444-excel-display-show-filter-criteria.html
The section "Display / Show auto filter criteria in worksheet with VBA
code" is what I referenced.

I've used that info to try and extrapolate a similar method in Calc to no
avail.

Have done a limited amount of searching in Andrew Pitonyak's OpenOffice.org
Macros Explained book and searched through OASIS Open Document Format
documents using terms like "filter" and "range". The answer might have been
staring me in the face, I'm thinking in particular of section 15.6.3 of
Andrew Pitonyak's OpenOffice.org Macros Explained, but I just didn't
understand it.

Can anyone provide guidance to display the autofilter values in a Calc
sheet equivalent to the instructions provided for Excel at the link above?

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

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

[Mike Flannigan]

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


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.



--
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] Updates change my spreadsheet row sizes

[Mike Flannigan]

This is the right place.  I suggest you record
the width of your columns now, and then again
after the next update to confirm they are changing
in width.


Mike



I hope this is the right group.

After every LibreOffice update I have to fiddle with my calc rows to 
get them to scroll right.  Is there a way to prevent this?



--
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] Polish diacritical marks

[Mike Flannigan]

Thanks for the notice.  Consider filing a bug report:
https://www.libreoffice.org/get-help/feedback/
It's certainly not easy, and I'm not sure I would do
it, but perhaps you are interested.


Mike


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


Hi,

  


I have found that LO ver. 7 not properly display Polish diacritical marks.

Such a problem is not encountered under ver. 6. Something is wrong.

I use WIN7 pro.



Best regards,

Vlk



--
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] Small OOoBean on Ubuntu

[Mike Flannigan]

I didn't do much research, but 10 years ago people
were saying it was dead:
https://stackoverflow.com/questions/4387622/ooobeans-dead-what-are-my-alternatives

I don't know if it revived since then.


Mike


I have successfully embedded libraOffice into our Java application using the
OOoBean which works fine on windows
After porting to Linux the bean is running but showing very small on Ubuntu
20 and 18, I have also tested it with
several versions of LO 7, 6.4 etc and the problem remains. openJava 11 and 8

I have reverted to the simple demo bean found at  OOoBeanViewer.java
   
which also fails to show correctly.


I find very little information about the OOoBean or people discussing it,
can anyone confirm if this is maintained
and if it currently works correctly on any Linux distribution.

Not sure if this should be in the DEV  mail list, but its not directly about
developing LO

.. Thanks.
 Simon



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