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 text output as an

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

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

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,

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.

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,

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

2023-04-29 Thread Michael H
> > > > 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: &g

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,

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 paid: Total c

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

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

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

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] Macros in spreadsheets

2023-01-02 Thread Michael H
Recalculate: Force recalculate - F9 by default, but could be reassigned. OR on the menu at Data --> Calculate --> Recalculate There's also "recalculate hard" which is (probably misunderstood by me) like the first calculate on load. CTRL-F9 or the same menu as recalculate. ___ Macros:

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

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

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

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

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

2022-05-08 Thread Michael H
w!!! 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 LibreOffice gets confused ab

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

Re: [libreoffice-users] Spreadsheet question

2022-03-13 Thread Michael H
H2,5,2),RIGHT(AH2,2)) > > C > > Time > > D > > 1631 > > 04:31:00 PM > > “=TIME(INT(AH4/100),MOD(AH4,100),0) > > E > > PM1.0 > > F > > 0 > > G > > PM2.5 > > H > > 0 > > I > > PM10 > > J > > 0

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

Re: [libreoffice-users] Cannot install a separator line above footnotes.

2021-12-29 Thread Michael H
I looked at the 'fresh" appimage, and it shows multiple line styles for footnotes. But the latest "fresh" app image I see is 7.2.0.4. Does your system display the styles when running The LO provides appimage? https://www.libreoffice.org/download/appimage/ If it does... the issue is likely

Re: [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP?

2021-12-19 Thread Michael H
t. On Sun, Dec 19, 2021 at 11:49 AM Michael H wrote: > and my 1st attempt at logic is horribly flawed for the DATE VALUE cells: > > <, >= should be > > - > Greater/less than option > =IF(A2>=DATE(21,10,8),IF(A2 > (I haven't

Re: [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP?

2021-12-19 Thread Michael H
and my 1st attempt at logic is horribly flawed for the DATE VALUE cells: <, >= should be - Greater/less than option =IF(A2>=DATE(21,10,8),IF(A2 wrote: > I've never tried it, but the ABS function on the Date Cell might also > work. > > IF

Re: [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP?

2021-12-19 Thread Michael H
I've never tried it, but the ABS function on the Date Cell might also work. IF (ABS(A2)=10/8/21,B2,"") -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP?

2021-12-19 Thread Michael H
-- =IF(LEFT(A2,10)=("2021-10-08"),B2,"") -- If you paste that formula into column E, you should have nulls where the date does not match and the value in Column B where the date matches. Note the above suggestion

Re: [libreoffice-users] Calc airithmetic snafu

2021-11-28 Thread Michael H
Re: Units out of the data. 1. The formula =Value(Left(C1,Find(" ",C1))) will be insensitive to longer--129.4 km-- or less specific--7 km-- distances. 2. When I remove units from a list, usually I'm working a large amount of data and find that the whole spreadsheet works better when source data

Re: [libreoffice-users] changing anchor of image drops me to end of document

2021-11-24 Thread Michael H
> > I am reformatting some documents to a larger print size. This involves > changing layout of pages and the requirement to perform some operations on > images. For each image, I need to turn off wrap, change the anchor point > from paragraph to character and then align middle to anchor. > Are

Re: [libreoffice-users] Correct documentation for V6.2 programs

2021-11-24 Thread Michael H
UltraOffice is not from LibreOffice. This question should be directed toward your source at UltraOffice that pointed you at the 6.2 version help files. But If you select Help-->About LibreOffice, you should see a version number. That number represents the version number which the help files are

[libreoffice-users] Restoring cursor position when document was last saved

2021-10-14 Thread H
I am running LO 5.3.6.1, the latest version available for CentOS 7. I have an "annoyance" where the cursor position when documents were last saved is not restored. Although it seems to work in Calc, it does not work in Writer nor in Impress. Is there a setting I have missed given the version I

Re: [libreoffice-users] Subject: LO does not run on Ubuntu 16.04

2021-10-09 Thread Michael H
Have you tried installing the flatpak version instead? My understanding is that flatpak includes the dependencies within the installation, instead of using the distro. It makes for a larger download, but reduces the likelihood of failure or taking weeks to get it to boot.

Re: [libreoffice-users] Update a mailmerge file

2021-08-15 Thread Michael H
(unrelated to your last comment.) I looked in the latest Writer manual, and there is no "updating the source" instruction for mail merge chapter. Considering "open Base first" is not exactly intuitive for making changes in Calc and seeing them in Writer... it possibly might be very helpful to

Re: [libreoffice-users] Update a mailmerge file

2021-08-15 Thread Michael H
Hi Robert, Thank you! Your hint worked, except 'refresh' had no effect, But the 2nd option on the arrow-circle button on the toolbar 'rebuild' did the job. I suspect thats because I had edited the source spreadsheet while Base was not open and added an empty first row to make it an index or key

[libreoffice-users] Update a mailmerge file

2021-08-15 Thread Michael H
Is there a way to dynamically set up a Calc->Base->Writer mail merge so that changes in Calc can be pushed through to Writer? I don't see how to do it. I've made a fairly complex mail merge file (some 25 fields). I added another 50ish items to the spreadsheet thinking I could refresh the mail

Re: [libreoffice-users] Quote marks

2021-08-06 Thread Michael H
tools > autocorrect options > localized options Do you see curly quotes or straight quotes for the replacements? You can disable autocorrect completely, just the quotes, or have it force straight quotes. Depending on where you cut paste from, the last option might help you best. On Fri, Aug 6,

Re: [libreoffice-users] Two parallel text flows in one document possible?

2021-04-16 Thread Michael H
I'll just throw in that I've tested this but found it didn't find to work well enough to use, but that's about footnotes.. both placement and numbering.) However, I tested this method, I found that defining three columns provided the control I needed for the gutter (area between the columns)

Re: [libreoffice-users] search for Asian font in English text

2021-04-14 Thread Michael H
t;regular" and size are > the same, > and if possible change their attributes (color, highlighting etc.). > > Searching the net, I found: > > https://ask.libreoffice.org/en/question/140748/how-do-i-search-for-a-specific-font-in-writer/ > "The Find and Replace dial

Re: [libreoffice-users] Odd line spacing

2021-02-01 Thread Michael H
John, I saw the problem when I tried to superscript. As far as I could tell, there is no concept of "baseline" grid that text returns to... once you get off the grid for whatever reason, it affects everything. In order to work around this, I did 3 things: 1. I forced the entire document onto a

Re: [libreoffice-users] What does LibreOffice recognize as a column delimiter?

2021-01-28 Thread Michael H
re: Field Separator The unicode tab (Ux0009) should be the best 'field separator.' re: Formatting. If this is like dictionary info (word, type, long definition) you should carefully consider making it paragraphs and separate those fields with a tab. If your data is more like a list (month,

Re: [libreoffice-users] If-exist condition for conditional text or section

2021-01-01 Thread Michael H
John, To follow up on the conditions aren't really conditional, but static states: I got as far as page 613 of the ODF 1.2 specification. (which used to be free from OASIS, but now costs chf198 from ISO.org.) it says "The text:condition attribute specifies a condition. Conditions do not have a

Re: [libreoffice-users] If-exist condition for conditional text or section

2021-01-01 Thread Michael H
I'm not sure what your use case is... (there's not much in your question about what you are trying to do) ...so I may be in the wrong postal code with this suggestion. I'm using mail merge, and I keep all 'conditions' outside the document itself. I studied the Opendocument elements and I've

Re: [libreoffice-users] Epson XP-820 paper size setup

2020-12-14 Thread Michael H
This isn't a solution, but have you tried printing the envelope page to PDF, then printing that with a PDF viewer? As far as I know Libreoffice does respect the page definition for PDF creation, then you can work around the lack of proper integration of the LO print dialogs to debian outside of

Re: [libreoffice-users] Writer: Fake vs. Real Superscripts in advanced fonts

2020-12-06 Thread Michael H
What you're looking for is the autocorrect autoreplacements table. Tools --> Autocorrect --> Autocorrect Options. Turn off the fake ordinals on the Localized options tab. Then you can add entries in the Replace tab for the values you want, like 1st -> 1ˢᵗ. There may be a way to introduce a

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

2020-11-29 Thread 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: >

Re: [libreoffice-users] Editing Impress Master Slides

2020-10-24 Thread Michael H
I think what you want is "clear direct formatting." In LO 6.3 this is on the right-click menu for each object in a page, but it doesn't show up when you have multiple objects selected, and it doesn't show up when you select the page on the page browser. It would be nice if 'clear local overrides'

Re: [libreoffice-users] defective field in header on one page

2020-08-02 Thread Michael H
In order to see better what's going on , you can save the file as .fodt and search for the name of the field that shows up in the header in a plain text editor and pay attention,looking especially for an extra set variable tag around the content that appears on page 36. Once you understand where

Re: [libreoffice-users] Add a bookmark to TOC

2020-08-02 Thread Michael H
Everyone, It was not my intention to force google accounts onto everyone. Google used to work in that "viewable by all" access was automatic when "get sharable link" was clicked. Now it's hidden in a tiny obscure looking click spot. However, after the feedback on the list, and the many access

Re: [libreoffice-users] Add a bookmark to TOC

2020-08-01 Thread Michael H
Instead of building the Table of contents by "paragraph style", create a Index of type "Table of Contents" using "Index marks". https://drive.google.com/file/d/1CArlrl1zeQAWGxWrGVbxmtVdgNNNjmz9/view?usp=sharing In the example I insert the mark after the first word (or number) of the new chapter,

Re: [libreoffice-users] Re: question

2020-07-28 Thread Michael H
I dealt with this on a calc workbook that has many (2-10 million) functions that span from one tab to another. On the Data Menu -> Calculate -> Autocalculate and ensure the checkmark next to autocalculate is off. After that performance should return to normal, but remember you have to press the

Re: [libreoffice-users] Multiple newlines

2020-07-21 Thread Michael H
r, ... > >> ... but stumbled on elementary problems in Find-&-Replace [Ctrl-H] > using regular expressions: > >> (1) "\n" is not found. Should not "\n" match one of the codes in > ? [If not, what code(s) should "\n" match?] > > > > F

Re: [libreoffice-users] Re: Understanding Character styles "Default Style" and relative font sizes

2020-07-11 Thread Michael H
John, The point I was trying to make is that you are discussing a named box in libreoffice, but then all the discussion is about putting a percent number into "Size" field of the Font tab. This is confusing. "Relative Font Size" is in use. I've been working around it not being able to go above

Re: [libreoffice-users] Re: Understanding Character styles "Default Style" and relative font sizes

2020-07-10 Thread Michael H
John, (and Mike,) I take a different approach to relative size. I needed to keep the relative size separate from the font size, so I use relative size in superscript/subscript. It's limited in it's functionality though (only allows shrinking.) but it serves it's purpose. That is, I set

Re: [libreoffice-users] Compatibility with markdown

2020-06-15 Thread H
On June 15, 2020 6:03:02 PM EDT, toki.kant...@gmail.com wrote: >On 2020/06/14 18:18, H wrote: >> I have been running LibreOffice under CentOS 7 for several years and >am a satisfied user. I would, however, very much like to have the >ability to both import and export documents

Re: [libreoffice-users] Compatibility with markdown

2020-06-14 Thread H
On 06/14/2020 03:48 PM, Tony Arnold wrote: > On Sun, 2020-06-14 at 14:18 -0400, H wrote: >> I have been running LibreOffice under CentOS 7 for several years and >> am a satisfied user. I would, however, very much like to have the >> ability to both import and export docu

Re: [libreoffice-users] Repeat a footnote

2020-06-14 Thread Michael H
just type the "1" then apply character style "Footnote Anchor" to it. [image: Screenshot from 2020-06-14 16-50-38.png] On Sun, Jun 14, 2020 at 4:37 PM John Jason Jordan wrote: > I created a footnote to define a term in a document. All went well, > except that the term occurs in more than one

[libreoffice-users] Compatibility with markdown

2020-06-14 Thread H
I have been running LibreOffice under CentOS 7 for several years and am a satisfied user. I would, however, very much like to have the ability to both import and export documents in the markdown-format, preferable the CommonMark flavor which also handles tables. When composing complex and/or

Re: [libreoffice-users] LO Styles organization

2020-05-05 Thread Michael H
I tried approaching this from the dialogs, and eventually gave up trying to map it back to the spec. However, when I found flat file format, I found that it's easier to understand how it works by opening the .fodt files in a plain text editor, and especially doing 'diff' style comparison between

Re: [libreoffice-users] Splitting columns in Calc

2020-04-21 Thread Michael H
A solution using the REGEX function can be viewed here: (Flat OpenDocument Spreadsheet format:) https://drive.google.com/open?id=13NsidjowVUqKWaUgsU-qL4gFQaP1BENg On my computer, Google Chrome shows you the source code for the file.. you need to save that link as an ".fods" file, then it will

Re: [libreoffice-users] Base...

2020-02-04 Thread Michael H
What you list for columns D, E, F, G,H,I are not tables. They are reports for the table "Reaction". Your primary data point is reaction. It has the parameters of actor and observer, date/time, location, and whatever ratings or review information. Then you build a report based on the

Re: [libreoffice-users] RE: Using Libre Writer - with hardware questions

2020-01-27 Thread Michael H
Hi Charles, Have you tried running LibreOffice as a portable app? I'm not sure if this will help or not, but it might exclude a few problems. Portable apps don't 'install' and are a little less dependant on the system settings. https://www.libreoffice.org/download/portable-versions/ If the

[libreoffice-users] LibreOffice 6.4.3

2020-01-26 Thread H. Stoellinger
Hello, I see that 6.4.3 is available. I cannot see any language versions. Am I missing something? Thanks for your help H. Stoellinger -- Gruesse aus Fuerstenbrunn -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists

Re: [libreoffice-users] Word counting in LO Writer

2019-12-19 Thread Michael H
For all purposes that matter (payment, thesis limits, etc.) doesn't the 5 characters per word rule still count? I guess if they are instead counting the word boundaries these days that could be 5, but if you submitted an invoice for it, 4 is correct, or if you're trying to achieve a word count for

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

2019-12-12 Thread Michael H
Generally, The following should work, but spelling or spacing differences won't be ignored. any difference in the name will be treated as a new reviewer. IF(A1=A2,B1+1,1) On Tue, Dec 10, 2019 at 10:51 PM zed wrote: > Hi! > > Using LibreOffice v6.0.7.3 on Linux Mint v19.2 Mate > > I have a

Re: [libreoffice-users] Retaining Graphics and Text intact into Writer

2019-11-19 Thread Michael H
Saving the website as a complete webpage (from google chrome for example) then importing that file into writer should be the closest to lossless.. It is important to note that many websites go to great lengths to protect their content from this type of infringement. So your frustration may be

Re: [libreoffice-users] Transparency issue saving to .doc/docx

2019-11-05 Thread Michael H
1. Condensing Fonts without installing a new font file: You should be able to scale the width of text to achieve a similar fit, that will survive transformation into MS Word. For every 10% reduction in character width, you'll need to make a slight increase in character spacing. That is in your

[libreoffice-users] Libreoffice extension XML tags

2019-07-15 Thread Michael H
I've got custom built files that are failing ODT validation. One of these failures is for loext:contextual-spacing Is there documentation similar to the ODF specification for Libre Office extensions? All I'm finding are discussions about the issue, and actual code that is apparently what's IN

Re: [libreoffice-users] AltGr functionality

2019-06-16 Thread Michael H
It's not just "the system." Your "keyboard setting" is a layered approach: BIOS, <- system kernel, <- startup daemons, <-display driver (x.org + Gnome, etc.) <- app. You need to work your way up the chain. Any keyboard setting at a higher level can override lower level settings. Also, you might

Re: [libreoffice-users] insert non-breaking semi-space

2019-06-15 Thread Michael H
The unicode character U202F Narrow Nobreak Space should produce the result you're looking for. I've tested LibreOffice (4.2?) functions properly. The font has to support it tho or you'll have a unprintable character glyph or wide space present depending on the view/program. If the font doesn't

Re: [libreoffice-users] Libreoffice corrupted by Ubuntu failed upgrade

2019-04-21 Thread Michael H
won't try to give you a detailed instruction, but once you have a new user account, and are sure it is the default user that will login when the system boots, "chown" is the secret to allow access to your older files. On Sun, Apr 21, 2019 at 11:10 AM Michael H wrote: > When I've had

Re: [libreoffice-users] Inserting a Trademark Symbol in Label

2019-04-02 Thread Michael H
:tm: is in the LibreOffice autocorrect database. colon-tm-colon (lower case matters.) should produce a TM logo if you have autocorrect enabled. On Tue, Apr 2, 2019 at 8:30 PM Alan B wrote: > The following won't help you see/find the symbol. It will however let you > type it directly. > > Put

Re: [libreoffice-users] Concatenate Function inCalc

2019-04-02 Thread Michael H
Why are we defending invalid output of a function? When I send invalid data like range to a function, say ABS(c1:c4), I expect it to return an error (#VALUE! comes up in linux). In linux on LO 6.0.7, I'm getting the 2nd value in the range as a valid output of the function CONCATENATE(C1:C4).

Re: [libreoffice-users] Concatenate Function inCalc

2019-04-02 Thread Michael H
CONCATENATE must either fail to accept ranges (with an error), or accept them and provide the combination that acceptance suggests. It is a bug that it accepts ranges, but returns something else. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] corrupt letter

2018-11-25 Thread Michael H
I had a problem similar to this on windows 98, after I installed a legal copy of word perfect and all 1100 fonts it came with. Apparently windows 98 had a limit of about 500 fonts ... and above that it would get confused after a while. However, more recently I used Ubuntu studio 12, which ships

Re: [libreoffice-users] Calc 6.0.6.2 IF criteria statement help

2018-11-10 Thread Michael H
I'm not sure I follow your logic, but if your source range contains a list of values that includes nulls, and non-numbers, you need to logically exclude those from a math statement, or you get the 'VALUE' error (tried to do math on a non-numeric cell.) ISBLANK, and ISNUMBER are functions that

[libreoffice-users] flat office validation

2018-11-02 Thread Michael H
I found a link to "officeotron" that looks pretty stale. https://gerrit.libreoffice.org/gitweb?p=officeotron.git;a=summary Is this still a working program? Is there a more recent version? I'm having issues building flat office documents from scratch for import into writer. I thought if it loaded

[libreoffice-users] Split Screen

2018-10-18 Thread H. Stoellinger
to another in Writer. Regards H. Stoellinger -- Gruesse aus Fuerstenbrunn -- 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

[libreoffice-users] Scaling print output

2018-10-16 Thread H. Stoellinger
that last column on an extra page 2. I want to scale the printout such that everything is printed on just ONE page. Is this possible in version 6.0.6.2 (Linux Mint 19.1) ? Or do I have to use a smaller font and smaller margins such that everything gets printed on page 1? Regards H. Stoellinger

Re: [libreoffice-users] Set JRE in LibreOffice

2018-05-26 Thread H. Stoellinger
rises tend to be used by more than just ONE application system... Just my two cents worth... Regards from Salzburg H. Stoellinger On 2018-05-26 21:15, Girvin Herr wrote: On 05/26/2018 02:59 AM, Tom Davies wrote: Hi :) Snip Base is supposed to MUCH better when using an external back-end - it's

[libreoffice-users] Size of tar-file of 6.0.0

2018-02-01 Thread H. Stoellinger
Hello guys, What is the reason why the tar-file for 6.0.0 is 204 MB, while 5.4.4 is 267MB in the case of Linux-debs... Just interested! Regards H. Stoellinger -- Gruesse aus Fuerstenbrunn -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https

Re: [libreoffice-users] Mysql Native Connector for LO 5.4

2017-09-11 Thread H. Stoellinger
parameter. Changing it such that the server also listens to "normal" TCP-IP connections has done the trick. I will keep on using JDBC till a viable native connector becomes available. Regards H. Stoellinger Am 2017-09-08 um 18:10 schrieb H. Stoellinger: Hello, I have been using LO-Bas

[libreoffice-users] Mysql Native Connector for LO 5.4

2017-09-08 Thread H. Stoellinger
for the good work and regards from Salzburg H. Stoellinger -- Gruesse aus Fuerstenbrunn -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

[libreoffice-users] Capitalized folder names in Linux LO

2017-08-18 Thread H. Stoellinger
ody else experienced this "weird" behaviour? Regards from sunny and very hot Salzburg H. Stoellinger -- Gruesse aus Fuerstenbrunn -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ P

Re: [libreoffice-users] m$ and munich

2017-02-17 Thread H. Stoellinger
r of Linux, LibreOffice, etc., etc., for lots of years... H. Stoellinger, Salzburg, Austria Am 2017-02-17 um 18:17 schrieb Tom Cloyd: You guys are missing something here. I don't have the link, but I read a news report on this (in The Guardian perhaps) which said that what had happened was that has be

Re: [libreoffice-users] in response ...

2017-02-02 Thread Charles-H. Schulz
Anne-ology, You are right, that is the general meaning of moderation. However, when we talk about moderation here, we talk about mailing list moderation. When we talk about moderator, we refer to a mailing list moderator, not to concepts such as panel moderators. A mailing list moderator has

Re: [libreoffice-users] in response ...

2017-01-31 Thread Charles-H. Schulz
Hello Tom, It seems that the problem Brian highlighted is a bit different and is a recurring one. Anne-ology does not seem to understand her exact role as a list moderator, even after years of being in that position. What she has to do is first to approve the message so that it can reach the

[libreoffice-users] Development-Snapshot (5.3.0.1.0-1) - Base

2017-01-09 Thread H. Stoellinger
way - 5.3 (under Linux-Mint 17.3) seems to run very fast! Super! Regards H. Stoellinger -- Gruesse aus Fuerstenbrunn -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines +

Re: [libreoffice-users] Missing file extension on saving

2016-12-01 Thread H. Stoellinger
Hello Brian, Thanks, on my Mint-System it HAD become un-ticked! It works fine after ticking it... Regards H. Stoellinger Am 2016-12-01 um 18:53 schrieb Brian Barker: At 17:28 01/12/2016 +0100, H. Stoellinger wrote: In the documentation I read that... " When saving a file, LibreOffice a

[libreoffice-users] Missing file extension on saving

2016-12-01 Thread H. Stoellinger
es NOT get appended to the filename automatically anymore. Is this "works as designed" or a bug? I can re-open the file correctly after saving it. Regards H. Stoellinger -- Gruesse aus Fuerstenbrunn -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www

Re: [libreoffice-users] Re: Transferring Markdown Documents to LibreOffice

2016-11-29 Thread H
On November 28, 2016 4:10:02 PM EST, James E Lang <je...@lang.hm> wrote: >I'm sorry. I had not seen your capitulation on that subject. > >-- >Jim > >-Original Message- >From: H <age...@meddatainc.com> >To: users@global.libreoffice.org >Se

Re: [libreoffice-users] Re: Transferring Markdown Documents to LibreOffice

2016-11-28 Thread H
On 11/28/2016 09:26 PM, James E. Lang wrote: As I understand it, H wants to convert markdown to odf AND BACK to markdown. Most of the messages in this thread are ignoring that last step. While it would be very nice to be able to revert to markdown, that may not be very workable

Re: [libreoffice-users] Re: Transferring Markdown Documents to LibreOffice

2016-11-28 Thread H
On 11/28/2016 06:44 PM, Cley Faye wrote: 2016-11-28 16:48 GMT+01:00 H <age...@meddatainc.com>: MultiMarkdown has been suggested by its author Fletcher Penney and it does sound interesting. Unfortunately I could not get it to work on the only Windows system I have - running Vista - an

Re: [libreoffice-users] Re: Transferring Markdown Documents to LibreOffice

2016-11-28 Thread H
On 11/28/2016 03:27 PM, Joshua Kramer wrote: There is a utility called MultiMarkdown that will write flat ODF files readable by LO. On Nov 28, 2016 8:34 AM, "H" <age...@meddatainc.com> wrote: On 11/28/2016 03:11 AM, Marc Paré wrote: Hi Tim Le 2016-11-27 à 18:02, T

Re: [libreoffice-users] Re: Transferring Markdown Documents to LibreOffice

2016-11-28 Thread H
On 11/28/2016 03:11 AM, Marc Paré wrote: Hi Tim Le 2016-11-27 à 18:02, Tim---Kracked_P_P---webmaster a écrit : Does CentOS 6.8 have access to the "ttf-mscorefonts-installer" package? This package includes Arial and Times New Roman and many of the core fonts you get with a Windows install. I

Re: [libreoffice-users] Transferring Markdown Documents to LibreOffice

2016-11-28 Thread H
On 11/28/2016 12:02 AM, Tim---Kracked_P_P---webmaster wrote: On 11/27/2016 04:37 PM, Charles-H. Schulz wrote: Hello, H. @ 2016-11-27 19:00 GMT: On 11/20/2016 03:13 PM, Ricardo wrote: El 2016-11-20 14:45, Virgil Arrington escribió: Since Markdown is a pure text file with formatting marks

Re: [libreoffice-users] Transferring Markdown Documents to LibreOffice

2016-11-28 Thread H
On 11/27/2016 10:37 PM, Charles-H. Schulz wrote: Hello, H. @ 2016-11-27 19:00 GMT: On 11/20/2016 03:13 PM, Ricardo wrote: El 2016-11-20 14:45, Virgil Arrington escribió: Since Markdown is a pure text file with formatting marks inserted, you could easily edit such a file with LO. It sounds

Re: [libreoffice-users] Transferring Markdown Documents to LibreOffice

2016-11-27 Thread Charles-H . Schulz
Hello, H. @ 2016-11-27 19:00 GMT: > On 11/20/2016 03:13 PM, Ricardo wrote: >> El 2016-11-20 14:45, Virgil Arrington escribió: >>> >>> >>> Since Markdown is a pure text file with formatting marks inserted, you >>> could easily edit such a fi

  1   2   3   4   >