Re: [libreoffice-users] Small OOoBean on Ubuntu

2020-11-28 Thread 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

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

2021-06-09 Thread 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

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

2021-06-13 Thread Mike Flannigan
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-uniq

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

2021-05-10 Thread 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

Re: [libreoffice-users] Polish diacritical marks

2021-02-09 Thread 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.

Re: [libreoffice-users] Updates change my spreadsheet row sizes

2021-02-14 Thread 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

[libreoffice-users] Re: Adapting row height is slow

2021-08-01 Thread 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

Re: [libreoffice-users] Re: Adapting row height is slow

2021-08-04 Thread Mike Flannigan
eet 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-he

Re: [libreoffice-users] Buy/Sell Calculation

2021-10-13 Thread 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

Re: [libreoffice-users] RE: LibreOffice to LyX

2021-10-05 Thread 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

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

2021-07-23 Thread 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,

[libreoffice-users] Extracting content out of table format received in an email

2022-02-23 Thread 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

Re: [libreoffice-users] problems on Ubuntu

2023-09-02 Thread 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?

Re: [libreoffice-users] Save and Edit Text document

2023-10-29 Thread Mike Flannigan
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

Re: [libreoffice-users] Save and Edit Text document

2023-10-29 Thread 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

Re: [libreoffice-users] Save and Edit Text document

2023-10-29 Thread 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

Re: [libreoffice-users] Question about LibreOffice Calc 7.4.7 and hidden columns

2023-08-18 Thread 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

Re: [libreoffice-users] Calc function COUNTA

2022-06-26 Thread 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:

Re: [libreoffice-users] Nested Drop-down List

2022-05-21 Thread 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

[libreoffice-users] Re: Adding Videos to Impress Presentation Not Possible

2022-05-07 Thread 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] Re: Opening new file from same path as current open document

2023-03-05 Thread 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

Re: [libreoffice-users] Importing a row from a spreadsheet

2023-04-29 Thread 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]

Re: [libreoffice-users] Insert Special Characters

2023-05-01 Thread 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:

Re: [libreoffice-users] Calc default font size

2023-05-22 Thread 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

Re: [libreoffice-users] How to unsubscribe

2023-05-28 Thread 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:

Re: [libreoffice-users] Reading a crash report

2023-07-22 Thread 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

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

2023-11-20 Thread 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

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

2024-03-19 Thread 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

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

2024-03-26 Thread 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: