Re: [libreoffice-users] vlookup help

2024-07-11 Thread Michael Tiernan
etters are, "A") ,4,1) (4 Means return the value as A8 instead of $A$8 and the 1 means say it as A8 instead of R8CA) ADDRESS( row, column, 4, 1 ) Now, treat all that as an address of a row and column. INDIRECT( address from above, 1 ) Go get the *VALUE* at that ad

Re: [libreoffice-users] vlookup help

2024-07-11 Thread Michael Tiernan
ution with the column fixed as "A" and use the value in "C" to refernce the row involved. See if that leads you to a solution? -- << MCT >> Michael C Tiernan.http://www.linkedin.com/in/mtiernan Non Impediti Ratione Cogatationis Women and cats will do

Re: [libreoffice-users] vlookup help

2024-06-22 Thread Michael D. Setzer II
fice.org/global/users/> Privacy > Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired)60; mailto:mi...@guam.net ; mailto:msetze...@gmail.com mailto:msetze...@gmx.com Guam - Wher

[libreoffice-users] Use of QR/Barcode insertion.

2024-06-03 Thread Michael Tiernan
I tell it to use the contents of a cell as the source of the graphic? (I have generated a series of values that I want to use to create a QR code for each one.) Thanks for everyone's time. -- << MCT >> Michael C Tiernan.http://www.linkedin.com/in/mtiernan Non Impediti R

[libreoffice-users] Looking for a designer experienced in LibreOffice Writer

2024-03-04 Thread Michael Müller
Looking for a designer experienced in LibreOffice Writer For 45 years, Michael Müller Verlag in Erlangen (Nuremberg) has been the driving force behind tailor-made travel guides. In our pursuit of staying at the forefront, we initiated a comprehensive digital transformation a few years ago

Re: [libreoffice-users] failed update attempts

2024-02-25 Thread Michael D. Setzer II
s://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net

[libreoffice-users] Re: Master document and styles.

2024-02-23 Thread 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 t

[libreoffice-users] Forum Signup Issues

2024-02-12 Thread Michael Venables
, Michael Venables Misspellings courtesy iOS 17.3.1 (21D61) -- 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

[libreoffice-users] Re: Master document and styles.

2024-01-31 Thread 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

Re: [libreoffice-users] Master document and styles.

2024-01-31 Thread Michael Tiernan
On Mon, Jan 15, 2024, 12:03 PM Wiebe van der Worp wrote: > On 14-01-2024 17:02, Michael Tiernan wrote: > > I have a master document which has a number of styles in it. > > > > I have a "Page/Section" template that I distribute to others to create > > s

[libreoffice-users] Master document and styles.

2024-01-14 Thread Michael Tiernan
ve also come to the opinion that the "smart" (*cough*) way for me to keep them all coordinated is to copy every style used in the docs into a new one with some prefix like "my" and use it on all styles in the doc such as "my  Default Paragraph" Thanks for everyones

Re: [libreoffice-users] Master document, internal link between documents and pdf

2024-01-14 Thread Michael Tiernan
), adding to the reference for "WAGO" in the "C" document something that may say something like see "WAGO on page XXX" where the XXX is where the finished document will put the reference to WAGO? Than ks for everyones time. -- << MCT >> Michael C Tiernan.

Re: [libreoffice-users] striping crlf

2024-01-03 Thread Michael D. Setzer II
t archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net

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

2023-10-29 Thread Michael H
And if you have an Iphone, Google Lens is built into the Google App, as far as I can tell. you want to find the 'text' mode. On Sun, Oct 29, 2023 at 7:40 PM Michael H wrote: > If you have a paper document you want to turn into text, and your scanner > doesn't give you tex

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

2023-10-29 Thread Michael H
If you have a paper document you want to turn into text, and your scanner doesn't give you text output as an option... you can download Google Lens and point your phone at the document and copy each page that way. But the copied text is in your phone, so you'll have to email it to a desktop or use

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

2023-10-25 Thread Michael H
That's going to be in the scanner software, which isn't part of LibreOffice. Further the best (free) solution depends on what operating system you are using. I looked and there isn't anything in LibreOffice Plugins, but there is an OCR helper listed in OpenOffice extensions. I don't know anythin

Re: [libreoffice-users] split a huge table in subtables (say on different sheets) and link some columns between these tables???

2023-10-03 Thread Michael H
If the 6 rows is constant, it seems much nicer to transpose the table into 6 columns by 50 rows. It might take a little adjustment, but most or all of the data should fit into a single screen that way. On Tue, Oct 3, 2023, 11:45 AM Uwe Brauer wrote: > Hi > > I am facing the following problem, I

Re: [libreoffice-users] text to date

2023-10-02 Thread Michael D. Setzer II
ist archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam

Re: [libreoffice-users] Calc: how to auto-increment sheet names in a cell formula?

2023-09-20 Thread Michael D. Setzer II
ch(document, ".uno:Copy", "", 0, Array()) rem -- dim args82(0) as new com.sun.star.beans.PropertyValue args82(0).Name = "Nr" args82(0).Value = 1 dispatcher.executeDispatch(document, &q

Re: [libreoffice-users] dbind-WARNING message.

2023-08-24 Thread Michael D. Setzer II
On 24 Aug 2023 at 20:23, Robert Großkopf wrote: Date sent: Thu, 24 Aug 2023 20:23:35 +0200 Subject:Re: [libreoffice-users] dbind-WARNING message. To: users@global.libreoffice.org From: Robert Großkopf > Hi Mich

[libreoffice-users] dbind-WARNING message.

2023-08-24 Thread Michael D. Setzer II
s_0.0: Permission denied File doesn't exist in ~/.cache directory? File in /root is an empty file? +----+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mai

[libreoffice-users] Question on better way for forumula with ods that auto imports csv file.

2023-07-22 Thread Michael D. Setzer II
"A"&ROW())-INDIRECT("A"&ROW()-1),0) +----+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins

Re: [libreoffice-users] optimal width always

2023-07-12 Thread Michael H
"function" here would mean an action somewhat related to the advertisement in the menu name. What exactly does "select the entire sheet" have to do with "optimal width"? From outside the discussion, it seems like you're confusing "function" with "bug". Seems normal for LibreOffice these days. O

Re: [libreoffice-users] Writer- find and replace a number

2023-06-30 Thread Michael D. Setzer II
, > >> > >> 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.doc

Re: [libreoffice-users] Is there a way to have cell format remain with an external link??

2023-05-18 Thread Michael D. Setzer II
an external link?? Copies to: "Michael D. Setzer II" > At 00:45 19/05/2023 +1000, Michael D. Setzer II wrote: > >Have a spreadsheet that has internal link that is updated on > >loading. 6 of the columns have numbers with either 1 or 2 decimal > >places

[libreoffice-users] Is there a way to have cell format remain with an external link??

2023-05-18 Thread Michael D. Setzer II
. ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforg

Re: [libreoffice-users] Insert Special Characters

2023-04-30 Thread Michael H
What determines whether a change like this is a good idea? I mean, I see over time lots of discussion about implemented changes that seem to have huge retrograde effects on the ability to create, and only make sense in the terms of UI or ease of maintenance. (Or if you want to go a step further, o

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

2023-04-29 Thread Michael H
The way I approach this is to "mail merge" the information into a template document. "Mail merge" is missnamed.. it's really a data query. This isn't a process that can be well-described in a mail message in this thread. You'll need to watch videos about it or get a book that covers it. But I use

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

2023-04-28 Thread 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. ... >

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

2023-04-28 Thread 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.

[libreoffice-users] [writer] bullets numbering

2023-04-28 Thread Michael Powell
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

Re: [libreoffice-users] Mail Merge Label Problem

2023-04-11 Thread Michael H
Good news is that I made mailmerge work in 6.4, so it is possible. However, the ONLY way i see to make it work is to start with a calc spreadsheet not a database, and then register that Calc spreadsheet AS a database, and then do the mailmerge with all three programs open (Calc spreadsheet, Libr

[libreoffice-users] Actual bug report.

2023-04-10 Thread Michael Tiernan
27;t want. That gives us this screen: https://www.dropbox.com/s/bi3ec5snrf2shht/MCT_Screenshot_20230410_084805_P2.png?dl=0 On this screen, I tried to resize the "Query Wizard" screen to be wider so that I can read the field names and I can't. That's the bug. -- <&

[libreoffice-users] Quirky behavior report....

2023-04-10 Thread Michael Tiernan
external display and it stays and I can move it to the laptop screen without any problems. -- << 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

Re: [libreoffice-users] LO Writer word counts.

2023-03-25 Thread Michael H
corrected formula: 60 * 28 * 20 / 5 = 6720 words On Sat, Mar 25, 2023 at 10:42 AM Michael H wrote: > In a 1980 typing class, a 'word' (as in WPM) was defined as 5 characters > typed without spelling errors. At the time that is how anyone paid by the > word got pai

Re: [libreoffice-users] LO Writer word counts.

2023-03-25 Thread Michael H
In a 1980 typing class, a 'word' (as in WPM) was defined as 5 characters typed without spelling errors. At the time that is how anyone paid by the word got paid: Total characters divided by 5 - errors detected. = paid words. And we used line length and lines per page to calculate total characters,

Re: [libreoffice-users] Function acting on range

2023-03-16 Thread Michael D. Setzer II
On 16 Mar 2023 at 23:29, Regina Henschel wrote: Subject:Re: [libreoffice-users] Function acting on range To: users@global.libreoffice.org From: Regina Henschel Date sent: Thu, 16 Mar 2023 23:29:10 +0100 > Hi Mich

Re: [libreoffice-users] Function acting on range

2023-03-16 Thread Michael D. Setzer II
://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.

Re: [libreoffice-users] Function acting on range

2023-03-16 Thread Michael H
I was able to accomplish array math by clicking on the fx button on the row above the letters naming columns, then click the array checkbox in the lower left of the function wizard dialog box. After that the function listing shows {} around the function, but you can't type that in to get the array

Re: [libreoffice-users] Function acting on range

2023-03-15 Thread Michael D. Setzer II
iquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net

Re: [libreoffice-users] IBM Line Drawing Font

2023-03-03 Thread Michael H
'Extended ASCII' Included things like accented vowels . ANSI aka Windows Code Page 1251 included box drawing characters that were used pretty widely in the USA pre-windows on DOS. Most of the Windows Box drawing glyphs are now in the Unicode Box Drawing U+2500 - U+2550. [image: Screenshot from 20

Re: [libreoffice-users] LibreOffice parent company

2023-02-18 Thread Michael H
Star Division. On Sat, Feb 18, 2023 at 6:37 AM 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

Re: [libreoffice-users] Rotating labels to landscape

2023-02-12 Thread Michael H
I don't understand why you would not use a 4 card (2x2) to 1 letter or a4 page layout instead of a 3x1 layout. It seems a waste of material to me. 2x2 in portrait mode letter or a4 page = 4 Qty, 3x5 portrait when cut. Those 1x3 layouts were about continuous feed dot matrix printers with fanfold,

Re: [libreoffice-users] RPM upgrade 7.4 to 7.5

2023-02-03 Thread Michael D. Setzer II
say would be seen as an upgrade. > > This means it is easy to swap back from say 7.4 to 7.3 if you strike a > bug that is a show stopper for you while you wait for the bug > resolution, as I have had on a few occasions. > Steve > > On 04/02/2023 01:28, Michael D. Setzer

Re: [libreoffice-users] RPM upgrade 7.4 to 7.5

2023-02-03 Thread Michael D. Setzer II
gt; --- > Lee > > On Fri, Feb 3, 2023 at 3:53 PM Michael D. Setzer II > wrote: > > > On 3 Feb 2023 at 12:20, Lee Thomas Stephen wrote: > > > > From: Lee Thomas Stephen > > > > Date sent: Fri, 3 Feb 2023 1

Re: [libreoffice-users] RPM upgrade 7.4 to 7.5

2023-02-03 Thread Michael D. Setzer II
ttps://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net

Re: [libreoffice-users] Macros in spreadsheets

2023-01-02 Thread Michael H
___ Macros: Tools --> options --> Libreoffice --> Security --> Macro Security On Fri, Dec 23, 2022 at 9:51 AM Michael Tiernan wrote: > I have a couple of BASIC macros in a spreadsheet. > > I keep thinking that there must be a "init" function th

Re: [libreoffice-users] Macros in spreadsheets

2023-01-02 Thread Michael Tiernan
acros when the document is opened. So, that leads to, am *I* doing something wrong? Thanks for everyone's time. -- << 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 sh

[libreoffice-users] Macros in spreadsheets

2022-12-23 Thread Michael Tiernan
ress, not how to create a macro but how to incorporate it to become automatic? Thanks. -- << 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

Re: [libreoffice-users] Weird line-wrap problem in Writer

2022-11-28 Thread Michael H
There is no image attached. However, I've had similar wrapping issues in LibreOffice 6.3 with material I generate automatically when I set hyphenation to OFF, then turn every space into a no-break space. I don't see how that could happen while 'typing' but I have seen the issue, and you fix it by

Re: [libreoffice-users] how to prevent conversion to hyperlink

2022-11-06 Thread Michael H
To remove a single link as you type: after typing the email address, hit space, then ctrl-z. To stop this behavior in Calc, you can toggle URL Recognition on the Option tab in Autocorrect settings found in the Tools menu will prevent Calc from converting any URL which includes more than http web a

Re: [libreoffice-users] Python UNO odt to pdf converter - running time issue

2022-11-04 Thread Michael H
1. you ask about a python timing. but don't state specifically whether it's python 2, or python 3, or mixed between machines. That especially would be my focus, on the python execution and exactly what modules are in place and are they all from the same sources. (That is, that would seem to be the

Re: [libreoffice-users] Closing and reopening Writer - ver 7.4.1.1

2022-09-19 Thread Michael D. Setzer II
elines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > ++ Michael D. Setzer II - Computer Science Instructor (

Re: [libreoffice-users] certificate undetect

2022-09-05 Thread Michael H
According to this thread, There are Libreoffice versions on both the Microsoft and Mac software stores: https://ask.libreoffice.org/t/is-libreoffice-officially-in-the-windows-store/34578/2 Installing those versions should not have any issues with security certificates. I don't really keep up with

Re: [libreoffice-users] possible to know still or fresh looking at version number?

2022-09-04 Thread Michael D. Setzer II
gt; Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Comp

Re: [libreoffice-users] "reverse solidus" not working in the find dialog box

2022-08-15 Thread Michael D. Setzer II
ibreOffice Användare > Den mån 15 aug. 2022 kl 13:38 skrev Michael D. Setzer II < > msetze...@gmail.com>: > > > In Linux that are a number of option using standard > > commands. > > > > I think he said he's on Windows, actually. > Yes, but mentioned

Re: [libreoffice-users] "reverse solidus" not working in the find dialog box

2022-08-15 Thread Michael D. Setzer II
subscribe 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/

Re: [libreoffice-users] "reverse solidus" not working in the find dialog box

2022-08-15 Thread Michael D. Setzer II
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] multiplying time

2022-08-13 Thread Michael D. Setzer II
ubject: ;Re: [libreoffice-users] multiplying time To: 0;msetze...@gmail.com > On 8/8/2022 10:46 AM, Michael D. Setzer II wrote:> > If I understand > what you are looking at.> > With A1 having 8:45 > > B1 having A1/time(1,0,0) > > B1 would have decimal equivalent of time in hou

Re: [libreoffice-users] VLOOKUP Syntax to find MAX on a particular date

2022-08-08 Thread Michael D. Setzer II
.. > > -- > 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.li

Re: [libreoffice-users] multiplying time

2022-08-08 Thread Michael D. Setzer II
foundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy +----+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:m

Re: [libreoffice-users] scalc: (auto) wrap all cells per default

2022-07-27 Thread Michael H
You can select entire sheets, then set autowrap. You'll have to do this once per sheet, but that shouldn't be too much. On the Right side of the screen you should see the "Navigator". In the "styles" tab of the Navigator, you should see "Default" at the top. right click on that. But that won't a

[libreoffice-users] Searching for info gives nothing related to what I need?

2022-07-24 Thread Michael D. Setzer II
ubject="&subject$&"&body=SENDING%20"& mid(Path$,8,100) shell(cmd$) Else Print "The document has not yet been stored" End If End Sub ++ Michael D. Setzer II - Computer Science

Re: [libreoffice-users] LO W short line

2022-07-21 Thread Michael D. Setzer II
fice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day B

Re: [libreoffice-users] Tried send email with strace

2022-07-19 Thread Michael D. Setzer II
Bergmann > On 7/19/22 00:07, Michael D. Setzer II wrote: > > Found some code at end of strace > > > > (soffice:166273): GLib-GObject-WARNING **: 07:19:47.960: invalid cast from > > 'GtkBox' to 'GtkMenuShell' > > > > (soffice:166273

[libreoffice-users] Send email option - more info?

2022-07-18 Thread Michael D. Setzer II
eems to be dated back to 2010?? But interesting. My macro seems to work, and perhaps someone has detailed option of the WSENDTO beyond just sending filename. Sometime things showed up in To: or Subject: lines, so must be something. +--

[libreoffice-users] Tried send email with strace

2022-07-18 Thread Michael D. Setzer II
t/output error failed to open Mail Reader?? So, not sure why the libreoffice is calling xdg-email or why the xdg-email doesn't link the filename passed without the --attach or if there is suppose to be an xdg-email-hook.sh somewhere? dnf failed to find anything that includes it? +-

Re: [libreoffice-users] Question on send to email option in linux..

2022-07-18 Thread Michael D. Setzer II
:35, Michael D. Setzer II wrote: > > Thanks for the reply. I have LibreOffice 7.2.7.2 version as > > loaded by default for my Fedora 35 and also have > > LibreOffice 7.3.4.2 downloaded from libreoffice. > > > > With both I have tried a simple saved file with the word &g

Re: [libreoffice-users] Question on send to email option in linux..

2022-07-18 Thread Michael D. Setzer II
ow on screen, but nothing. The macro calls same program and takes the passed parameter, and does trim the FILE:// off the parameter. > Philip > > On 18/07/2022 12:14, Michael D. Setzer II wrote: > > Was trying to get the option to work, but after setting the > > program for

[libreoffice-users] Question on send to email option in linux..

2022-07-18 Thread Michael D. Setzer II
E is the mapi client that works in windows and works from firefox. Surprized that nothing shows with libreoffice. Thanks. +--------+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net

Re: [libreoffice-users] ReDim Preserve (BASIC macro programming)

2022-07-10 Thread Michael D. Setzer II
ubscribe 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/

Re: [libreoffice-users] Calc function COUNTA

2022-06-25 Thread Michael D. Setzer II
t-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] ROUND function consistency

2022-06-05 Thread Michael D. Setzer II
ers] ROUND function consistency To: 0;LibreOffice Användare > Den sön 5 juni 2022 kl 11:55 skrev Michael D. Setzer II <;msetze...@gmail.com > >: > > > One windows excell page mentions that it uses the > > banking rounding method, which I believe is the round to > > near

Re: [libreoffice-users] ROUND function consistency

2022-06-05 Thread Michael H
Are you sure it isn't somewhere else? I.e. the input to the actual round step from the vb and the LO function? LO automatically shortens numbers and rounds them as it does so... so a that shows 12.15 may actually contain 12.1499 or 12.151 On Sat, Jun 4, 2022 at 9:45 PM Steve Edmonds wro

Re: [libreoffice-users] ROUND function consistency

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

Re: [libreoffice-users] In Calc, Window sizing impairment

2022-05-08 Thread Michael H
s sense > now!!! And it worked! > > On Sun, May 8, 2022 at 10:59 AM Michael H wrote: > >> In cinnamon desktop or all of linux, there's some bug in linux or >> LibreOffice that the window size becomes zero pixels wide and zero pixels >> tall if the system or LibreOff

Re: [libreoffice-users] In Calc, Window sizing impairment

2022-05-08 Thread Michael H
In cinnamon desktop or all of linux, there's some bug in linux or LibreOffice that the window size becomes zero pixels wide and zero pixels tall if the system or LibreOffice gets confused about what the non maximized window size should be. press Alt-spacebar to see a menu where this zero size wind

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

2022-05-04 Thread Michael D. Setzer II
requires manually FORMAT/CONDITIONAL/MANAGE/EDIT/CELL RANGE to change it. So 4 clicks change range and two OK clicks. Not a big deal, but wondering why range changes, or why absolute or range name is not an option?? > Hope this helps. > > > On 5/3/22 04:33, Michael D. Setzer II wrote:

[libreoffice-users] Re: LibreOffice Impress sounds or music

2022-04-22 Thread Michael Powell
lide(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 t

[libreoffice-users] Re: LibreOffice Impress sounds or music

2022-04-20 Thread Michael Powell
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? Th

Re: [libreoffice-users] Clearing formatting.

2022-04-07 Thread Michael D. Setzer II
abel type? +----+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net   ; mailto:msetze...@gmail.com Guam - Where America's Day Begins  G4L Disk Imaging Project maintainer http://sourceforge.n

Re: [libreoffice-users] Clearing formatting.

2022-04-07 Thread Michael D. Setzer II
would > expect this to become a number format, but LO inserts the ' so it > becomes '123.00 and changes the cell format to number but forcing the > contents to remain as text. > >  From this point my question arose as to how to remove the ' so the > contents of t

Re: [libreoffice-users] Clearing formatting.

2022-04-06 Thread Michael D. Setzer II
ront, it shows that value as a text field and is left justified.. On 6 Apr 2022 at 10:58, Michael D. Setzer II wrote: From: "Michael D. Setzer II" To: Steve Edmonds , users@global.libreoffice.org Date sent:

[libreoffice-users] Proper forum for feedback.

2022-04-06 Thread Michael Tiernan
time. -- << 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 t

Re: [libreoffice-users] Clearing formatting.

2022-04-05 Thread Michael D. Setzer II
undation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/> Privacy > Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto

Re: [libreoffice-users] Off Line Help Installation

2022-03-22 Thread Michael D. Setzer II
elines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instru

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

2022-03-17 Thread Michael D. Setzer II
g/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.ne

Re: [libreoffice-users] orientating a right-angled triangle.

2022-03-16 Thread Michael D. Setzer II
On 16 Mar 2022 at 21:04, Ian Graham wrote: Date sent:60;Wed, 16 Mar 2022 21:04:28 + From:  Ian Graham Subject: ;[libreoffice-users] orientating a right-angled triangle. To: 0;users@global.libreoffice.org > I feel as if I must be being incredibly stupid, but I'm trying to draw a > right-an

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

2022-03-16 Thread Michael D. Setzer II
d maximum) of occurrences of the regular expression term immediately preceding it that can be present for a match to occur. (The maximum number of occurrences is limited only by the size of the document). For example, "tre{2,}" matches "tree", "treee", and "tre".

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

2022-03-16 Thread Michael D. Setzer II
t is clear $ will only remove 1 space at end of line {1,}$ or [:space:]{1,}$ will remove all spaces 1 to whatever. > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https

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

2022-03-16 Thread Michael D. Setzer II
s + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired)

Re: [libreoffice-users] Spreadsheet question

2022-03-13 Thread Michael D. Setzer II
date and time to date and time values. On 13 Mar 2022 at 11:03, Michael H wrote: From: Michael H Date sent: Sun, 13 Mar 2022 11:03:32 -0500 Subject:Re: [libreoffice-users] Spreadsheet question To: "Rogier F. van Vlissingen" Copies to: "Micha

Re: [libreoffice-users] Spreadsheet question

2022-03-13 Thread Michael H
; indeed it came out better in your case, so there must be some subtle > mistake some place. I will have to repeat the process and figure that out. > > Thanks so much. > > On Sun, Mar 13, 2022 at 10:00 AM Michael D. Setzer II > > wrote: > > > Not clear on how you got that

Re: [libreoffice-users] Spreadsheet question

2022-03-13 Thread Michael D. Setzer II
3 Mar 2022 at 9:30, Rogier F. van Vlissingen wrote: From:  "Rogier F. van Vlissingen" Date sent:60;Sun, 13 Mar 2022 09:30:49 -0400 Subject: ;Re: [libreoffice-users] Spreadsheet question To: 0;"Michael D. Setzer II" Copies to:60;users@global.libreoffice.org > Funny compli

Re: [libreoffice-users] Spreadsheet question

2022-03-13 Thread Michael D. Setzer II
The spreadsheet I sent gave columns A thru AB, but some may not have separated exactly correct. Not knowing exactly what changes would be needed. Started by inserting a row at top. To convert date to an actual date field. In ad1 put B. In ad2 put this formula to make a date. =DATE(LEFT(B2,4),MI

Re: [libreoffice-users] Spreadsheet question

2022-03-13 Thread Michael D. Setzer II
; >> > >> in column 2 and drag right for ten columns and down. > >> > >> David Lynch > >> > >> > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-li

Re: [libreoffice-users] Make 4 Sheet in Libre Writer

2022-03-06 Thread Michael H
There are tools designed to make posters out of multiple pieces of paper like this. LibreOffice Writer is not the first thing I'd try for this. None of the LibreOffice apps are good fits, but LibreOffice Draw would come closest. Make 1 image span 4 pages in LibreOffice Draw: 1. Create a new Drawin

Re: [libreoffice-users] LibreOffice 7.3 not working on Fedora 34??

2022-02-07 Thread Michael D. Setzer II
On 7 Feb 2022 at 21:24, Andrew Pitonyak wrote: From: "Andrew Pitonyak" Date sent: Mon, 07 Feb 2022 21:24:32 -0500 Copies to: "Dave Barton" , users@global.libreoffice.org To: "Michael D. Setzer II"

Re: [libreoffice-users] LibreOffice 7.3 not working on Fedora 34??

2022-02-07 Thread Michael D. Setzer II
ste Faure wrote: > > Hi, > > > > Le 03/02/2022 à 10:56, Michael D. Setzer II a écrit : > >> Yesterday, Downloaded and installed and it reports a > >> crash, but just gives option to submit it, but no details. > >> Come up in safe mode, but opening ca

Re: [libreoffice-users] LibreOffice 7.3 not working on Fedora 34??

2022-02-07 Thread Michael D. Setzer II
Hi Michael, > > > > One of the messages talks about a version 7.3.0.3 that > > works, but I can't seem to find it on any of the links. > > Perhaps it fixed this issue, but caused others?? > > Have a look here: https://dev-builds.libreoffice.org/pre-releases/ >

  1   2   3   4   5   >