Re: [libreoffice-users] Save and Edit Text document
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 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 another editor like google docs or calibra office to paste > into, then open that with libreoffice. But saving files as PDF isn't > good. PDF is a final output, used to make it hard for other people to edit > the file. That's the whole point of PDF, and why it's used so commonly for > finished work. use ODT format for libreoffice... you'll save yourself a lot > of headache. but when you send it, you do need to output it to another > form, PDF is best, but you can use .doc or .docx . but MS formats aren't > intended to be the working format for libreoffice, but a way to exchange > information to non-informed users. > > > > On Sun, Oct 29, 2023 at 7:33 PM Mike Flannigan wrote: > >> >> >> 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 >> > -- 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
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 another editor like google docs or calibra office to paste into, then open that with libreoffice. But saving files as PDF isn't good. PDF is a final output, used to make it hard for other people to edit the file. That's the whole point of PDF, and why it's used so commonly for finished work. use ODT format for libreoffice... you'll save yourself a lot of headache. but when you send it, you do need to output it to another form, PDF is best, but you can use .doc or .docx . but MS formats aren't intended to be the working format for libreoffice, but a way to exchange information to non-informed users. On Sun, Oct 29, 2023 at 7:33 PM Mike Flannigan wrote: > > > 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 > -- 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
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 anything about it, but the last time I tried the extensions in OpenOffice didn't work out for me. There was a time (maybe OpenOffice 2.3?) where Dragon (Naturally Speaking) had an extension that did voice recognition and tied into scanning software I had with a (now 20 years ago) epson all-in-one. But even then the OCR (turn image into text) was almost certainly provided by the printer/scanner software, and not the plugin. What you've described (in the other email) suggests that after an upgrade, the scanner is using a windows provided driver, and not the drive that came with the scanner. You should seek that drive and the related software that does OCR from the manufacturer. It's likely it is no longer supported. I would NOT download drivers from anywhere except the manufacturer sight. The real drivers are out there, but so are 1000 other malware fakes for every real driver. telling them apart basically requires sacrificing a test computer until you find the real one. This is assuming you're on windows. On Wed, Oct 25, 2023 at 11:57 AM Kenneth Groninga < winema...@eaglecitywinery.com> 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 > -- 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] split a huge table in subtables (say on different sheets) and link some columns between these tables???
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 work with a table with 6 rows but > 56 columns. Of course I can hide some columns but I find this not very > comfortable. > So the question is can I split this table say in 8 tales, each with 7 > columns. > > In each table the last column gives me a result of certain operation, > say > > #+begin_src > #+Name: table1 > | Name | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh1 | > |---+-+-+-+-+-+| > | Smith | 2 | 3 | 4 | 6 | 7 | 22 | > #+TBLFM: $7=vsum($2..$6);f2 > > #+Name: table2 > | Name | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh2 | > |---+-+-+-+-+-+| > | Smith | 1 | 3 | 5 | 8 | 9 | 26 | > #+TBLFM: $7=vsum($2..$6);f2 > > #+Name: final > | Name | ResSh1 | ResSh2 | Total | > |---+++---| > | smith | 22 | 26 | 48| > #+TBLFM: $4=vsum($2..$3);f2 > > #+end_src > > > So that every time I actualise any column in any table, that > table gets updated and the final one > > Is this possible. It is possible in emacs org mode with its table > spreadsheet, however my colleagues use either LO or Excel, so it would > be great if this were possible. > > BTW is html mail possible/allowd on this lis?t (that would simplify the > display of my tables) > > Thanks and regards > > Uwe Brauer > > -- > Warning: Content may be disturbing to some audiences > I strongly condemn Putin's war of aggression against Ukraine. > I support to deliver weapons to Ukraine's military. > I support the NATO membership of Ukraine. > I support the EU membership of Ukraine. > > https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/ > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] optimal width always
"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.
On Wed, Jul 12, 2023 at 4:19 AM Brad Rogers wrote:
> On Wed, 12 Jul 2023 11:13:41 +0200
> hw wrote:
>
> Hello hw,
>
> >field at the top left sets all columns to optimal width. That field
> >currently has no function at all.
>
> It selects the entire sheet. Of little use, perhaps, but that certainly
> isn't 'no function at all.'
>
> --
> Regards _ "Valid sig separator is {dash}{dash}{space}"
> / ) "The blindingly obvious is never immediately apparent"
> / _)rad "Is it only me that has a working delete key?"
> Just stop and take a second
> U & Ur Hand - P!nk
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Insert Special Characters
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, only makes sense for spies from a competing product to insert to break the user base I don't mean this specific change... just the area of "why did it work before and now doesn't?" changes that are intentionally created.) Is there any forward looking consideration to these discussions that complain about already implemented changes being so awful? Is anyone doing a learning check on successful changes that generate these kind of complaints? The lack of control on what gets changed seems to be the undoing of the app. On Sun, Apr 30, 2023 at 11:41 AM wrote: > Hi Jonathan, > > I think they changed it to make it easier. > >Double-click on a special character will insert it into the document.< > > See also: > https://help.libreoffice.org/latest/en-GB/text/shared/01/0410.html > > Kind regards > Harald > > Am 30.04.2023 um 18:32 schrieb Jonathan Allen: > > Hi, > > > > I have just taken an upgrde (with Linux Mint) from LO 5.something to > > 7.3.7.2. Lots of good things, but I'm really upset about the way > > Insert Special Characters has changed. I used to be able to enter > > a long string (one or more words) in Hebrew or Greek characters, > > with them being compiled in a box below the character set, then hit > > 'insert' to put the whole thing into my document. Now, it seems as > > though I have to do it one character at a time, which is much more > > time-consuming. If there any way to get the old behaviour? > > > > 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 > -- 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
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 this type information to build book covers, including up to 7 paragraph back cover copy taking up ~5000 characters. each cell's column has a label, each label becomes a token that can be treated as an inline text object, which then gets merged (replaced) with the contects of the row of the spreadsheet. On Sat, Apr 29, 2023 at 5:46 AM Mike Flannigan wrote: > > 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 > -- 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] Mail Merge Label Problem
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, LibreOffice Base, and finally the merge writer file.) On Tue, Apr 11, 2023 at 4:56 PM Matt Brown <6bro...@gmail.com> wrote: > Good day, > > We are trying to generate labels from the Mail Merge component of > Libreoffice 7.2. We can work through the mail merge system however for > some reason the Mail Merge can't locate a Database to pull the contact > information from. Is there someone we can talk with directly to help us > troubleshoot this issue? > > Thanks. > > Matt Brown > 260.220.8947 > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] LO Writer word counts.
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 characters divided by 5 - errors detected. = paid > words. And we used line length and lines per page to calculate total > characters, not actually counting them. That is, on a Pica typewriter: 60 > characters per row * 28 rows per page * 20 pages * 32 lines per page = > 33600 words. > > > On Sat, Mar 25, 2023 at 10:25 AM W. Robert J. Funnell, Prof. < > robert.funn...@mcgill.ca> wrote: > >> Chris - >> >> Were your asterisks separated by spaces? My impression is that any >> character(s) delimited by white space will be counted as a word. >> >> - Robert >> >> >> From: Chris J. >> Sent: March 25, 2023 11:00 >> To: lo user help >> Cc: Chris Johnson >> Subject: [libreoffice-users] LO Writer word counts. >> >> I've known for a while now that LO Writer's words counts and MS Word >> counts are close but not the same. I was entering an asterisked scene >> break just now and noticed the word count increased by three. A little >> experimenting revealed that Writer counted three asterisks as words. >> This would account for some of the differing word counts between the >> two. I've noticed it happening in other areas I haven't narrowed down yet. >> >> >> What all exactly does LO Writer count as words? To a story writer words >> counts mean something. >> >> >> 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 >> >> -- 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] LO Writer word counts.
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, not actually counting them. That is, on a Pica typewriter: 60 characters per row * 28 rows per page * 20 pages * 32 lines per page = 33600 words. On Sat, Mar 25, 2023 at 10:25 AM W. Robert J. Funnell, Prof. < robert.funn...@mcgill.ca> wrote: > Chris - > > Were your asterisks separated by spaces? My impression is that any > character(s) delimited by white space will be counted as a word. > > - Robert > > > From: Chris J. > Sent: March 25, 2023 11:00 > To: lo user help > Cc: Chris Johnson > Subject: [libreoffice-users] LO Writer word counts. > > I've known for a while now that LO Writer's words counts and MS Word > counts are close but not the same. I was entering an asterisked scene > break just now and noticed the word count increased by three. A little > experimenting revealed that Writer counted three asterisks as words. > This would account for some of the differing word counts between the > two. I've noticed it happening in other areas I haven't narrowed down yet. > > > What all exactly does LO Writer count as words? To a story writer words > counts mean something. > > > 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 > > -- 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] Function acting on range
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 checkbox turned on.
And the actual difference in the file is a couple opendocument XML
functions I'd never heard of "numberarray in x" and "number array in y" but
that's not how they are spelled.
[image: Screenshot from 2023-03-16 16-12-32.png]
--
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] IBM Line Drawing Font
'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 2023-03-03 16-49-13.png] However, Accessing these unicode glyphs don't have equivalent means to render them like in the DOS days. You can't spell them out then convert them to drawing, nor can you use Alt- or Alt-shift alphabet keys to access them like in the DOS era. You'll have to find an 'ascii draw' app that has them in its palette. I don't have windows installed, but I see Arial has the unicode box drawing glyphs. as does Deja Vu Monospace. So if you have Arial monospace or find Deja Vu Monospace, either will have the box drawing set , and they will align like monospace fonts. I just don't know a program to suggest that will allow you to access these glyphs like you could in Wordstar for DOS. On Fri, Mar 3, 2023 at 4:41 PM Carter Campbell wrote: > Hi John; > > I think what you are referring to used to be called the ASCII Extended > Character Set. This included characters that could be used to draw > boxes and things on a screen or page. > > You can find a listing of the codes here: https://theasciicode.com.ar/ > > You could also find it in the MS Gothic font (if you are running > Windows). The characters are often towards the upper limit of the font > codes. > > Hope this helps. > > Carter > > > Hi John, > > > > John R. Sowden schrieb am 03.03.2023 um 21:23: > >> What is the name and location of a monospace font that includes the > >> IBM line drawing set. > > > > What is a "IBM line drawing set"? If that are some proprietary glyphs, > > you should not use them. Reader, who do not have the font, will not be > > able to read you document. Instead look at the Unicode charts, whether > > such symbols are included in Unicode and then look for a font, which > > covers that range. > > Have a look at https://en.wikipedia.org/wiki/Box-drawing_character > > Do you look for such characters? > > If yes then "DejaVu Sans Mono" will likely work for you. > > > > I used it a lot for forms in WordStar/DOS and I want > >> to continue in LibreOffice. > > > > If it is so old, then it is likely a bitmap font and LibreOffice > > cannot use it. > > > >> > >> How do I install it? > > > > That is outside of LibreOffice. Installing a font is done on level of > > your operating system. On Windows you will find "Install" in the > > context menu of the font file, for example. > > > > Kind regards, > > Regina > > > > > -- > Carter Campbell > Technical Communications > li...@soph-text.com > Calgary Alberta > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] LibreOffice parent company
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/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Rotating labels to landscape
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, pinhole edge paper. Even though the label layout survived into sheet feeder laser and inkjet printer era... the original reason to do 1x3 for 3x5 cards is gone. With the 1 wide layout you could print 1 at a time and remove the label or card individually. -- 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] Macros in spreadsheets
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: 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 that isn't being > called because each time I open the spreadsheet, the macros don't run. I > have to mess about a bit and then force each cell to recalculate > manually. (I'm sure that there's a global 'recalculate' button/tool > somewhere but that's secondary to the problem.) > > I know there's a lot of documentation out there on macros (almost too > much) but I'm not sure where to start reading, does anyone have a > pointer that would address, 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 the idea. -Robert A. Heinlein > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- 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] Weird line-wrap problem in Writer
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 allowing breakpoints. That is turn hyphenation back on, and put in normal spaces. I haven't played with 7.3 yet, but if they now have a style that includes "no break" you either need to insert the wrapping yourself (shift-enter) or turn it off if the paragraph is longer than a single line. On Sun, Nov 27, 2022 at 5:46 PM RealNameTBA wrote: > Having poked at this issue for days and being no closer to a solution, I > turn to those on this list. I am doing battle with a line-wrap problem > that defies all attempts to correct it. It's this (as illustrated in the > small attached screenshot fragment): at the end of a line the writing > jumps to the next line, not hyphenating anything (which is fine) but just > simply splitting words in the middle. It was not always thus. > > I can't help but think that at some point I must have accidentally clicked > on some configuration option that caused this to happen, but that option > is not apparent to me. > > If I save the file and open it in something else, the words are wrapped > normally, leading me to think it's a view or display issue. > > Anybody know how I can fix this? > > I'm running 7.3.7.2 / LibreOffice Community atop the TDE desktop on Ubuntu > 20.04. But the problem has been around for a while. > > Thanks in advance. > > RNtba > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] how to prevent conversion to hyperlink
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 addresses, and @...com email addresses, but those are the most common. [image: image.png] Cranberry Crunch 1 cup pecans, coarsely chopped 1 1/2 cups all-purpose flour 1 1/4 cups old-fashioned rolled oats 1/3 cup granulated sugar 1/3 cup packed dark brown sugar 1 teaspoon kosher salt 1/2 teaspoon baking soda 1 1/2 sticks unsalted butter, melted, plus more for greasing the pan 1 cup raspberry preserves Preparation Preheat the oven to 350°f Butter an 8-inch square baking pan and line the bottom and sides with parchment paper. Spread the chopped pecans in a pie plate and toast for about 5 minutes, until lightly browned and fragrant. Let cool. In a large bowl, whisk the flour with the rolled oats, granulated sugar, brown sugar, salt, baking soda and pecans. Using a wooden spoon, stir in the melted butter until the oat mixture is thoroughly combined. Press two-thirds of the oat mixture in an even layer on the bottom of the prepared baking pan and top with the raspberry preserves. Sprinkle the preserves with the remaining oat mixture. Bake for 45 minutes and then rotate the pan , finish baking till brown on top take the pan and and let it cool completely on a wire rack before trying to cut them .. This is 1/10th the size of the school recipe , my mom cut it down for a more practical home use .. On Thu, Nov 3, 2022 at 12:54 PM Robin Lake wrote: > All -- > > Greetings, and thank you for all the help and advise you provide. > > In LO Calc, how can I prevent an email address or url from becoming a > hyperlink (thereby printing in blue) when exiting a cell. Or, > alternatively, how can I remove it from hyperlink status afterwards? > > Thank you. > Robin Lake > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Python UNO odt to pdf converter - running time issue
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
only place where you might have something to change for improvement.)
2. You're comparing a physical machine with 4 cores against a virtual
machine with 1 core, those numbers seem a little long for the virtual, but
not by much. You can expect a factor of 2 for the virtualization, and then
another 50% for the lack of multi-core (if I'm remembering right and LO 7x
does support parallel core processing. but even if LO 7 doesn't support
multicore, a single core machine becomes very sensitive to everything
currently running, as all processes wait for the same core.)
On Fri, Nov 4, 2022 at 5:05 AM Marcin Giedz wrote:
> Hi there,
>
> using python we prepared a tool to fill/replace some TAGs in odt files and
> then to save such file to PDF. This is part of code from such tool:
>
> for key in values.keys():
> search = doc.createSearchDescriptor()
> search.SearchString = "{" + key + "}"
> search.SearchAll = True
> search.SearchWords = False
> search.SearchCaseSensitive = False
> selsfound = doc.findAll(search)
> for selIndex in range(selsfound.getCount()):
> selfound = selsfound.getByIndex(selIndex)
> selfound.setString(values[key])
> end = time.time()
> print("time replace tags in doc:", end - start)
>
> The issue we faced is a bit strange as total time for single file
> (structure of this file in 90% is a table in table) to convert differs a
> lot when running on laptop and on server:
>
> laptop:
> real0m9,700s
> user0m3,090s
> sys0m2,619s
>
> server:
> real0m37.190s
> user0m9.194s
> sys0m7.791s
>
> Libreoffice version is the latest from PPA stable Ubuntu. Server is running
> Ubuntu 22.04 and laptop Ubuntu 22.10.
>
>
> This is CPU info for both laptop and server:
> laptop:
> processor : 7
> vendor_id : GenuineIntel
> cpu family : 6
> model : 140
> model name : 11th Gen Intel(R) Core(TM) i7-1165G7 @ 2.80GHz
> stepping : 1
> microcode : 0xa4
> cpu MHz : 982.290
> cache size : 12288 KB
> physical id : 0
> siblings : 8
> core id : 3
> cpu cores : 4
> apicid : 7
> initial apicid : 7
> fpu : yes
> fpu_exception : yes
> cpuid level : 27
> wp : yes
> flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat
> pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb
> rdtscp lm constant_tsc art arch_perfmon pebs bts rep_good nopl xtopology
> nonstop_tsc cpuid aperfmperf tsc_known_freq pni pclmulqdq dtes64 monitor
> ds_cpl vmx est tm2 ssse3 sdbg fma cx16 xtpr pdcm pcid sse4_1 sse4_2 x2apic
> movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm
> 3dnowprefetch cpuid_fault epb cat_l2 invpcid_single cdp_l2 ssbd ibrs ibpb
> stibp ibrs_enhanced tpr_shadow vnmi flexpriority ept vpid ept_ad fsgsbase
> tsc_adjust bmi1 avx2 smep bmi2 erms invpcid rdt_a avx512f avx512dq rdseed
> adx smap avx512ifma clflushopt clwb intel_pt avx512cd sha_ni avx512bw
> avx512vl xsaveopt xsavec xgetbv1 xsaves split_lock_detect dtherm ida arat
> pln pts hwp hwp_notify hwp_act_window hwp_epp hwp_pkg_req avx512vbmi umip
> pku ospke avx512_vbmi2 gfni vaes vpclmulqdq avx512_vnni avx512_bitalg
> avx512_vpopcntdq rdpid movdiri movdir64b fsrm avx512_vp2intersect md_clear
> ibt flush_l1d arch_capabilities
> vmx flags : vnmi preemption_timer posted_intr invvpid ept_x_only ept_ad
> ept_1gb flexpriority apicv tsc_offset vtpr mtf vapic ept vpid
> unrestricted_guest vapic_reg vid ple pml ept_mode_based_exec tsc_scaling
> bugs : spectre_v1 spectre_v2 spec_store_bypass swapgs
> bogomips : 5606.40
> clflush size : 64
> cache_alignment : 64
> address sizes : 39 bits physical, 48 bits virtual
> power management:
>
>
> server (virtual machine)
> processor : 17
> vendor_id : GenuineIntel
> cpu family : 6
> model : 85
> model name : Intel(R) Xeon(R) Silver 4216 CPU @ 2.10GHz
> stepping : 7
> microcode : 0x5002f01
> cpu MHz : 2100.000
> cache size : 22528 KB
> physical id : 34
> siblings : 1
> core id : 0
> cpu cores : 1
> apicid : 34
> initial apicid : 34
> fpu : yes
> fpu_exception : yes
> cpuid level : 22
> wp : yes
> flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat
> pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm
> constant_tsc arch_perfmon nopl xtopology tsc_reliable nonstop_tsc cpuid
> tsc_known_freq pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe
> popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm
> 3dnowprefetch cpuid_fault invpcid_single ssbd ibrs ibpb stibp ibrs_enhanced
> fsgsbase tsc_adjust bmi1 avx2 smep bmi2 invpcid avx512f avx512dq rdseed adx
> smap clflushopt clwb avx512cd avx512bw avx512vl xsaveopt xsavec xgetbv1
> xsaves
Re: [libreoffice-users] certificate undetect
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 Windows or Mac, but newer MacOS and certain home editions of windows make it very difficult to install without certificates. That's an OS question and not a LibreOffice question: you'll need to solve it for any program that isn't on the official store, and the solution is specific to your exact version of OS, the version of LibreOffice, and the calendar date you are attempting the install. If you are trying to compile your own version of LibreOffice, this question more properly belongs in a developer forum. On Mon, Sep 5, 2022 at 3:35 AM lucky star <1364309...@qq.com> wrote: > Hello, > My name is Liu, I am a user of LibreOffice both in Windows > and macOS. Currently, the LibreOffice can't detect my certificate in system > certificate storage during digital signing. Can you help me? > BR. > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] scalc: (auto) wrap all cells per default
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 affect all the manual overrides that are already in place. [image: image.png] On Wed, Jul 27, 2022 at 6:55 AM Uwe Brauer wrote: > Hi > > Recently I receive ods files that contains cells that are very long and > I have to manually activate the wrapping feature for those cells. > > Is it possible to enabled wrapping in all cells per default? > > Regards > > Uwe Brauer > > -- > I strongly condemn Putin's war of aggression against the Ukraine. > I support to deliver weapons to Ukraine's military. > I support the ban of Russia from SWIFT. > I support the EU membership of the Ukraine. > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] ROUND function consistency
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 wrote: > I have just put a basic macro together so it will calculate income tax > due from our local tax rates. > I needed to round the tax to the nearest cent so taking the easy route I > added Option VBASupport 1 to use the available VB round function. > > I then noticed that the VB round function with say round(12.125,2) > rounds down to 12.12 and the LO inbuilt spread sheet function ROUND with > ROUND(12.125,2) rounds up to 12.13. > > Is rounding in this situation arbitrary or is there some some convention > for consistency. > > Steve > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- 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] In Calc, Window sizing impairment
It seems to happen far more frequently in Calc, but I have had windows in Writer do it too. I don't recall any non-LO app showing this behavior. I suspect something saves the window as one data type (floating point), then passes it unmodified to something that expects another data type (integer) and crash protection in cinnamon then zeroes out the value... or maybe it just accepts the incompatible data which is received as zero. I'm using a cinnamon variant of Ubuntu with a very low instance count. I didn't previously suspect this affected all cinnamon desktops, but it makes sense that it does. On Sun, May 8, 2022 at 10:06 AM Rogier F. van Vlissingen wrote: > > Thanks for that!!! > > > > > That analysis immediately "felt right" and it worked. I was wondering all > the time if it is a bug in cinnamon, or linux or LO... it makes 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 LibreOffice gets confused about what the non >> maximized window size should be. >> >> press Alt-spacebar to see a menu where this zero size window is being >> placed, then either choose "resize" or position the cursor on the narrow >> vertical line the height of the header/menu and resize it. >> >> On Wed, Apr 27, 2022 at 8:29 PM Rogier F. van Vlissingen < >> vlisc...@gmail.com> wrote: >> >>> On Linux Mint 20.3 >>> >>> LO Spreadsheet does not allow me to adjust the screen partially. I can >>> either do full screen or minimize completely. I have no clue what keys I >>> might have accidentally touched. Still works fine in Writer, but no >>> longer >>> in Calc. >>> >>> Any ideas? >>> >>> -- >>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >>> Problems? >>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >>> Posting guidelines + more: >>> https://wiki.documentfoundation.org/Netiquette >>> List archive: https://listarchives.libreoffice.org/global/users/ >>> Privacy Policy: https://www.documentfoundation.org/privacy >>> >> -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] In Calc, Window sizing impairment
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 window is being placed, then either choose "resize" or position the cursor on the narrow vertical line the height of the header/menu and resize it. On Wed, Apr 27, 2022 at 8:29 PM Rogier F. van Vlissingen wrote: > On Linux Mint 20.3 > > LO Spreadsheet does not allow me to adjust the screen partially. I can > either do full screen or minimize completely. I have no clue what keys I > might have accidentally touched. Still works fine in Writer, but no longer > in Calc. > > Any ideas? > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Spreadsheet question
Note that regex is much easier in a text editor than in LO Calc. I do this kind of thing as normal course of my activity: get the file to look like the .csv i want with an editor first, then import it into LO Calc. Tab delimited is the least error prone... (you can make a tab in most editors with regex with \t ) I use jEdit because it's ability to record the search/replace activity, then allow you to edit and replay the recorded "macros" on other files helps me work far far faster. But any text editor with regex functionality will eventually have to moving faster than LO Calc. But it's a steep learning curve. On Sun, Mar 13, 2022 at 9:18 AM Rogier F. van Vlissingen wrote: > Awesome, thanks! > > A bit puzzling... I thought I exactly copied your previous instructions, > but I got the idiot results you saw. Now I downloaded your spreadsheet, and > 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 break down with my instructions I get A > thru > > AB and here I transposed them to show. PM2.5 is in Column G not two. > > Then had formula to convert date and time value. Moved > > A > > Date > > B > > 20220302 > > 03/02/22 > > “=DATE(LEFT(AH2,4),MID(AH2,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 > > K > > CO2 > > L > > 10 > > M > > HCHO > > N > > 0.001 > > O > > TVOC > > P > > 0 > > Q > > >0.3DustNum > > R > > 0 > > S > > >0.5DustNum > > T > > 0 > > U > > >1.0DustNum > > V > > 0 > > W > > >2.5DustNum > > X > > 0 > > Y > > >5.0DustNum > > Z > > 0 > > AA > > >10DustNum > > AB > > 0 > > On 13 Mar 2022 at 9:30, Rogier F. van Vlissingen wrote: > > From:"Rogier F. van Vlissingen" > > Date sent: Sun, 13 Mar 2022 09:30:49 -0400 > > Subject: Re: [libreoffice-users] Spreadsheet question > > To: "Michael D. Setzer II" > > Copies to: users@global.libreoffice.org > > > Funny complication. > > > > > > One of the variable labels is PM2.5, but in this case that became two > > > columns, H, and I respectively, like this: > > > > > > H I > > > PM2 5 > > > > > > > > > On Sun, Mar 13, 2022 at 9:27 AM Rogier F. van Vlissingen < > > vlisc...@gmail.com> > > > wrote: > > > > > > > Awesome, thanks! > > > > > > > > I replicated that, and now I can just name the columns and the delete > > the > > > > preceding columns with the variable names and I am in business. > > > > > > > > One of these babies is 11775 rows ;-) > > > > > > > > > > > > > > > > On Sun, Mar 13, 2022 at 9:18 AM Michael D. Setzer II < > > msetze...@gmail.com> > > > > wrote: > > > > > > > >> Loaded the csv file with libreoffice and click on space and > > > >> other boxes and entered :. > > > >> That brings in columns A thru AB. > > > >> > > > >> > > > >> On 13 Mar 2022 at 9:05, Rogier F. van Vlissingen wrote: > > > >> > > > >> From: "Rogier F. van Vlissingen" > > > >> > > > >> Date sent: Sun, 13 Mar 2022 09:05:56 -0400 > > > >> Subject:Re: [libreoffice-users] Spreadsheet > > > >> question > > > >> To: David Lynch > > > >> Copies to: users@global.libreoffice.org > > > >> > > > >> > wow... I had never used that function before... > > > >> > > > > > >> > > I am not quite there yet, however, but at least this is a path. > > Here > > > >> is an > > > >> > > example of one of the strings > > > >> > > > > > >> > > Date:20220302 Time:1631 PM1.0:000 PM2.5:000 PM10:000 CO2:0010 > > > >> HCHO:0.001 > > > >> > > TVOC:0.000 >0.3DustNum:0 >0.5DustNum:0 >1.0DustNum:0 > > > >> > > >2.5DustNum:0 >5.0DustNum:0 >10DustNum:0 > > > >> > > > > > >> > > Using the expression as you wrote it, I get fields, like this: > > > >> > > Date 20220302 Time 1631 PM1.0 000 PM2.5 000 PM10 000 CO2 0010 > HCHO > > > >> 0.001 > > > >> > > TVOC 0.000 >0.3DustNum 0 >0.5DustNum 0 >1.0DustNum 0 > > > >> > > >2.5DustNum 0 >5.0DustNum 0 >10DustNum 0 and then I > > could > > > >> > > name the columns and delete the columns with the variable names. > > > >> > > > > > >> > > I will have to study that function... thanks. > > > >> > > > > > >> > > > > >> > > > > >> > > > > >> > > On Sun, Mar 13, 2022 at 8:41 AM David Lynch < > > dlynch131...@gmail.com> > > > >> > > wrote: > > > >> > > > > > >> > >> On 13/03/2022 12:04, Rogier F. van Vlissingen wrote: > > > >> > >> > Var1: value1 Var2: value2 Var3: value 3 ... Var10: value10 > > > >> > >> > > > >> > >> Place the strings in column 1 than put > > > >> > >> > > > >> > >> =REGEX($A1,"(?<=^| |:)[^ ]+?(?=:| |$)",,COLUMN()-1) > > > >> > >> > > > >> > >> in column 2 and drag right for ten columns and down. > > > >> > >> > > > >> > >>
Re: [libreoffice-users] Make 4 Sheet in Libre Writer
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 Drawing 2. place/paste in your image. 3. put the upper right 1/4 of the image into the first page. You can scale the image to fit the page, note the scaling, then double it. 4. duplicate the page, then shift the image to the upper right portion. 5. duplicate more pages for the lower left and lower right of the image. If you don't have LibreOffice Draw and can't get it, you can do something similar by placing an image into a full page box, then opening the Image properties and using scale and crop to achieve the same effect. LibreOffice Writer won't let you have an image bigger than the page, so you have to crop it, it's a far less visual and mouse experience, but ends up with the same effect. Notes: 1. All printers have edge loss... areas close to the edge of the page that won't print. be sure to overlap the center edge a bit so you don't end up with gaps when you try to align them. 2. Assuming your image has the focus at the center: the seams will be less noticeable if you make it 9 images... so the seams aren't going right though the middle. __ On Sun, Mar 6, 2022 at 3:48 PM charles meyer wrote: > Hi, > > I'd like to create a 4 sheet of a PNG in Libre Writer. > > In Writer, I followed these isntrctuons... > https://ask.libreoffice.org/t/divive-page-into-4-parts-librewriter/36389/5 > Format> Page SetUp>Columns and chose 2 > > Then, using the mouse I grabbed the center box in the PNG and dragged that > down halfway on the screen but that just compresses the graphic like a > circus mirror. > > I then chose Print and in there I can choose Pages per sheet (default to > set at 1) so I typed in 4 where that 1 was displayed and clicked Print to > PDF which saves that PNG in the top left corner with 3 others corners > blank. > > Is there another step needed to "duplicate" or "multiply" that PNG from > the top left corner so it's in all 3 other other areas (now blank) on the > single sheet? > > 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 > -- 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] Cannot install a separator line above footnotes.
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 upstream for the debian package you used to get LO. If it doesn't, then maybe the issue is in the desktop. On Wed, Dec 29, 2021 at 3:57 AM Ken Heard wrote: > I know that the first step is to select Format -> Page style ... -> > Footnote, which opens a window with several options for the footnote > properties. One of the options is 'Style'. Selection of 'None' for > 'style' means no separator line. If a separator line is wanted some > other selection must be made. Unfortunately for 'style' no other > options besides 'None' are available; so it is impossible to install a > separator line above footnotes. What do I need to do to have other > options for 'style'? > > I am using LO 7.2.3.2 with Debian 11 'Bullseye' and the Trinity desktop > environment. > > Ken Heard > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP?
And you can tell the difference between a 'text' date and a 'date value' date by turning on "value highlighting" menu-->View-->Value Highlighting Blue is a value or date value, Green is a formula, Black (or the regularly formatted color if you've painted your spreadsheet) is text. 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 been able to make the absolute value option work. ) > > > On Sun, Dec 19, 2021 at 11:26 AM Michael H wrote: > >> 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? 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] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP?
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 (ABS(A2)=10/8/21,B2,"") > > -- 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] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP?
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? 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] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP?
--
=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 requires column A left in TEXT format. If you
import your data as or convert it to a DATE VALUE, then "-" (equals) won't
work if you have hours/minutes/seconds included in column A (since the date
has no fractional value but unless you record something at midnight the
values in column A will all have fractional values (the HHMMSS represented
as a fractional portion of a day.) If you're dealing with DATE VALUEs You'd
need to do both a < and >= embedded in parenthesis to capture all values
within the day:
-
IF (A2<10/8/21,IF(A2>=10/9/21,B2,""),"")
-
I validated the first example works... I haven't validated the 2nd, but the
methodology is sound, as long as my spelling and first attempt at the
specific logic are accurate.
--
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 airithmetic snafu
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 like
this isn't the result of formula. That is, it doesn't take so long to
refresh when I'm only waiting on 10,000 calculations, and not 10,000,000
calculations.
So to avoid those annoying long refresh times, instead of creating the
source data with formula I copy the column to a new one, ensure there are
adequate new columns behind it, then convert the column to data with "Data
-> Text to Columns" and choose to break on space only (in your case,
sometimes I have to list out the first letter of units, but then I lose the
units, so instead I find/replace the new column to introduce tab characters
before doing the text to column action. (And if you trust yourself to
recognize mistakes in the text to columns steps before "undo" is gone,
copying the column to another one isn't required.)
3.
On Fri, Nov 26, 2021 at 11:12 AM Hylton Conacher (ZR1HPC) <
hyl...@conacher.co.za> wrote:
> HI ANDREW,
>
> On 2021/11/26 16:38, Andrew Pitonyak wrote:
> > Left will return a string so convert to a number using value...
> > Something like this
> >
> > =Value(left())
> >
>
> THANK YOU Works as expected,now on to the next formula Challenge
>
> > Get BlueMail for Android
> > On Nov 26, 2021, at 9:12 AM, "Hylton Conacher (ZR1HPC)"
> > mailto:hyl...@conacher.co.za>> wrote:
> >
> > Hi,
> >
> > Using LO7.2.2.2 Calc on iMac 11.6.1(Big Sur).
> >
> > I have a data column that ends in alphabetic letters i.e.
> >
> > C | D
> > 2| 2.4 km|2.4
> > 3| 4.8 km|4.8
> >
> > As the ' km' can't be added in column C, I used the LEFT formula to
> only
> > extract the first 3 digits, namely =LEFT(C2,3). This works
> wonderfully
> > in column D, BUT whilst not shown on the spreadsheet, the numbers are
> > shown in-between double quotes if one looks at the formula, in
> column D,
> > with the Function Wizard, which again does not enable the number to
> be
> > added, averaged etc.
> >
> > Both C, D columns are formatted as Number with a single decimal point
> > and there will be no -ve number.
> >
> > What am I missing, and where to rectify it?
> >
> > Regards
> > Hylton
> >
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] changing anchor of image drops me to end of document
> > 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 you doing this via the right-click menu? I do mods like this in the dialog box, and I have not experienced this issue, using a very similar LO6.4.7.2 and a variant of ubuntu 18.04 and another system with LO6.4.7.2 and a variant of ubuntu 20.04. With right clicks, I did see the view shifting, but not like you say all the way to the bottom. With the dialog box, it seems to shift less, but it all happens at once if you're making multiple changes... you don't apply until you have all the settings right. And by "dialog box" I mean right click on the image then choose the "properties" item on the menu (last one). The dialog box that appears has all the settings in the right click menu and more. -- 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] Correct documentation for V6.2 programs
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 documenting. If the Help/about screen shows an Ultra-office version number instead of LibreOffice, and doesn't also show what version of LibreOffice it was forked from, that's a question for the people who made UltraOffice. What you've suggested SOUNDS like the right path (LO 6.2 help files are the right ones to use.) However, no one at LO will be able to be more helpful than this. If you want to be more sure before spending on printed versions... confirm with UltraOffice people. On Wed, Nov 24, 2021 at 6:04 AM Gary Smith wrote: > I recently installed the Ultra Office for Free App from CompuClever > which uses the LibreOffice software. When I asked them about > documentation and help, they referred me to your website. From within > Writer, I clicked on a Help button in a dialog, and then selected the > 'read online' link and it connected me to your site and displayed help > for V6.2 on my desired topic. Later I went to your English > documentation page and I notice that there are documents for several > version numbers, 7.2 being the latest. I would like to get some users > manuals as references, but I what them to be relative to the program > version I have and cover its full functionality. > I have gotten caught before getting the manual for the latest version > which did not cover a function that was in the software version that I > was using but had been removed in the more recent program version. > My question is since it seems that my Ultra Office is V6.2, should I > get V6.2 or earlier documentation or should I get the latest version > documentation? > Thank you for your time.Gary Smith > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Subject: LO does not run on Ubuntu 16.04
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. https://www.libreoffice.org/download/flatpak/ One thing though... there won't be a 32bit version of LibreOffice 7.2. If you're still on Ubuntu 16 because the cpu in your system is 32bit... I think LibreOffice 6.4 is the latest version that has a 32 bit edition. Specifically, if you type "uname -m" into a linux shell and you see "X86_64", it means you're running 64 bit linux, and a LibreOffice 7.2 flatpak will likely work on your install. But if you instead see "i386" or "i686", you need to use a 32 bit flatpak. -- 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] Update a mailmerge file
(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 somehow capture this in the next version of the Writer manual. (Related to your last comments) When changes in Calc directly didn't show up in the data table view in Writer, I had tried 'refreshing' in Base many times before this email, and expected the table view to show my new #1 item either at the top or bottom of the base table. Following the steps I listed, "Rebuild" shows the new column and the new data in Base, and that data also now shows in the Writer data preview table. I was noticing that when I edited the calc file, it seemed to break the link in Writer and suddenly preview didn't work. It took exiting LibreOffice completely then restarting writer before the data table links again, but it always matched the table view in Base, not my new data in Calc. I associated this (unproven) with Linux swap management or something similar, but I've really got no understanding why my system (ubuntu based) has a latency between updates in calc and views in Writer merge data preview, only that saving and quitting the program completely seems to eliminate the lack of cross-updates. On Sun, Aug 15, 2021 at 12:44 PM Robert Großkopf wrote: > Hi Michael, > > > > But for anyone else following, here's the slightly amended suggestion: > > 1. Open the Base file used by the Writer merge file > > 2. (With Base still open, but not as an action from within Base, just > using > > a file manager) Open the source Calc file, Make your edits and save. > > You don't need to save them at this moment. > Rows, which appear in the table of Base, will be changed by "Refresh" in > the table (Data → Refresh). > New Rows won't appear directly in the table. Close the table and go to > View → Refresh Tables. Now new Rows will be shown. > > > 3. With Base still open, open the table related to the merge, and on the > > toolbar select "rebuild". > > 4. Save the Base file. > > Also you don't need to save the Base file. Nothing has been changed. > Base file will only connect from Calc to Writer. Or did there appear the > littel star in the Save symbol? > > > 4A. Close all LibreOffice files. (**) > > 5. Open the Writer merge file, and your changes should be present. > > > > (**) --- I use a Linux OS ... I've found that this close all office files > > step is required in Linux, but not always in Windows. Or more > specifically, > > I find that when I follow youtube videos about LibreOffice made from > > Windows, including 'close all Libreoffice' as a step after making updates > > elsewhere seems to make stuff work that just doesn't work for me like it > > does in the video. > > I'm using Linux (OpenSUSE 15.2) also. I haven't closed any file for > this. You only have t press "Refresh" for the table of the database in > the database browser of Writer. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Update a mailmerge file
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 field attempting to follow some only-slightly-related youtube videos. But for anyone else following, here's the slightly amended suggestion: 1. Open the Base file used by the Writer merge file 2. (With Base still open, but not as an action from within Base, just using a file manager) Open the source Calc file, Make your edits and save. 3. With Base still open, open the table related to the merge, and on the toolbar select "rebuild". 4. Save the Base file. 4A. Close all LibreOffice files. (**) 5. Open the Writer merge file, and your changes should be present. (**) --- I use a Linux OS ... I've found that this close all office files step is required in Linux, but not always in Windows. Or more specifically, I find that when I follow youtube videos about LibreOffice made from Windows, including 'close all Libreoffice' as a step after making updates elsewhere seems to make stuff work that just doesn't work for me like it does in the video. On Sun, Aug 15, 2021 at 11:08 AM Robert Großkopf wrote: > Hi Michael, > > > 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. > > Not dynamically, but some hints: > You have to open the Base file before opening Calc. > Wehen opening Calc you see it is write protected. Remove the protection > by the button, which is offered. > After you have input data refresh the tables in Base. > Then all data will be available in Base and also in Writer. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Update a mailmerge file
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 merge file and output. half or so of these fields aren't just text but calculations or aggregations of other fields. For me this is easy in spreadsheet, not so easy to build a query or form to do the same thing in Base. -- 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] Quote marks
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, 2021 at 2:21 PM MR ZenWiz wrote: > I have an ODT document in which I have specified the quotes to be > straight quotes (as opposed to the curly opening-and-closing "matched" > set). > > For some reason I can't explain, any new quotes inserted in the > document show up as curly quotes, not straight. > > The only way I can seem to get them right is to copy ones already in > the doc and paste them. Those come out right, but I'm baffled why > this isn't working. > > I have gone into Tools -> AutoCorrect -> AutoCorrect Options -> > Localized Options and set both single and double quotes for the > straight quote marks, and it seems to have no effect. > > This used to work, which is one of the things I really liked about it. > > What am I missing? > > LO 7.1.5 running on Xubuntu 20.04. > > Thanks. > > Mark > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- 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] Two parallel text flows in one document possible?
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) better than trying to manage the gutter within the LO interface. That is, I used column 2 for entering the gutter dimensions and tole LO to have no space between columns, and the table display seemed to be less inconsistent. I also found that during testing, it was much easier to keep the text in LO Calc in 3 columns, and make edits there, then paste the entire document into LO Writer as a table for formatting. This would make defining the language very easy: Select the entire column and in tools --> language choose the language for the column. On Thu, Apr 15, 2021 at 1:25 PM Ulf Dunkel wrote: > A two-column TABLE seems to be a very smart solution for this. Thank > you, Harvey. > > - - - - - > > Am 15.04.21 um 12:09 schrieb Harvey Nimmo: > > Hi, > > I sometimes have to translate documents. So that I can see the > > relationship of the texts I put one language on the right and the other > > left on the page. For that I use a two-column table which works quite > > well. Not sure if that is the most elegant solution for what you want. > > Of course you can format each column as you want (e.g. with no table > > borders), and the spell-check language can be set separately on each > > column. > > > > Greetings > > Harvey > > > > > > On Thu, 2021-04-15 at 11:42 +0200, Ulf Dunkel wrote: > >> Hello everyone. > >> > >> I would like to write a book in German and English in parallel and > >> let > >> the German text flow on the left and the English text on the right, > >> or > >> two columns of German on the left and English on the right. Is that > >> technically possible in LO Writer? I haven't found anything about it > >> yet. > >> > >> Best, Ulf > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] search for Asian font in English text
Set your "other options" in the find/replace box to enable regular expressions All Kanji characters, paste the following into search. ([一-龯]+) All Hiragana or Katakana characters paste the following into search. ([ぁ-んァ-ン]+) note this 2nd one has 2 unicode ranges... you can reduce this to search for only one. But the site I copied these ranges from lists Hiragana and Katakana together. I presume the first is Hiragana, but I've really no clue. If you're working with text, one of these might be familiar. In the replace section, paste $1 and while the cursor is active in the replace box, select format. The site I copied the regex ranges from: https://gist.github.com/terrancesnyder/1345094 About the brackets & parenthesis in REGEX searches: https://stackoverflow.com/questions/9801630/what-is-the-difference-between-square-brackets-and-parentheses-in-a-regex On Wed, Apr 14, 2021 at 9:07 PM Thomas Blasejewicz wrote: > Good morning. > I have this not very long English text with occasional Japanese > characters in it. > I would like to search for ONLY the Japanese characters, naturally the > font is different from the English but attribut "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 dialog (Control+H) should be able to search for > text by font. Leave the "Find" box blank. Then go Other options > Format > and fill in the "Family" box." > > However, that does NOT work. > I tried to search for all sorts of things: format, attribute, language > etc., but so far nothing helped finding Japanese characters. > > If anybody knows how to do that, I would be grateful for a hint. > Thank you. > Thomas > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Odd line spacing
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 grid: enabling 'Register-true' for every style (all 500ish of them.) they all register to 'm', except the footnote set which registers to 'f'. 2. I also use a specific line spacing and not a percent or preset. I also use only actual italic faces and not libreoffice created faces. 3. I also match the actual height of various styles within each document so that the height of x and X are the same for all fonts by managing the height with scaling factors. Libreoffice only has Y scaling as a function of superscript so to match fonts most of my styles declare themselves "superscript" then scale by a few percent. Some examples are here: https://drive.google.com/drive/folders/1yzjUqTzvui4l8mYjTiF-t1qjxZ4gpxCi?usp=sharing I think all the fonts in these templates are available from Google Drive, but possibly you'll have to find some from other places... they're all open licensed fonts. On Mon, Feb 1, 2021 at 3:54 PM John wrote: > When I type a line with italics in it the line spacing seems to > change. At the moment the page is set to proportional 100% and the > font size is 12 pt for all characters on the line. With only "normal" > characters the lines are evenly spaced and the page looks nice. > > When there is italics within the text, additional space appears above > and/or below the line so the lines are no longer evenly spaced. The > effect is to have a rather ragged page layout. > > What it "looks like" is if LibreOffice has taken the outer boundary of > the character area and rotated it to create the italic effect and the > corners of the boundary have pushed the adjacent line up (or down or > both). Probably not that but that is the visual effect. Setting the > size of the italic characters to 11 pt makes everything look right > again. The effect carries through to pdf files generated from the > .odt editor files. > > A friend who has a different version of LibreOffice (an older one) has > been able to take my .odt files and convert to .pdf without having > this effect. > > The font I am using (Garamond Pro) has an italic file included with it > although I can't prove that it is being used. > > Can anyone suggest how I caused this and what I should do to fix it? > > LibreOffice 6.1.3.2 running on Fedora 32 Workstation edition. > > Regards, > > 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 > -- 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] What does LibreOffice recognize as a column delimiter?
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, year, sales number), I would pull the information into Calc and format it there, then paste the data by selecting the cells, then copy/paste into Writer. Because of the issues with formatting tabular data after its in Writer has been broken as you describe for several versions. And you'll be able to adjust in Calc without having to struggle... the cells just keep going, no pages flipping on you. If the data were already stucdk in Writer, You might also try turning on Web View while you work on the table data within Writer. This has the downside that it can cause some weird things to happen on other pages you've already formatted, but if your table is already stuck in Writer web view tends to work better than page views on big tables. On Thu, Jan 28, 2021 at 6:08 AM Jeffrey Walton wrote: > Hi Everyone, > > I have a Writer document with a Table inside. The table is large at > about 3 columns x 500 rows. When I attempt to highlight the table > cells and paste the data from a single 1 x 1500 source LibreOffice > mishandles populating the table. > > I'm generating the data from a C++ program so I can format the data in > a way that makes Writer happy. For example, I can use a vertical bar: > >a | b | c >d | e | f >... > > Or I can use something else. > > I already tried to use vertical bars and HTML tags like ..., > but the paste did not work. > > What does LibreOffice recognize as a column delimiter? So I can > perform the 3x500 paste into the table? > > Thanks in advance. > > Jeff > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] If-exist condition for conditional text or section
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 predefined
syntax, but the attribute value should begin with a namespace prefix,
followed by a ":" (U+003A,
COLON) separator, followed by the text of a formula. The namespace bound to
the prefix
determines the syntax and semantics of the formula."
But all my attempts to make this work within Libreoffice writer failed. LO
Writer evaluated anything I put into as pure text,
not as a formula (as far as I could tell.)
I was approaching from a differential analysis on .fodt documents before
and after I made various changes, then studying ODF spec to determine what
that field could actually do.
There's clearly no interface to support this. It's in the spec so there
should be capability in LO Writer (or at least OpenOffice 2 & 3).. but
regardless what program I tried, I continued to get similar results...
regardless of what was in the attribute, i always got one
of the two results unless the evaluation was strictly either "FALSE" or
"TRUE" or some variant of capitalization of one of these. So wherever the
actual statement was it was looking for a boolean result but a string
result, which LO wasn't returning if the evaluation ever happened.
So, I switched to Calc where I know how to do boolean logic, and each cell
is visible realtime, so it doesn't take advanced forensics to see what is,
and fix.
On Fri, Jan 1, 2021 at 12:47 PM John Kaufmann wrote:
> Thanks, Remy. I'm very familiar with that use of conditional text. [My
> wife is also a teacher, and also depends on the LO-user in the house to
> help when things get moderately complex. ;-) ]
>
> The problem comes not when I can specify a switch (like "User" ==
> "Teacher" or "Student"), but when merging external data -- where a field
> may be either empty or instantiated -- to control a section of conditional
> text. Is there some way to do "IF-EXISTS" or "IF-BLANK" test on a field?
>
> I appreciate your response,
> John
>
> On 2021-01-01 12:49, Remy Gauthier wrote:
> > Greetings,
> > You can use a section to do that in WRITER. The easy way to start is to
> highlight the text and then Insert > Section. In the section configuration,
> there is a conditional "Hide" you can use. For example, I created my wide's
> course material using WRITER and I use a variable named "User"; this
> variable is used on the cover page to indicate "Teacher's version" or
> "Student's version" (the value of User is Teacher or Student). The document
> contains the homework and practice exams the students will need to do
> throughout the semester. In the "Student's version", each question is
> followed by a blank area or by empty lines to allow them to write the
> answer to the question. In the "Teacher's version", each question is
> followed by a detailed answer. The way I did this was to create two
> sections after each question: the first section is for the detailed answer,
> and is hidden if 'User eq "Student"'. The second section contains the space
> needed for the students to write their answer; this
> > section is hidden if 'User neq "Student"'. This way, I can flip between
> versions by changing the value of the variable.
> >
> > There is more information here:
> https://help.libreoffice.org/3.3/Writer/Hiding_Text <
> https://help.libreoffice.org/3.3/Writer/Hiding_Text>
> >
> > There are multuple ways of doing what you are looking for, but I believe
> sections are more flexible.
> >
> > I hope this helps.
> > Rémy.
> >
> > Le vendredi 01 janvier 2021 à 09:53 -0500, John Kaufmann a écrit :
> >> WordPerfect has a very useful condition for conditional text that must
> be possible in Writer, but I have not figured out how to implement: How to
> hide a block or section of text (or frame/figure/table/etc) unless one or
> more instances of a class (to which that text pertains) exist. Is there a
> way of expressing the condition
> >>"If: a field {IS|IS NOT} BLANK"
> >> that can be used in the condition to hide or expose relevant text?
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] If-exist condition for conditional text or section
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 decided that conditional text
in LibreOffice Writer is basically a doppleganger from Opendocument 1.0
that made it into the spec, but had no functionality.
So, all text that could be "hidden" now is kept in the database that I use
for the merge (which is a registered Calc spreadsheet). And I can build my
own if statements there in new titled columns easily.
In Calc:
Column A contains book title
Column J contains number of pages in the work.
Column Z (contains paper thickness imported from a query in the calc
spreadsheet)
Column ZA contains the SpineText with the calculation: (IF(J*Z>.25,A2,"")
While the spine text here is short, I keep the entire back cover copy (up
to 5 paragraphs) in the same database, each paragraph in a separate cell
(for convenience of editing, and to make the resulting LO Writer file more
easily deal with.) I have no conditions on that back cover text but the
same method could also apply to entire paragraphs. Each point where a style
change is required, you'll need a separate cell.
This method is limited to primary text stream, and header and footer text
on each page. That is, I haven't been able to "merge" into adhoc text
boxes In LibreWriter, only into the primary stream and header footer text.
I have been able to shift the footer text outside the defined box to
anywhere on the page, but that limits to 1 (or 2) out of stream boxes per
page, and the text can't be rotated or shaped.
On Fri, Jan 1, 2021 at 8:56 AM John Kaufmann wrote:
> WordPerfect has a very useful condition for conditional text that must be
> possible in Writer, but I have not figured out how to implement: How to
> hide a block or section of text (or frame/figure/table/etc) unless one or
> more instances of a class (to which that text pertains) exist. Is there a
> way of expressing the condition
> "If: a field {IS|IS NOT} BLANK"
> that can be used in the condition to hide or expose relevant text?
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Epson XP-820 paper size setup
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 LibreOffice... I do this type of thing for custom pages all the time, but I'm still on LO6.3 running on Ubuntu 18.04. I have a portable instance of 7.0.3 but I didn't fully test my suggestion, only that the print dialog still looks similar to that in 6.3. On Wed, Dec 9, 2020 at 1:03 PM Gary Dale wrote: > I'm running Debian/Bullseye and the printer is attached via USB cable. > My LibreOffice version is 7.0.3.1. My CUPS version is 2.3.3op1. The > printer is using the Epson ESC/P-R driver. > > The printer works fine but one thing is driving me crazy. I need to > print to a 244mm x 149mm envelope sometimes. This should load through > the rear paper slot which is provided for this purpose. However I can't > tell Writer to use this size. The envelope is defined as that size but I > can only select one of a list of paper sizes for that printer in the > Print dialogue. > > I have the same problem when I try to load the envelope into a paper > tray. I can tell the printer what size it is but that still doesn't show > up in Writer when I try to print. > > To make things weird, a number of the paper sizes are given as "User > Defined: 9.999in x 9.999in" but I have no idea how they got there - > although some seem to be standard sizes (photos, envelopes, etc.). > > Through trial and error (one or more errors per trial), I've come close > to getting an envelope to print reasonably without spraying ink outside > the paper range. However, the envelope document only vaguely resembles > what is printed. And I have to go through this again if I try to print > to a different paper size. > > Is there a way I can tell Writer to use the paper size of the document > so that it actually prints the way I set it up? > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Writer: Fake vs. Real Superscripts in advanced fonts
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 character style method with this table, so that copy/paste won't produce weirdness like the ordinal glyphs might if the pasted field doesn't have ordinals in the active font, but this is where you'd do it. On Sun, Dec 6, 2020 at 2:56 PM Cuyahoga Falls wrote: > I have a question dealing with one of the advanced features of today's > fonts: superscripts. > > Using LO, one can automatically get ordinal numbers using the > Autocorrect feature. Type 1st and the "st" is automatically converted to > a superscript. However, the superscript is an artificially created > superscript where the "st" is shrunken and raised. The stroke weight is > correspondingly reduced resulting in a superscript that looks > disproportionately light when compared to other letters. > > Today's modern fonts have better technology. Many fonts have built in > superscript glyphs that are properly sized and weighted. LO can access > these features graphically through the "features" option in the Format > > Character dialog (or "Font" tab in paragraph or character style > dialogs). If I click on the "features" option, and select "superscript," > LO will insert an additional code in the font name that will call the > properly designed glyphs. Thus, for example, "Sitka Text" becomes "Sitka > Text:sups" and the superscript inserted is properly sized and weighted. > I can get the same effect by typing the appropriate code in the font > name box rather than selecting from the graphical menu of optional > "features" in the character style dialog. > > The typographic benefit is that, by selecting the advanced superscript > of the font, one gets a true superscript that is not just shrunken > letters with reduced stroke weight. The stroke weight remains consistent > with the weight of the normally sized font. As an OCD challenged font > freak, I prefer using the true superscripts rather than the artificially > produced shrunken superscripts, which brings me to my question. > > As far as I can tell, LO's automatic insertion of ordinal superscripts > using the Autocorrect function always inserts artificially generated and > shrunken superscripts rather than the true properly proportioned > superscripts contained within advanced fonts. Is there a way of > directing the Autocorrect function to use proper superscripts if they > are available rather than always creating artificially shrunken ordinal > superscripts? > > It's a bit of a pain to have to manually reformat each ordinal number to > use the proper superscript. Even if I use character styles, that is > still more labor intensive than simply typing "1st" and spacebar and > getting the desired effect. If I could direct the Autocorrect function > to select true superscripts rather than artificially generated > superscripts, that would be great. > > For what it's worth, I'm using LO 6.3.4.2 on Windows 10. > > Thanks. > > 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 > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Re: Chapter and footnotes enumeration issues in LO Writer 7.0 and 7.0.3.1 beta
To confirm your issue, was this document with the problem ever a different format? That is, did it begin as a MS Word that you opened in LO and then saved? Each time you save the document, are you saving it as ODT format or another format? On Sat, Nov 28, 2020 at 4:37 AM UlfDunkel wrote: > Self-reply: > I deinstalled LO 7.x and returned to LO 6.4.7.2 but that didn't help. The > issues (forgotten heading styles and footnote enumeration) seem to stick > inside the document. > > What seemed to help was creating a new document and copying the whole > content of my 650 pages book into that new document. After adjusting some > applied paragraph styles, everything seems to work fine again. Saving the > new document, quitting and relaunching LO brought the new document back as > expected. > > What else could I have done to fix this issue? > > > > -- > Sent from: > http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Editing Impress Master Slides
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' was programmable to a key in 'customize keyboard' but I don't see it there. On Thu, Oct 22, 2020 at 3:06 PM Cuyahoga Falls wrote: > As a college professor, I use slide presentations daily. I have used a > variety of solutions including LaTeX/Beamer, Markdown/Slidy, and LO > Impress. > > Impress is obviously very full-featured and easy to use with its WYSIWYG > user interface. However, I have been bothered by what appears to be a > strange behavior in Impress. > > There are times when, after creating a slide presentation with 15 to 20 > slides, I find I need to edit something globally, such as the size or > shape of a text box on the slides. To do this, I go into the appropriate > Master Slide and make my changes. I then click to apply the Master Slide > to all slides, but then when I go back into the slide presentation, I > find that my changes are only applied to some, but not all of the > slides. I then find myself having to go into each slide to reapply the > same changes on a slide-by-slide basis that I had tried to apply > globally by changing the Master Slide. > > I'm finding that, when working with Impress, I have to carefully design > all of my slide formatting *before* composing my content, because if I > have to change formatting later, I have no assurance that the changes > will take effect globally. This is obviously the opposite of the > behavior in LaTeX or Markdown, where the formatting can be designed at > any point in the process with predictable results. > > Has anyone else noticed this behavior? Is this a bug, or can anyone > suggest anything I might do differently? > > I am currently using LO 6.3.4.2 on Windows 10, but I have noticed this > behavior for years on a variety of LO versions on both Windows and Linux. > > 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 > -- 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] defective field in header on one page
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 it is, you should be able to see a set variable field shading in the body text that can either be restored to the correct chapter heading value for 37 or deleted if it is extra. The fields are set in the body text and displayed in the page definition. When you 'set' the value on the header, that doesn't change page 37 but the page definition for all pages. you want to find where it is set. examining the .fodt file, or the content.xml in the .odt will help you understand this. On Sat, Aug 1, 2020 at 11:26 AM Philip Jackson wrote: > I'm carrying out a minor rework on a book I wrote in Writer some 3 years' > ago. The problem which is stumping me is that the field which displays the > chapter name in the header of the right hand pages is missing on page 37. > > All other headers and footers are displaying their fields correctly. I > have applied the field shading (View > Field Shadings) and I can see the > shading. But it has shrunk down to the size of a single space on this > page. A right click on this space gives the option to edit fields so > Writer is convinced that the field is there and produces the dialogue box > with the field name, Chapter Name, which is correct. > > Anything I do to reapply this field or edit the field in page 37 appears > in all the other right hand page headers as well. > > I can't see anything in the style spec of p37 that differs from any of the > other right hand pages. I've tried deleting this page and reinserting but > the problem gets inherited by the new page. > > Does anyone know what I'm missing here? > > 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 > > -- 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] Add a bookmark to TOC
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 requests, I've gont back and played find the hidden link, and now the file is now set to be viewable, if you are still interested. It will display as XML text, but there is a download link in the upper right corner. If you just save it with the same name ending .fodt, it should open properly in librewriter. What "works" is what's best for you. My solution isn't the simplest. There is a "simpler" solution that only involves using 1 index mark, and mixing the paragraph styles and index mark together in the TOC setup, but sometimes "simplest to do" isn't the "simplest to fit into a 100 word email." If you can master index marks, it's the easiest way to edit Table of Contents of all types, and make your work viewable from all outputs, as this method turns into slightly better ebook than 'whitepainted', 'invisible', or 'shrunken' text. On Sun, Aug 2, 2020 at 2:16 PM John Kaufmann wrote: > On 2020-08-02 07:06, User wrote: > > Thanks Michael. I am sure there is a use for your method, but it is much > > too complicated for my small requirement. > > Actually, Dave, Michael's method (inserting an index mark in the > Dedication paragraph) is the simplest and easiest way to accomplish what > you want. Your case happens to be the *reason* for having TOC index marks. > > Kind regards, > 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 > -- 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] Add a bookmark to TOC
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, to prevent it from getting moved or erased if someone later works on vertical spacing with hard returns. To create new hidden entries 1. Set the cursor to each location you want the TOC to point to. Then in the Insert Menu - > Index and Table of Contents -> Index Entry - Index type : Table of Contents - Entry : (text you want to appear on the TOC page) - level : if you want to style some entries differently set them to a different level, then assign the alternate style in the TOC setup. - Each time you click OK, you create an entry that matches the field values. If you have fields set to display you can see a light grey block. - Extra entries may be deleted with the backspace or delete key as a character in the paragraph. 2. Set the cursor to the point you want the TOC to appear. Create a TOC as normal, but choose Index marks instead of 'Additional Styles.' On Sat, Aug 1, 2020 at 6:46 AM Office User wrote: > First, I do understand how to create a > TOC based on heading levels, but what I am trying to work out is > how to add some kind of flag/marker (I am using the term bookmark) > to a paragraph in order to have it appear as the first entry in a > TOC.To illustrate with a hypothetical example: An author wishes to > add > a 1 paragraph dedication on a page at the start of a book and have > the word "Dedication" appear as the first entry in the TOC, but > does not want the word to appear on the dedication page in the > form of a heading.It would be much appreciated if someone could > point me to a source > of information about this, because my own searches have uncovered > nothing.TIADave > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Re: question
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 system defined key to recalc. (F9 or Ctrl+Shift+F9 in ubuntu 18.04.) I do this for all complex sheets now, just so scrolling and editing goes smoother. On Tue, Jul 28, 2020 at 4:33 AM Luuk wrote: > > On 27-7-2020 20:27, fudmier wrote: > > > > On 2020-07-27 11:39 a.m., fudmier wrote: > >> > >> On my linux 16.04 box .. each time i perform any function that involves > >> switching between tabs, or between certain activities within the same A > >> tab my computer goes into Oh shit mode.. it disables my keyboard > activity, > >> and the disk goes to spinning,, the background of the spreadsheet goes > into > >> grey mode, and it sometimes takes two or three minutes before the full > >> control reappears and the background returns back from greyed out to > white > >> again. > >> > >> > >> is this this has been going on since last November.. but it has reached > >> epidemic proportions .. and has rendered Libre office useless on my > machine > >> > > > hard to tell without knowing some things like: > > 1) what is the size of this worksheet? > > 2) how much internal memory do you have on your machine? > > 3) what version of LibreOffice? > > > With 'linux 16.04' you probably mean Ubuntu 16.04 ? This means you should > upgrade before April 2021 (see: https://wiki.ubuntu.com/Releases) > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Multiple newlines
Much simpler than using a hex editor:
1. rename the .odt to .zip and use a zip archive manager. you want to look
in content.xml
2. save the file as an .fodt (its the same file in open text.) view that
with a plain text editor. This works great unless you have a lot of images
in it. textified images are too much of a good thing.
On Tue, Jul 21, 2020 at 12:18 AM John Kaufmann wrote:
> Hi Brian,
>
> Thanks for introducing a fundamental concept that my brain had not yet
> grasped. As for the details:
>
> On 2020-07-20 18:49, Brian Barker wrote:
> > At 16:38 20/07/2020 -0400, John Kaufmann wrote:
> >> Documents archived in Project Gutenberg are typically simple text, with
> each line ending in (Hex:0D0A), so that paragraphs are separated
> by an empty line . I thought it would be simple to convert
> one such (5657.txt) to format in Writer, ...
> >> ... 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?]
> >
> > First, once you have your text in a word processor, you do not have
> or or or anything else like that in your text; instead you
> have *paragraph breaks*. There is no character there, despite the pilcrow
> that you can get Writer to display. And what you are calling "empty lines"
> are actually empty paragraphs. "\n" in the "Search for" field matches line
> breaks, not paragraph breaks. (And line beaks are line breaks - also no
> "codes".)
>
> You sent me to do something I should have done before asking the question:
> examine a hex dump of an ODT content.xml file. I see what you mean about
> "no codes": A paragraph is just a text string between XML bounds ...> and , and a line break (inside the paragraph bounds) is just
> . Sorry; I should have done that sooner, rather than rely
> on a different paradigm that once worked for me.
>
>
> >> (2) Although "$" is found (matches to ), ...
> >
> > No, "$" does not match anything; instead, it anchors the expression
> before it to the end of a paragraph. So an expression ending with "$" will
> match text only if it comes at the end of its paragraph.
> >
> >> ... "$$" (for successive occurrences of ) is not found. Why?
> >
> > "$$" has no sense. If anything it means "this pattern needs to match
> something that is *really, really* at the end of a paragraph"!
>
> :-)! Given what I learned after your answer on (1), this (2) is obvious.
>
>
> >> (3) Doing Find "$" & Replace with " " (single space), is
> replaced by " " (single space). However, doing Find "$" & Replace with "@"
> (single @char), is replaced by "@@" (double @char). Why?
> >
> > I don't think that's true. In any case, there are no s present.
>
> You're right. Examining again, I note that the "@@" was a remnant of a
> prior attempt to replace the of the original text file
> with "@@" (prior to replacing all other with " "). A faulty mental
> model led to a bad approach and a misreading of the result.
>
>
> > To achieve what you want:
> >
> > First combine single-line paragraphs:
> > o Apply Default paragraph style to all the text.
> > o Select all the text.
> > o Apply AutoCorrect.
> > (You may need to adjust the minimum length of such paragraphs in
> AutoCorrect Options - possibly to 0%.)
>
> Thank you! - that is not obvious (and I had not found it in the Help or
> the Writer Guide), but was worth the price of having this problem arise.
> AutoCorrect had the effect of changing most non-empty "Default Style"
> paragraphs to "Text Body" style, with the rest chosen [by spacing hints?]
> to be "Hanging Indent", "Heading", "Heading 1", "List", "List 1",
> "Numbering 2" or "Text Body Indent". (Empty paragraphs remained "Default
> Style".) That was a MUCH more elaborate and sophisticated AutoCorrect than
> I ever would have imagined.
>
> Now I understand the point of AutoCorrect Option "Combine single line
> paragraphs if length greater than 50%". But how do you "adjust the minimum
> length of such paragraphs in AutoCorrect Options - possibly to 0%"? (The
> fact that I don't find the setting suggests that I may have also missed
> something basic in your explanation.)
>
> Note: Even after having this excellent explanation on a use of
> AutoCorrect, I went back to the Writer Guide and still don't find it. So it
> may take quite some time to learn enough of such subtleties to feel that I
> have a solid grasp.
>
>
> > Then remove empty paragraphs:
> > o Search for "^$" (no quotes) and replace with nothing.
> > ("^" anchors your pattern to the start of a paragraph and "$" to the
> end. So "^$" matches a paragraph with nothing in it.)
>
> Again I like your pedagogical approach, matching the action with the
> reasoning. You should be a teacher.
>
>
> > I trust this helps.
>
> Helps?! It was an education. (If you could just answer the follow-up
> question on AutoCorrect Options...)
>
> Thanks again,
> John
>
> --
> To unsubscribe e-mail to:
Re: [libreoffice-users] Re: Understanding Character styles "Default Style" and relative font sizes
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
100%. This thread suggested it's possible that the box named "Relative
font size" now accepts a number over 100% (as it should.)
[image: image.png]
On Sat, Jul 11, 2020 at 4:56 PM John Kaufmann wrote:
> Hi Mike,
>
> On 2020-07-10 05:51, mikekaganski wrote:
> > (Sent from:
> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
> )
> > ...
> > What you see is clearly a bug. Even two.
> >
> > First is a bug of character styles' relative size.
> >
> > The relative size must evaluate first relative to its inheritance: i.e.,
> if
> > the character style B (with a relative size) inherits from character
> style
> > A, then it needs to apply the relative size to the size defined in that
> > parent style A (if any). If the size in A is defined, and is absolute,
> then
> > the result is an absolute size independent from any paragraph settings;
> > e.g., if A defines 14 pt, and B defines 150%, then text styled B must be
> 14
> > pt * 150% = 21 pt. This case now works correctly.
>
> Yes. No problem there.
>
> > But if A does not define a size; or if it also defines a relative size -
> > then the resulting character style as a whole defines a relative size (in
> > case A has 40%, and B has 150%, the resulting relative size is 40% *
> 150% =
> > 60%). Then the multiplier must apply to the size defined in the text
> run's
> > superordinate. It might be another text run (the ODS defines that
> character
> > styles may nest - so this character style may be applied to some part of
> > text having another character style, and then the size of that
> superordinate
> > text run must be the base to which the multiplier must apply). Or it
> might
> > be the paragraph - and now the paragraph should define the base for
> applying
> > the percentage. And here we have the bug #1.
>
> So I thought: The Paragraph style supplies the superordinate -- or, in the
> case of nested Character styles within a paragraph, the Paragraph style as
> modified by the longer-run Character style provides the superordinate for
> any additional Character style applied to a subset of the longer run. So
> your understanding is the same as mine: that the Character style /should/
> modify the character attributes of the Paragraph style -- or any subsequent
> superordinate. [More on this later.]
>
> Having confirmed that Writer does not, in fact, work that way, I suspected
> a problem with my understanding, while you conclude that there is a bug
> (#1). More and more I'm inclined to think you are right (because nothing
> else makes sense to me). As I noted to Robert, his alternate theory of
> operation would explain why my understanding does not work, but it also
> does not make sense.
>
> Before filing a bug, I wanted to assure that I have understood correctly
> what should happen -- and then, when we get it right, I would like to write
> it for the Guide, to clarify a point that should be basic to the operation
> of Writer. [However, precisely because this is so basic, I worry that a
> resolution may not be a simple fix, and could take years to realize. More
> on this later.]
>
>
> > The other bug is that there's a possibility to define Default Paragraph
> > Style (or any paragraph style that doesn't inherit) to have a relative
> size.
>
> How about Robert's suggestion: Tools → Options → LibreOffice Writer →
> Basic Fonts ?
>
> That *does* set an absolute size basis.
>
> But that /seems/ to present another basic problem, which I infer is
> bothering you; it is this: Since everything (Paragraph styles) descends
> from "Default Style", then Why have other style sizes {"Heading", "List",
> "Caption", "Index"} on that page? I /think/ [again, this is my inference,
> not something I have seen], Basic Fonts is intended just to provide an
> initial config, /to be discarded as soon as the user expresses a different
> intent/.
>
> For example, "Heading" is based on "Text Body", which is based on "Default
> Style". Normally "Text Body" takes its font size (12pt) from "Default
> Style", while (in a new document) "Heading" has a different size, taken
> from that Basic Fonts page. However, if you assign "Heading" a relative
> size (say, 150%), /then/ it reverts to basing the 150% on "Text Body",
> /not/ the Basic Fonts page. So it goes from taking its size from the Basic
> Fonts page to taking its size from the inheritance rules (just as it does
> if you hit the "Standard" button). But what is unique about "Default Style"
> among the styles listed in Basic Fonts, is that the user can never express
> that "different intent" that invokes a different rule of inheritance,
> because the inheritance rule is moot for "Default Style". That, I think,
Re: [libreoffice-users] Re: Understanding Character styles "Default Style" and relative font sizes
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 alternate, unmatching fonts to scale by using the position tab and 'superscript' or 'subscript' with a "raise/lower" of 1%, then the relative shrink in the relative size. This results in the scaling value recorded in the style, not factored into 'font size'. But it only partially works. Both the Raise/lower and 'relative size' in the Position tab are unnecessarily limited. Instead of 1-100%, 'raise/lower' should be single number -1000 to +1000. and be a multiplier, not a percent. (or maybe a percent.) and relative size should be .1% - 1% If someone is reading this and coding. please consider implementing a change where "position tab removes the "super/normal/sub" radio buttons and replaces them with just the variables "raise/lower" and "relative size". Percent scaling belongs in that spot, not as an instant math typed into the font size. That is (here's the technical complaint) I consider it a bug that only allows values 1-100 for both of it's values. It should allow values -1000 to +1000 for the position, and fractional (.01 or .001) to large (1000 or 1) for relative size. The "super" and "sub" should be deprecated or separated. Other than a possible divide by zero, there's not much risk here. And they are both multipliers, not divisors... so proper code should already be avoiding the divide by zero. This provides 1. the ability to set a scaled text without shifting the baseline (even 1% is sometimes annoyingly noticeable.)) 2. the ability to grow text as well as shrink text with the "position" tab (). 3. the ability to maintain separate "text scale" vs "font size" so that upstream changes to the stylesheet roll into all cases properly. On Fri, Jul 10, 2020 at 4:56 AM mikekaganski wrote: > Hi John, > > What you see is clearly a bug. Even two. > > First is a bug of character styles' relative size. > > The relative size must evaluate first relative to its inheritance: i.e., if > the character style B (with a relative size) inherits from character style > A, then it needs to apply the relative size to the size defined in that > parent style A (if any). If the size in A is defined, and is absolute, then > the result is an absolute size independent from any paragraph settings; > e.g., if A defines 14 pt, and B defines 150%, then text styled B must be 14 > pt * 150% = 21 pt. This case now works correctly. > > But if A does not define a size; or if it also defines a relative size - > then the resulting character style as a whole defines a relative size (in > case A has 40%, and B has 150%, the resulting relative size is 40% * 150% = > 60%). Then the multiplier must apply to the size defined in the text run's > superordinate. It might be another text run (the ODS defines that character > styles may nest - so this character style may be applied to some part of > text having another character style, and then the size of that > superordinate > text run must be the base to which the multiplier must apply). Or it might > be the paragraph - and now the paragraph should define the base for > applying > the percentage. And here we have the bug #1. > > The other bug is that there's a possibility to define Default Paragraph > Style (or any paragraph style that doesn't inherit) to have a relative > size. > That is definitely a bug, since there's nothing in any standard, or in any > setting, that would tell then which is the basis to which the relative size > is applied. And LO behaves erratically then: say, set default paragraph > style to 6 pt; see how everything becomes small, and default is 6 pt. Now > set default paragraph style to 150%; see how everything increases, and > paragraphs of default style are 9%. So it looks like it applied the ratio > to > the old value - but the paragraph style's properties still show the > relative > size, not 9 pt which it should! This is the bug #2. > > It all needs bug reports (one for each bug). > > A note: there's no UI for nesting character styles, and so my description > about nesting them can't be tested without direct editing of ODF. See > https://bugs.documentfoundation.org/show_bug.cgi?id=115311. > > > > -- > Sent from: > http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?
Re: [libreoffice-users] Repeat a footnote
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 location on the same page > and I want to duplicate the number of the footnote in the text for the > other instances of the term, but have the text of the footnote appear > only once at the bottom of the page. > > I started by copying the '1' after the first instance of the term and > pasting it at the end of the second instance of the term, but this > created a new footnote '2' with the text of the footnote at the bottom > of the page duplicated. > > So I deleted footnote 2 and decided that I would just put a superscript > '1' at the end of the subsequent instances of the term. This works, but > I can't get the superscript 1 to look the same as the footnote '1.' The > footnote '1' is in some other font and heaven knows what size and > position it is in. I can select it, but selecting paragraph or character > dialog window doesn't reveal what its settings are. The character > dialog box just says it is 'normal.' The paragraph dialog box has a tab > for indents and spacing, which just echoes the style that is applied to > the whole paragraph, and the font tab is missing. > > Where are the settings for the superscript numerals used in a footnote? > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] LO Styles organization
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 the same file saved as flat file format before and after making only a couple changes to the dialog in question. However, pages are more complex than paragraph styles. There's 3 (?) different spots that changes to page definition reside in the actual xml, and understanding their relationship is fun.. On Tue, May 5, 2020 at 4:29 PM John Kaufmann wrote: > I'm trying to understand what is contained in LO styles [which I know > changes according to style class (for Writer: Paragraph, Page, etc)]. To > simplify this question, I have decided to: > (a) focus on a Page style (instead of the more complex Paragraph > style) to understand the principles; > (b) limit the initial inquiry to the relationship between the > attributes defined in the tabs of that style definition and the attributes > summarized in the Organizer tab's "Contains" section. > > For example, for a custom Page style "Booklet" (used for 7.5"x8" > folded/stapled booklets), the Organizer tab lists: > " > *Contains* > 8.5 inch + From top 0.5 inch, From bottom 0.5 inch + No header + > No footer + No grid + Text direction left-to- > right (horizontal) + Page Description: Arabic, Portrait, All + > Booklet + Not register-true > " > > "Contains" uses "+" [rather than, say, \n] to separate attributes. [BTW: > is there a better term than "attribute" to use here?] > In this case it lists 9 attributes (including the 2-part top/bottom > margins attribute and the 3-part Page Description attribute): > - 2 (not all) attributes from the Page tab, > - 2 attributes from other tabs; > - 1 attribute defined in "Tools > Options > LibreOffice Writer (or > is it LibreOffice Writer/Web?) > Grid"; > - 2 attributes (Text direction, Page Description) defined nowhere > that I can find; > - 1 attribute (the style name: "Booklet") defined in the Organizer > tab; > - 1 more attribute (Not register-true) defined in the Page tab. > > With the background provided by that example, I ask these questions about > the Organizer tab "Contains" section: > (1) What is the significance of this section? Does it have any > formal significance or functional use? > (2) Why does it list attributes not defined in the style? > > [Any further questions would be clarified by the answers to those > questions.] > > Thanks, > 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 > -- 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] Splitting columns in Calc
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 open in Calc. (LibreOffice Calc Format:) https://drive.google.com/open?id=1kAwo38wZzWXd11W8biVV13kSY8sCnNVX On my computer, Google Chrome wants to open this file with Google Sheets. But Sheets doesn't understand REGEX. Download it as an .ODS and it should open. __ First name for cell A1 =REGEX(A1,"(.+) ([^ ]+$)","$1") (returns all but the last word, unless you have trailing spaces.) Last name for cell A1 ==REGEX(A1,"(.+) ([^ ]+$)","$2") (returns the last word, unless you have trailing spaces.) On Mon, Apr 20, 2020 at 7:39 PM Pat Brown wrote: > I have a spreadsheet that includes a column consisting if people's names. I > want to split this into two columns. I want one column with the given names > and the other with their family names. This requires taking the last word > in the column and creating a new column with this word. Is there a way to > do this in Calc? > > Thanks, > > Paddy > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Base...
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 "observer" table that provides the D,E,F data. I'm not clear if the time (Days, Weeks, Months) is part of DEF list, or another list. Probably its more calculations on the Same information in the report. On Tue, Feb 4, 2020 at 12:52 PM Robert Großkopf wrote: > Hi David, > > Only one some hints for the tables and the relations between the tables: > > > > A. ID > > B. Name > > C. Gender > > D. Number of reactions done > > E. First reaction > > F. Last reaction this is the most recent reaction > > G. Days - Formula =NOW() > > H. Weeks - = > > I. Months = > > > This has worked very well but now I want to be able to gather more > > information using just Columns A, B, C. So, what I can gather from > reading > > the Getting started instructions for Base, I need more than one Table. > Are > > those listed below suitable. > > > > Table 1 - Reactors > > ID > > Name > > Gender > > > > Table 2-Performers > > ID > > First name > > Last name > > Do you need Table 1 and Table 2? Could also be one table all together > wit a field, which shows 'R' for Reactors and 'P' for Performers > > > > Table 3 - Performance > > ID > > Title (this eill be the title of a song, or a dance routine, or a piano > > concerto, etc. > > Date upload > > Website > > There must be a foreignkey from the Performers to the Performance. The > "ID" form Performers has to appear at "Performance" as "Performers-ID", > if there is only one Performer for a Performance (1:m relation). Could > also be you need a table, which contains the Performers-ID and the > Performance_ID together: More than one Performer for a Performance, also > moere than one Performance for one Performer possible (n:m relation) > > > > Table 4 - Location > > ID > > Studio > > Concert - open air > > Concert - Hall > > How should this table be linked to the other tables? > > Calculations and reports won't be a problem. But the most important > problem is to create the right tables. Content in one table shouldn't be > reported too much. But the best start will be one table with all the > content to see which content will be repeated in the table. Then you > could split the repeated content from the table and set a foreignkey to > another table with this content instead. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] RE: Using Libre Writer - with hardware questions
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 portable app does work, you might try these steps to fix your issue: 1. uninstall the installed version of LibreOffice 2. create another user account on your laptop 3. Install LibreOffice STABLE (not the FRESH version) while logged into the second user account. Hope this helps! Michael On Sat, Jan 25, 2020 at 4:01 PM charles meyer wrote: > I've been encouraged to post here re: my hardware travails! > > Here goes... > > I booted up my older Toshiba laptop running Windows 7 which for years had > been working fine. > > Then, one day I booted up and got these vertical color bands where you > couldn't see anything else bu the bands. > > I then re-booted and opened Word 2003 (as Libre Office take a longer time > to open and the laptop would just shut Word > down, then when I re-booted it would shut the laptop down while I was > writing in Word. > > Then, I tried opening Libre Writer and it just froze – never opened so > I had to press the power button to re-boot. > > > I moved the laptop power adapter from the power strip to the UPS then > moved the laptop so it’s connected directly into a wall outlet in > another room. Still no good. I then powered the laptop in an outlet in > the top outlet (not the bottom one even though the last testing showed > the outlet (top/bottom)were both fine. > > I then brought the laptop to work and got the same results when trying to > run it. > > Someone said I might have to delete all my video drivers and r-install > them. > > I have no idea where to find those drivers on my laptop, nor which ones to > delete nor where I would find the correct replacement video drivers nor if > that's even a correct solution. > > I've got 3 GB Ram running. > > It's a nice 17" screen so I don't want to toss the laptop and it ran for 3+ > hours at a friend's work space - with 4 programs open at the same time - > Publisher, GIMP, the Brave browser running a YouTube video and another > program to test the laptop and it all worked fine. > > Thanks for your thoughts/ suggestions. > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Word counting in LO Writer
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 a thesis, 4 is correct (as far as I know, but I'm a child of the 80's... things may be different these days.) On Wed, Dec 18, 2019 at 1:59 PM Krunose wrote: > Hi, > > is it ok for LO to find five words in 'This is < a word.' as > > https://www.countofwords.com/ > > finds only four. Don't know how that reflects on this like 'This is 4 > words' and not sur so on. It's hard to anticipate every possible variant > - is that the reason? > > Is there more information about this? > > Thanks, > > Kruno > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...
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 spreadsheeet in Calc which records data of reactions to a > particular performer. It is in the form: It has Columns A - G. > > A - Name, fformatted as Text (records thre name of the persons doing the > reaction) > B - No, formatted number general (records number of times this > reactors has reacted to the performer) > C - First, formatted DD/MM/YY (records the first date the reactor reaacted > to this performer) > D - Last, formatted DD/MM.YY (records last date reactor reacted to this > performer) > E - Days, formatted =NOW()-D3 (records number of days since last reaction) > F - Weeks, formatted =E3/7 (records number of weeks since last reaction) > G - Months, formatted =F3/4 (records number of months since last reaction. > reaction) > > Is there a formula that I can enter in Column B which will increase > incrementally increase the figure by 1, please? > > Regards from New Zealand on a very warm summer evening. > > David > -- > Zed > "To use the term blind faith, is to use an adjective needlessly." Julian > Ruck > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Retaining Graphics and Text intact into Writer
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 against copy protection scripts or methods and not the import or export of the web browser nor LibreOffice Writer. On Tue, Nov 19, 2019 at 1:21 PM charles meyer wrote: > My esteemed listmates, > > I copy/paste text + graphics from an online forum into Writer. I change the > Page to A 4 and even reduce the font to 10 but I still lose content. > > Besides doing screen shots screen-by-screen,have others found a way to > copy/paste graphics + text and save it in Writer without losing any > content? > > Printing to PDF often loses the graphics and I'm just left with text. > > 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 > -- 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] Transparency issue saving to .doc/docx
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 paragraph style, set the character width to 80%, and the character spacing to .1pt, and you should achieve a similar look and fit with Calibri that you see with Liberation Condensed. You should note that the appearance will vary quite a bit from screen to printer. That is, this setting looks OK on my screen, but would probably look a bit squashed on my printer. If your final intent is to print the document, you should review the result carefully using the final printing method (output to PDF, then printed on the final printing equipment) before deciding this solution is usable. 2. Transparency Consider breaking the image up, where the resulting pieces won't overlay your text. That is, instead of leaving a border image with text appearing inside it, place the border as multiple images, so that no text can "fall behind" because the images never overlay. This will require exporting the image and cutting it, or placing the image multiple times and cropping it. If you go the route of cropping the image within LO Write/MS Word, the resulting document gets large and lags performance. -- 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] Libreoffice extension XML tags
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 libreoffice. I'm looking for the spec that shows what tags this field is allowed under, and what the allowed values are. I see mentions this field is confirmed to be part of the ODF 1.3 spec (which I'm assuming means it (will) require renaming to something like text:contextual-spacing) , but I don't see any list or syntax for ODF 1.3. Thanks! Michael Hart -- 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] AltGr functionality
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 check your mouse/pointer driver. Some mouse drivers can have traps on
control keys.
On Sun, Jun 16, 2019 at 4:07 AM Johnny Rosenberg
wrote:
> Hi!
>
> This is something that I've seen for years and I think it applies to Apache
> OpenOffice as well. Since I live in a country where English is not the
> native language, my keyboard has this AltGr button, I think it's also
> called the ”Right Alt key” (and the regular Alt key is referred to as the
> ”Left Alt key”) in most of the operating systems I've used (currently
> Manjaro, I switched from Ubuntu a couple of years ago). Since my alphabet
> has 29 letters, there are too few keys for the characters @£${[]}\€, so the
> AltGr key is used for that, for instance AltGr+8 → [.
>
> This works perfectly in LibreOffice, no problems there, but it seems like
> the AltGr key is disabled, overridden, in some situations, for instance in
> combination with the arrow keys, so Alt+← has the exact same effect as just
> the ← key by itself.
>
> Do anyone here happen to know why? ←→↓↑ are just keys, like k, c and f.
>
> The reason I ask is that I use my own keyboard layout to make it more
> intuitive to type some characters that are normally not on a keyboard, so I
> rearranged the original layout a bit. Almost every key now can type a
> character with AltGr, in combination with Shift or not. A few examples:
> AltGr+[Enter] → ↵
> AltGr+Shift+[Enter] → ¶
> AltGr+[Tab] → ⇥
> AltGr+Shift+[Tab] → ⇤
> AltGr+[Backspace] → ⌫
> AltGr+Shift+[Backspace] → ⌦
> AltGr+↑ → ↑ (the ↑ character, not the ”move to the line above” feature)
> and more.
>
> Anyway, since the AltGr key seems disabled in combination with these keys,
> I can't type those arrows and things I just mentioned in LibreOffice,
> unless I place them at other keys in my layout, but that would be less
> intuitive (why would AltGr+i be a →? It is on my native default keyboard
> layout, but that doesn't make much sense, does it?).
>
> I mean it's 2019, Unicode has been along for decades and we should be able
> to use it with ease, right? I know there are workarounds, like
> auto-correction and external programs like AutoKey (which I recommend, by
> the way, but only install the latest version; the version in Ubuntu's
> repositories for instance, is very outdated and doesn't work properly).
>
> Also, do you think that writing a bug report about this would lead to
> anything good? I suspect I will get something like ”don't make your own
> keyboard layouts, you moron” in reply at best.
>
> Thanks for listening.
> Kind regards
>
> Johnny Rosenberg
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] insert non-breaking semi-space
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 have this glyph, you can change the font it uses by search/replace to one that does. https://www.fileformat.info/info/unicode/char/202f/browsertest.htm On Fri, Jun 14, 2019 at 6:44 PM Eric Beversluis < ebe...@researchintegration.org> wrote: > Using Libreoffice on Mac Sierra: > > I want to insert a non-breaking semi-space when I have a single quotation > mark next to a double quotation mark: > > John reported, “‘I think you can’t,’ he said.” > > Is it possible to do this in libreoffice writer on Mac, so the two > quotation marks are slightly spaced? I’m not having any luck searching for > this. > > Eric Beversluis > Short fiction at www.ericbeversluis.com > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- 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 corrupted by Ubuntu failed upgrade
When I've had stuff I MUST recover after an event like this, I find the easiest way is to make a new user account, and set the permissions on the old user account folder to either be owned by the new user, or open to the drive, depending on my mood and the distribution's built in networking. I 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 stuff I MUST recover after an event like this, I find the > easiest way is to make a new user account, and set the permissions on the > old user account folder to either be owned by the new user, or open to the > drive, depending on my mood and the distribution's built in networking. > > I can't give you a detailed list, 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:04 AM jonathon wrote: > >> On 4/21/19 10:56 AM, Keith Bates wrote: >> > So I thought I would upgrade from Ubuntu to 18.10 to 19.04. The normally >> >> The only safe way to upgrade from one version of Ubuntu, to another, is >> to wipe the drive, and install the new version of Ubuntu. >> >> > Except Libre Office. >> >> Uninstall LibreOffice. >> Delete _all_ configuration files. >> /home/user_name/config/.libreoffice/* >> >> Delete _all_ files in /opt/libreoffice/* >> from /home/user_name/ >> cd .. >> cd .. >> ls -alR | grep offic >> >> Delete all folders and files that have libreoffice as part of their name. >> >> Then download LibreOffice from >> https://www.libreoffice.org/download/download/ >> >> Unpack and install LibreOffice. >> >> jonathon >> >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? >> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/users/ >> Privacy Policy: https://www.documentfoundation.org/privacy >> > -- 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] Inserting a Trademark Symbol in Label
: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 your cursor where you want the symbol to appear then > > If using Windows (tested with Windows 10 and LibreOffice 6.2.2.2) - > Type 2122 then Alt+X > > If using Linux - > Ctrl+Shift+U and release, then 2122, then enter > > On Tue, Apr 2, 2019 at 6:23 PM Budge wrote: > > > Using Writer with DejaVu Sans font and having created a label using the > > Avery A4 template with Synchronize active, all is well until I try and > > include the Trademark symbol. The advice I have is:- > > > > Place the cursor in the location where you want the symbol to > appear. > > On the Insert menu select Special Character. > > In the dialog that appears, choose Symbol from the Font list.The > > trademark symbol is available in a Serif font (character 212) or in a > > San-Serif font (character 228). ... > > Click OK. > > > > My problem is that once I select Special Characters the Font is shown > > and then a huge list of available Subsets and using for example Basic > > Latin, I get a whole lot of characters, all too big and all overlapping > > so even if the TM symbol is there I cannot see it. > > > > I need some guidance please. > > > > -- > > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > > Problems? > > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: > https://wiki.documentfoundation.org/Netiquette > > List archive: https://listarchives.libreoffice.org/global/users/ > > Privacy Policy: https://www.documentfoundation.org/privacy > > > > > -- > Alan Boba > CISSP, CCENT, ITIL v3 Foundations 2011 > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Concatenate Function inCalc
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). That is erroneous. broken. should-not-happen. This thread is about CONCATENATE being disfunctional in that it accepts ranges, but does not act on them correctly. Please stop referring to CONCAT as the reason that CONCATENATE is broken. However, in regard to CONCAT, I see zero reason for the CONCATENATE function to be separate from CONCAT. CONCATENATE should be replaced with an alias or redirect to CONCAT. But thats not a bug, just poor design. On Tue, Apr 2, 2019 at 9:13 AM Robert Großkopf wrote: > Hi Michael, > > > 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. > > Have opened Calc and looking for fuction CONCATENATE. Help in the dialog > says: "Combines several text items into one." > Then looked for CONCAT. Help in the dialog says: "Combines several text > items into one, accepts cell ranges as arguments." > > I don't see in the help CONCATENATE accepts cell ranges. > > Regards > > Robert > -- > Homepage: http://robert.familiegrosskopf.de > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Concatenate Function inCalc
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? 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] corrupt letter
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 with about 1200 fonts, and ported those to wasta 14 and 16 en mass. I had no issues. I haven't ported this many to wasta 18 yet. On Sun, Nov 25, 2018, 4:45 PM James It is not a format problem because sometimes it works. > It seems to corrupt something in the OS after a while that shows up in > libreoffice. > The most recent problem was '2' was garbled. > > On 2018-11-25 12:09 p.m., Remy Gauthier wrote: > > Hi, > > > > It almost looks like if the "Monthly car payment" string was displayed > > using the date format of the A1 cell. What are the language and > > formats used in the A1 and B1 cells? > > > > Rémy. > > Le mercredi 21 novembre 2018 à 20:05 -0500, James a écrit : > >> I use lubuntu-18.10. > >> Sometimes, a letter gets corrupted but I only see it in libreoffice. > >> > >> This example the 'p' displays as a ',': > >> http://lockie.ca/lubuntu_/libreoffice.jpg > >> > >> I've also seen it when '2' displays garbled. > >> > >> Any ideas about how to track down what software has the problem? > >> > >> > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Calc 6.0.6.2 IF criteria statement help
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 provide the way around the VALUE. If you're trying to make a list of values out of a column of values, investigate CONCATENATE. The problem with concatenate is that it doesn't auto-insert separators and whitespace. You'll either need to include a new column with ", " in each row and concatenate 2 columns, or have the appropriate whitespace in each cell. If you only have a couple cells to concatenate, you can be precise with the & operator. that is [="Hello "&"there!"] allows multiple strings in a single cell, and each string can be cell references or functions with string or numeric output. [="I've seen "&", "&" cells today."] is a nice way to summarize your data in human readable form. If you're trying to only pick a few values, investigate LOOKUP. I'm an excel refugee, (and used Lotus, and 8bit (GEOS) spreadsheets before that.) LibreOffice version of LOOKUP is not very well done, but if you're patient with it, it gets the job done. I frequently have to insert dummy rows containing null cells when I want 'exact match only', and libreoffice can't deal with 'non-sorted' indexes, and they aren't clearly or obvious what the sorting pattern should be, so it's best to sort your data within LibreOffice before you use lookup. (for lookups, a ==A or not, sometimes NBSP == space, but sometimes not. This affects matches, but also sorting.. and sort failures breaks many responses, not just one. These sorting issues are constant for a single edition of libreoffice, but seem to change without any notice on updates.) On Sat, Nov 10, 2018 at 7:44 AM Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za> wrote: > Hi, > > What I need help with is the formula to find any row from Data.$A$3 to > Data$A$1000 and after shortening the 8 digit date value to 6 digit > value, and having the same 6 digit value as Summary.$A4, forward ONLY > those rows onto the next part of the formula i.e. SUMIF. > > I have a formula shown below but currently is showing me #VALUE! as my > result. > > > "=IF(INT(Data.$A$31:Data.$A$50/100)=Summary.$A4,SUMIF(Data.$F$31:Data.$F$50,"N",Data.$C$31:Data.$C$50))" > > I have identified the problem where the INT value = Summary.$A4 > > What would the correct syntax be to have a criteria equal a specified > value as a criteria in a formula? I tried encasing "INT...=Summary.A4", > but no luck. > > SUMIFS does not assist as the criteria to find, after INT shortening > must equal another value before the next step can be carried out. > > Appreciate any help. Where should I upload a file Nabble, GDrive, other? > > Regards > Hylton > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] flat office validation
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 it was valid, but recently I'm having crashes when i try to do things directly related to my .fodt, like view the page style definition, on a document generated outside writer, loaded into writer, saved, program quit, program loaded, then document loaded again. comparisons show a LOT of differences, because writer adjusts everything to its liking, but i don't see any substantive differences. -- 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
