from:"John Kaufmann"

Re: [libreoffice-users] Changing the color of the selected cell in calc

2024-05-07 Thread John Kaufmann


Hi ady,

On 2024-05-06 23:08, ady wrote:
... Is there a way to change the colour of the selected cell in calc to make it easier to see which sell is selected? ... 


In newer versions of LO Calc, ...

... The relevant options is:
menu View > "Column/Row Highlighting"


Would "newer versions" mean something newer than 7.6.5.2? (I don't see that 
option.)

John

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

Re: [libreoffice-users] Permission Issue

2024-04-05 Thread John Kaufmann


Hi Michael,
 
On 2024-04-05 05:33, GMX wrote:

...
When I try to open a document created by LibreOffice with another document 
reader, I receive the message that I don’t have permission to open the document 
and shall contact the owner (me). Did I lock the document while writing it? Is 
there a setting to disable that? ...


What OS? What is the other document reader? Is the document also still open in 
LO (as shown by corresponding lock file in the document's directory)?

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

[libreoffice-users] Custom date field in Calc

2024-03-14 Thread John Kaufmann


A twelve-year-old bug (46448 "... custom local settings for ... date and time formats") inherited 
from OO -- with Importance ranked between "high" and "fatal" -- bites Calc particularly 
hard (that is, harder than Writer), because there is no work-around (that I can see).

In Writer, one can select
 Insert > Field > More fields... [Ctrl+F2]
and be allowed to customize a date or time format different from the default. 
That capability does not exist in Calc (where [Ctrl+F2] instead calls up a menu 
of functions).

In the US i18n, Calc's
 Insert > Date returns a constant in default format "MM/DD/" in the 
selected cell.
but  Insert > Field > Date (to return a variable rather than constant) is 
not even available.

The function TODAY() does return a /calculable/ (virtually variable) date (ironically in 
a different default format "MM/DD/YY"). However, because they are in cells, 
both the constant Date and the calculable TODAY() can be formatted to something more 
useful, like ISO.

But Header and Footer fields are not in cells and cannot be given custom formats (at 
least AFAICS), so selecting the Date field in Header or Footer returns the variable date, 
but still in format "MM/DD/".

All of those formats are fixed by LO's internationalization choices, not 
customizable (and of course not even consistent). [It just happens that the US 
i8n (xx/xx/, or the even worse xx/xx/xx) is the least useful format 
imaginable.]

LO's i18n is by consensus a logical mess (bug #46448 has 75 comments and 21 duplicates), 
so eventually this "fatal" bug will be fixed. In the meantime, has anyone 
figured out a workaround to customize the date and time fields in Calc's header and 
footer?

[FTM, does anyone know why page headers and footers (or Insert > Field...) are 
implemented differently in Writer and Calc (or other modules)?]

John

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

Re: [libreoffice-users] Problem with Libreoffice

2024-02-20 Thread John Kaufmann


Hi larrie,

On 2024-02-20 17:30, larrie ervin wrote:

Whenever i put anything into my spreadsheet it comes up with a red box around 
it. Which i do not want. I would like an explanation or a fix for this.


/Anything/? To troubleshoot unexpected behavior, it helps to narrow the range of inputs that 
produce such behavior. Are you saying that, if you start a new spreadsheet, then type the letter 
"A" (or even the word "Anything") in a cell, there is immediately a red box 
around that cell?



It also makes me delete complete columns or rows instead of select cells that i 
would like to remove.


What do you mean by "remove" a cell? Do you mean to delete its content, or its 
content and formatting, or ...?


Finally [actually, this should be first], to help orient assistance:
1) Please specify the version of LibreOffice and your operating system.
2) Do you have any prior spreadsheet experience? If so, which one? (That may 
help provide a reference for any needed explanations.)

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

[libreoffice-users] Calc Print Preview shows only first page of Print Range

2023-12-11 Thread John Kaufmann


LO 7.4.2.3 (x64)

Print Range is defined ($A$1:$H$236), with Rows to Repeat ($1:$7), but only the 
first page ($A$1:$H$58) shows in Print Preview. (I don't recall having this 
problem before.) Can someone point me aright?

John

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

Re: [libreoffice-users] Importing MP4 files into Writer [was: support]

2023-12-10 Thread John Kaufmann


Hi Yosef,

On 2023-12-10 14:00, Yosef N wrote:

Good afternoon I would like to know if you have a support number.


No, but this list will do. Even when you were using MS Office (which has the 
resources for significant support), were you using a phone number for support?


I searched inGoogle about support and got this number BTW it says there
that you are Open Office?


No. LibreOffice spun off from OpenOffice more than a decade ago.
 

Anyway I use to use Microsoft Office and in Word I was able to copy and
paste videos that I get i WhatsApp to Word with no problem, it says in
property these are MP4 Files and now its 1 year free subscription expired
so I uninstalled it and downloaded of a couple other apps on desktop
including  Openoffice and Libreoffice. Now the problem is that i'm unable
to copy and paste these files anymore on these 2, is there a way to allow
it to paste them?


So your problem is that you were able to import MP4 files into MS Word and are 
not able to import MP4 files into LO Writer?
What were you able to do with these MP4 files in Word, and what are you NOT 
able to do with them in Writer?

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

[libreoffice-users] How to read a Style description

2023-10-20 Thread John Kaufmann


Dealing with a Style definition issue in Draw, I first noticed that the Style 
Inspector tool is not available in Draw (or Calc, for that matter), so 
presumably is a Writer-only tool. The next observation was that, in general, 
styles are not well supported in components other than Writer, so maybe I 
should treat Draw styles with some circumspection. However, this exercise made 
me aware that there is one aspect of styles definition that I do not understand 
in /any/ component, including Writer: It is the style's Organizer tab, in 
particular the *Contains* pane at the bottom of the Organizer tab, which often 
contains statements without definition that I can't locate in the other tabs or 
anywhere.

As an example from Draw, I offer the "Default Drawing Style" (the hierarchical 
root of other Draw styles), which is defined thus:


*Style*
Style: Default Drawing Style
Inherit from: [- none-]
Category: (unspecified)

*Contains*
Continuous + 0.0 inch + 0.08 inch + 0.08 inch + Not centered + Not centered + 
Continuous + Shadow off +
Shadow color + Shadow spacing X 0.1 " + Shadow spacing Y 0.1 " + Left text frame 
spacing 0.1 " + Right text
frame spacing 0.1 " + Upper text frame spacing 0 " + Lower text frame spacing 0 
" + Horizontal text anchor Use
entire width + Word wrap text in shape on + • + Indent left 0.0 inch, Indent 
right 0.0 inch + From top 0.0 inch,
From bottom 0.0 inch + Single + Automatic + Liberation Sans + 18 pt + normal + No underline + No strikethrough 
+ Not Italic + No Outline + Not Shadowed + Pair Kerning + Microsoft YaHei + Lucida Sans + 18 pt + 18 pt +

normal + normal + Not Italic + Not Italic + none + No relief + No overline + 
None


The first major problem is that *Contains*" offers instantiations of properties 
(like {Continuous} or {0.0 inch}) for which *the properties are not identified*.
A secondary general problem is that the instantiations in any case are not 
formalized; for example, should a measurement be {0.0 inch} or {0.0 "} ?
In some cases, like the bullet {•} in the fourth line above, there is no way to 
even guess what is signified.

Even in the Writer Guide, which covers styles in some depth, I find no way to interpret 
this aspect of style definition. The Draw Guide covers styles in a different way, in 
Chapter 4 (Changing Object Attributes) under "Using drawing object styles". But 
neither covers this aspect of style definition.

Is there any guide to how this essential part of a Style description can be 
read and controlled?

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

[libreoffice-users] LO Writer status bar: Page X of Y vs (Page X' of Y' to print)

2023-10-15 Thread John Kaufmann


Writer's status bar always begins with "Page X of Y", but recently I have noticed that in 
some documents it appends " (Page X' of Y' to print)", where X'=X+1 and Y'=Y+1.

Invariably I find that the appended "(Page X' of Y' to print)" is the accurate count of visible pages, while the 
presumably accurate "Page  of " seems to account for some "invisible" page -- but what is 
that? Why are there two counts? What is the difference between "virtual" pages and visible/printable pages?

John

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

Re: [libreoffice-users] Multiple templates based on one

2023-10-12 Thread John Kaufmann


On 2023-10-12 16:32, martin f krafft wrote:

Regarding the following, written by "lo.harald.ber...@t-online.de" on 
2023-10-12 at 19:11 Uhr +0200:

You can edit this document, usually "Untitled1", and save it again as a new 
document template.
See also: 
https://wiki.documentfoundation.org/Videos/Document_Templates_in_Writer


Yeah, I am aware of that. It's not what I am looking for.

I guess I am thinking more like HTML templating. For instance, let's say I have 
a base template, which defines a couple of fundamental paragraph styles, a 
first page, and a default page style, and appropriate headers and footers for 
each.

Now I want to create two new templates: invoices and letters. Both of those are 
not concerned with fundamental styles or headers and footers. They just fill 
the main page area differently.

Hence my thinking is that ideally, the Invoice template should inherit from the 
Basic template in such a way that if I make a change to the headers/footers in 
the basic template, the invoice template automatically updates itself.

… I don't think this is possible… yet? If so, then why stop there? Why are 
templates instantiated and then filled? Why not render a document in the 
context of a template, and only store in the document what is required to do 
so, rather than duplicate everything that's already in the template?


Documents and templates as cascading style sheets? Hmm...

--
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: AW: [libreoffice-users] Labels and Business Cards: where are user definitions stored?

2023-09-07 Thread John Kaufmann


Hi Susanne,

On 2023-09-07 08:43, susanne.mohn...@kiel-pries.de wrote:

...
Perhaps this will help you?
https://wiki.documentfoundation.org/Documentation/DevGuide
https://wiki.documentfoundation.org/Documentation/DevGuide/Configuration_Management

I am also looking for a way to deploy configuration with xml files for a lot of 
users.


Thank you! - I had not seen the Developer's Guide in this morning's search. It 
will help greatly (and addresses other questions I had).

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

Re: [libreoffice-users] Labels and Business Cards: where are user definitions stored?

2023-09-07 Thread John Kaufmann


On 2023-09-07 04:37, Regina Henschel wrote:

...
John Kaufmann schrieb am 07.09.2023 um 05:33:

Under Writer, Labels and Business Cards are substantially identical functions: 
a page array of frames (optionally linked?) to serve as containers for 
printable data (text or images). [For labels, the data are typically (though 
not necessarily) entered via fields defined from a database.] Though these 
forms might be regarded as templates, they are not under the Templates manager. 
For several reasons, it would be nice to manage them more effectively, as a 
forms library. I would elaborate the reasons, but don't want to lengthen this 
post before getting to some basic information, like: Where are these 
definitions stored?


When you save them with "Save" on the "Format" tab of the wizard, you get a 
node in the registrymodifications.xcu
Example:

   
     
   
     PrivateTemplate
   
    
S;8500;5500;8400;5399;499;499;2;5;21001;29799
   
     
   

...

Thank you. Once again you read the lengthy question carefully and reply 
precisely on point; that is a gift.
I found your pointer to the people.freedesktop.org documentation on the 
registry, and much other good background. It is somewhat reassuring that these 
definitions are also regarded as a kind of template, even if not managed under 
the Templates manager.

I had noticed registrymodifications.xcu when I made labels changes, but then 
discounted it, because it is rewritten every time LO closes. OTOH, 
pack\registrymodifications.pack always changes with labels definition changes, 
but not every time LO is used, so I thought registrymodifications.pack must be 
where the labels definitions are stored. Documentation on that relationship 
seems less available.

This will obviously require study, and now I can see a couple more intermediate 
steps needed to get to my goal of a labels forms library. So must become yet 
another addition to my to-do list if I am to get anything else done today. 
Still, you have once again supplied the framework for that study, so I am once 
again in your debt.

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

[libreoffice-users] Labels and Business Cards: where are user definitions stored?

2023-09-06 Thread John Kaufmann

Under Writer, Labels and Business Cards are substantially identical functions:
a page array of frames (optionally linked?) to serve as containers for
printable data (text or images). [For labels, the data are typically (though
not necessarily) entered via fields defined from a database.] Though these
forms might be regarded as templates, they are not under the Templates manager.
For several reasons, it would be nice to manage them more effectively, as a
forms library. I would elaborate the reasons, but don't want to lengthen this
post before getting to some basic information, like: Where are these
definitions stored?

Checking LibreOffice Paths, there are User Paths and Internal Paths; presumably
the Internal Paths point to resources available to all users. All Internal
Paths are of the form (under Windows):
C:Program Files\LibreOffice\program\..\share\, where is:
"autocorr" (for AutoCorrect)
"autotext\en-US" (for AutoText (which is language-specific))
"wordbook" (for Dictionaries)
"gallery"(for Gallery)
For Templates, there are two Internal Paths:
C:Program Files\LibreOffice\program\..\share\template\common;
C:Program Files\LibreOffice\program\..\share\template\en-US;

So "share", like "program", is a first-level subdirectory under "LibreOffice", containing 31 (possibly more) shared subdirectories. Among those are five
{"autocorr", "autotext\en-US", "gallery", "template", "wordbook"} from the "Internal Paths" list, as well as 26 others NOT listed
in "Internal Paths" -- but there is no "template\en-US".

[By comparison with "autotext\en-US", I infer that there may be language-specific templates, but
that there is no such directory as listed in "Internal Paths" because there are no
"en-US"-specific templates. Does that explain it? If so, are there ANY language-specific templates,
for any language? It would be interesting to see how that works.]

Among the 26 shared subdirectories NOT listed in "Internal Paths" is one for "labels".
That sounded promising for my purpose, but had only a single file, "labels.xml", dated 2021-09-08,
so this is obviously not where my labels definitions are stored. [However, labels.xml does include
definitions of business cards (and all other such cards), and I could at least edit it to put the
manufacturers in alphabetical order -- small comfort. ;-) ]

But that still does not expose user-defined labels definitions (which are
appended when LibreOffice loads to the shared definitions in labels.xml) and I
could not find those user-defined definitions. The only thing I could find
under LibreOffice user Appdata, that was at least timestamp-compatible, was a
file pack\registrymodifications.pack. It is a binary file, not readable, and I
don't know how to decode it. Could that be where user definitions reside? If
so,
(a) How is that file read and edited?
(b) Why are user-defined label definitions not in the same kind of XML file as
shared definitions?

John

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

Re: [libreoffice-users] Cool! LibreOffice is free, open source and very good office suite!

2023-08-20 Thread John Kaufmann


On 2023-08-20 08:09, James wrote:

Google "Targeted Individual in Singapore".
The Singaporean government is out to get him.


Ah! - never realized that was a Thing; sometimes curiosity is a rabbit hole.
Thanks [ I think ;-) ]

--
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] Cool! LibreOffice is free, open source and very good office suite!

2023-08-19 Thread John Kaufmann


On 2023-08-18 10:14, Turritopsis Dohrnii Teo En Ming wrote:/

Subject: Cool! LibreOffice is free, open source and very good office suite!
...  
Regards,


Mr. Turritopsis Dohrnii Teo En Ming
Targeted Individual in Singapore


Sorry for the diversionary question, but as I followed this thread, I kept wondering: 
what is a "Targeted Individual"? Is that something to do with Singapore? Can 
you enlighten me?


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

Re: [libreoffice-users] Reading a crash report

2023-07-22 Thread John Kaufmann


Thanks, Mike. I know that I /can/ install cygwin. The point is that I have not, 
so have no idea what the crash report means by that.
jk

On 2023-07-22 22:15, Mike Flannigan wrote:


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


Mike


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


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

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

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


The record for Crash Thread 0 says:

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

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

John





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

[libreoffice-users] Reading a crash report

2023-07-22 Thread John Kaufmann


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

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

Crash ReasonEXCEPTION_ACCESS_VIOLATION_READ
Crash Address   0x148
Crash Thread0
Signature   
IsSelectFrameAnchoredAtPara(SwPosition_const_&,SwPosition_const_&,SwPosition_const_&,DelContentType
 


The record for Crash Thread 0 says:

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

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

John

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

Re: [libreoffice-users] Mail bounce: alarmax...@gmail.com [Was: How can I rejoin this list please?]

2023-07-08 Thread John Kaufmann


Well, we shall see. FWIW, I have no problem sending mail from my (non-gmail) 
ISP to any other gmail users (including myself and my wife and many list gmail 
users, so, on this list - but I doubt many have an outlook.com mail server). 
I'm really curious about the answer.
jk

On 2023-07-08 16:30, Harvey Nimmo wrote:

Just to be clear: the problem occurred when I sent any mail from my
(non-gmail) ISP to a gmail destination. All gmail destinations blocked
all emails from me. The rejection mail I received  told me to make an
SPF or DKIM entry at my ISP (similar to the text in Budge's post on
this). I did what was recommended in the rejection mail and the problem
disappeared. Apparently, Microsoft/outlook/google had made a change
that affected non-customers. My sister reported the same phenomenon
that was similarly corrected.

Cheers
Harvey

On Sat, 2023-07-08 at 16:01 -0400, John Kaufmann wrote:

On 2023-07-08 14:43, Harvey Nimmo wrote:


I had this problem with any email sent to a gmail account. ...


I doubt it's so simple, Harvey. I have no such problem with my own
gmail account (which has no outlook.com server in the mix).
jk


--
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 bounce: alarmax...@gmail.com [Was: How can I rejoin this list please?]

2023-07-08 Thread John Kaufmann


On 2023-07-08 14:43, Harvey Nimmo wrote:


I had this problem with any email sent to a gmail account. ...


I doubt it's so simple, Harvey. I have no such problem with my own gmail 
account (which has no outlook.com server in the mix).
jk

--
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 bounce: alarmax...@gmail.com [Was: How can I rejoin this list please?]

2023-07-08 Thread John Kaufmann


Hi Budge,

I suspected (and still suspect) that the mail configuration for 
alarmax...@gmail.com is at least partly implicated in the problem, because the 
list probably (almost surely?) has other gmail users (the list admin could 
confirm that), none of which bounce posts. IAC, (a) I have no problem sending 
mail for the account I'm currently using to my gmail account, which (b) has 
/no/ handling by an outlook.com server.

I also suspected that the list SMTP server might be implicated, because and my 
direct mail to alarmax...@gmail.com seemed to be received normally (as I 
expected from my own gmail account).  However, 10 hours(!) after sending that, 
I also got a bounce response to my direct mail, so the problem is not limited 
to list mail. Moreover, the long delay on my DM bounce adds to the strangeness: 
what kind of mail server takes so long to issue a bounce error message? - 
curiouser and curiouser - again, though, it was not a /gmail/ bounce. IAC, I 
forwarded that bounce to my ISP for response and, like you, will post the 
results.

Kind regards,
John


On 2023-07-08 14:15, Budge wrote:

Hi John,
I checked out the Google link on authentication and it seems that the problem 
probably lies with my ISP.  I have asked him to check the headers to find out 
if the problem is with him or further away. Will let you know what I learn.
Regards,
Budge.

On 07/07/2023 17:45, John Kaufmann wrote:

Your email has not been hacked. All of my (and presumably others') posts to the 
list in the last few days have returned that bounce from alarmax...@gmail.com - 
probably a list subscriber. The first obvious curiosity about this is that it's 
a gmail address, but the bounce comes from postmas...@outlook.com, so it's not 
gmail bouncing the message; likely there's an interesting mail configuration 
issue -- and on the list side as well, since the bounce is returned to the 
poster rather than to the list.

As alarmax...@gmail.com is the only list subscriber bouncing list mail, I wrote 
directly, to see if there is a response from my email address. It did NOT 
bounce, so the problem presumably lies in a list configuration interaction with 
that user's mail configuration. If there is a reply, I will of course report it.

jk

On 2023-07-06 11:02, Budge wrote:


... something strange happened in the background when I first asked how to 
renew.
I had from postmas...@outlook.com the following message:-

*mx.google.com rejected your message to the following email addresses:*

alarmax...@gmail.com
Your message wasn't delivered because the recipient's email provider rejected 
it.

*mx.google.com gave this error:
This mail is unauthenticated, which poses a security risk to the sender and 
Gmail users, and has been blocked. The sender must authenticate with at least 
one of SPF or DKIM. For this message, DKIM checks did not pass and SPF check 
for [errichel.co.uk] did not pass with ip: [2a01:111:f400:7e8b::207]. The 
sender should visit https://support.google.com/mail/answer/81126#authentication 
for instructions on setting up authentication. 
p13-20020a056402074d00b0051bfa6da365si551974edy.585 - gsmtp
*

No idea why or what.  Whoever uses Outlook anyway but does it mean my mail has 
been hacked?








--
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] Mail bounce: alarmax...@gmail.com [Was: How can I rejoin this list please?]

2023-07-07 Thread John Kaufmann


Your email has not been hacked. All of my (and presumably others') posts to the 
list in the last few days have returned that bounce from alarmax...@gmail.com - 
probably a list subscriber. The first obvious curiosity about this is that it's 
a gmail address, but the bounce comes from postmas...@outlook.com, so it's not 
gmail bouncing the message; likely there's an interesting mail configuration 
issue -- and on the list side as well, since the bounce is returned to the 
poster rather than to the list.

As alarmax...@gmail.com is the only list subscriber bouncing list mail, I wrote 
directly, to see if there is a response from my email address. It did NOT 
bounce, so the problem presumably lies in a list configuration interaction with 
that user's mail configuration. If there is a reply, I will of course report it.

jk

On 2023-07-06 11:02, Budge wrote:


... something strange happened in the background when I first asked how to 
renew.
I had from postmas...@outlook.com the following message:-

*mx.google.com rejected your message to the following email addresses:*

alarmax...@gmail.com
Your message wasn't delivered because the recipient's email provider rejected 
it.

*mx.google.com gave this error:
This mail is unauthenticated, which poses a security risk to the sender and 
Gmail users, and has been blocked. The sender must authenticate with at least 
one of SPF or DKIM. For this message, DKIM checks did not pass and SPF check 
for [errichel.co.uk] did not pass with ip: [2a01:111:f400:7e8b::207]. The 
sender should visit https://support.google.com/mail/answer/81126#authentication 
for instructions on setting up authentication. 
p13-20020a056402074d00b0051bfa6da365si551974edy.585 - gsmtp
*

No idea why or what.  Whoever uses Outlook anyway but does it mean my mail has 
been hacked?



--
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] Help please with multipage document.

2023-07-06 Thread John Kaufmann


On 2023-07-06 15:39, Budge wrote:

I see the screenshot didn't copy.  Is this a settings thing here or rule for 
the site?


The list works in plain text, not HTML, and does not take attachments. If you 
want to show a screenshot, best to use a sharing service like Dropbox and cite 
the URL.

--
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 can I rejoin this list please?

2023-07-06 Thread John Kaufmann


On 2023-07-06 05:15, Budge wrote:

I disconnected a year ago and now wish to subscribe.  Please advise how I can 
join. ...


If not now subscribed, just send mail, Subject: "Subscribe", to: LibreOffice Users 
.

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

2023-07-02 Thread John Kaufmann

Harald, thank you. Though I normally use a CAD program for building projects
(because of libraries, BOM automation and all of the other benefits of
specialized drafting software), I have used Draw for small projects, for all
the reasons given in your link: because it's quick and easy, especially when
there is a need for special objects not in a CAD library, like custom kitchen
cabinet details. So thought I knew how to apply Draw to that task, but I
learned new tricks from that explanation.

I appreciate that,
John

On 2023-07-02 13:44, lo.harald.ber...@t-online.de wrote:

Hi,

can that help?
https://wiki.documentfoundation.org/Videos/Electrical_installation_plans

Regards
Harald

Am 02.07.2023 um 19:39 schrieb Vince@Verizon:

I am using Windows10x64bit Home on DELL desktop and LO 7.3.2.2 (x64) /
LibreOffice Community.

I have never made any use of the LO Draw module in the past, and wonder if it
is suitable for creating a 2-dimension drawing that shows room layout with
dimensions, to scale if possible.

My immediate need is to create a document/drawing of the household room
dimensions, e.g., square footage dimensions, as if I needed to paint the
ceiling or the walls or needed to lay down carpeting or hard wood flooring, or
calculate/show square footage of lawn areas, etc.

Is LO Draw the appropriate module for me to learn? Or, is there some other
program that is simpler to learn and to use?

Up till now I have been making a hand sketch of the area of interest, scan the
sketched layout, create a PDF and then type/enter dimensions as text
annotations within the PDF. I think there might be a simpler method.

I look forward to receiving suggestions/comments from the LO Draw community users. In the meantime, I will be reading the LO Draw Users Guide.

Re: [libreoffice-users] Incorrect envelope dimensions passed to print driver

2023-04-12 Thread John Kaufmann


To the base description below, I should add a couple points:

(1) We have an easy alternative to print these envelopes: Export the file as 
.DOCX to MS Word, which passes the page size and orientation without hiccups, 
then prints directly. [I found that I could also export the .ODT file to Word, 
but then it needs some repair before printing is possible.]  But I'm trying to 
fix this because I want to use LibreOffice, not MS Office.

(2) When printing from LO Writer, the Print dialog box has not only a "Preview" section 
on the left side, but a "Page Layout" section on the lower right side (which seems 
initially disconnected from the Preview section). The Page Layout section has two fields:
 - "Paper size" [initially blank, and cannot be changed until the "Orientation" 
field is triggered];
 - "Orientation" [initially "Automatic"; the other options are "Portrait" (which then *GETS THE RIGHT 
DIMENSIONS, BUT WITH ORIENTATION REVERSED*!) and "Landscape" (which, though it is the correct orientation, does nothing until the 
"Paper size" field is triggered -- and then the "Paper size" field does not have a matching entry).

This seems to sharpen the troubleshooting focus, but I know nothing about the 
LO-print_driver interface, and in particular know nothing about why the Print dialog box 
has yet another "Paper size" list from the one LO maintains for Page format and 
the one that the print driver maintains for printer operation.  Where can I get 
information about these structural questions?


On 2023-04-12 03:20, John Kaufmann wrote:

LibreOffice 7.4.2.3, Windows 10 -
Before reporting this as a bug, I would like to put this question here, because 
I am missing something.

LO includes in its paper size library "#6-3/4 Envelope", a common North 
American size defined as:
  3-5/8 (3.63) in (inches) high by 6-1/2 (6.5) in wide in the customary 
landscape orientation.
When selected as the paper format, it sets up perfectly ... until it's time to 
print.
Then it passes to the "Print" dialog box (for a Konica Minolta C368, in either 
PS or PCL6 driver) a size of
  6.5 in high by 5.5 in ("User Defined") wide.
That of course is not landscape orientation, and the accompanying figure (on the left 
side of the Print dialog box) is shown accordingly - that is, in portrait, not landscape, 
orientation.  Yet if I select "Properties" in the dialog box, to go to the 
printer driver's own settings, it is portrayed in landscape orientation, though still 
incorrectly sized:
  5.5 in high by 6.5 in wide ("Custom Size").

The fact that orientation shifts when passed to the Print dialog box, then 
shifts again when passed to the printer driver, clearly seems to be a bug, and 
I intend to report it as such -- as soon as I understand why dimensions change. 
 Moreover, what is passed to the Print dialog box is specific to the print 
driver.  For printers I had available, different drivers yielded the following:
   High  Wide  Printer / Driver
   3.63  6.50  *Original document in LO 7.4.2.3*
   3.08  3.63  Brother HL-L2360
   8.50 11.00  Epson XP-6100
   8.50 11.00  HP LaserJet 2200 (PCL5)
   6.50  5.50  KM C360 or C368 (PCL6 or PS)
   8.50 11.00  MS Windows Print to PDF
   3.63  6.50  MS Windows Fax [*THIS GETS IT RIGHT* and even identifies "#6 3/4 
(Personal) Envelope"]
   3.63  6.50  MS XPS Document Writer [*THIS GETS IT RIGHT* (same as Fax)]
   8.00 11.00  OneNote

Bottom line: It's clearly possible to get this right, but rare; most 
printers/drivers tested got it wrong in one way or another.  Of course this is 
not just about a particular envelope size, or even envelopes generally; it is 
clearly a paper size issue.  Bug 146213 (filed in Dec.2021 for LO 6.3.0.4) 
traced a similar problem for B5 paper size. It was never assigned, so never 
resolved, so I'm trying to take a more systematic approach.  Is there a 
coherent way of thinking about this?

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

[libreoffice-users] Incorrect envelope dimensions passed to print driver

2023-04-12 Thread John Kaufmann


LibreOffice 7.4.2.3, Windows 10 -
Before reporting this as a bug, I would like to put this question here, because 
I am missing something.

LO includes in its paper size library "#6-3/4 Envelope", a common North 
American size defined as:
 3-5/8 (3.63) in (inches) high by 6-1/2 (6.5) in wide in the customary 
landscape orientation.
When selected as the paper format, it sets up perfectly ... until it's time to 
print.
Then it passes to the "Print" dialog box (for a Konica Minolta C368, in either 
PS or PCL6 driver) a size of
 6.5 in high by 5.5 in ("User Defined") wide.
That of course is not landscape orientation, and the accompanying figure (on the left 
side of the Print dialog box) is shown accordingly - that is, in portrait, not landscape, 
orientation.  Yet if I select "Properties" in the dialog box, to go to the 
printer driver's own settings, it is portrayed in landscape orientation, though still 
incorrectly sized:
 5.5 in high by 6.5 in wide ("Custom Size").

The fact that orientation shifts when passed to the Print dialog box, then 
shifts again when passed to the printer driver, clearly seems to be a bug, and 
I intend to report it as such -- as soon as I understand why dimensions change. 
 Moreover, what is passed to the Print dialog box is specific to the print 
driver.  For printers I had available, different drivers yielded the following:
  High  Wide  Printer / Driver
  3.63  6.50  *Original document in LO 7.4.2.3*
  3.08  3.63  Brother HL-L2360
  8.50 11.00  Epson XP-6100
  8.50 11.00  HP LaserJet 2200 (PCL5)
  6.50  5.50  KM C360 or C368 (PCL6 or PS)
  8.50 11.00  MS Windows Print to PDF
  3.63  6.50  MS Windows Fax [*THIS GETS IT RIGHT* and even identifies "#6 3/4 
(Personal) Envelope"]
  3.63  6.50  MS XPS Document Writer [*THIS GETS IT RIGHT* (same as Fax)]
  8.00 11.00  OneNote

Bottom line: It's clearly possible to get this right, but rare; most 
printers/drivers tested got it wrong to in one way or another.  Of course this 
is not just about a particular envelope size, or even envelopes generally; it 
is clearly a paper size issue.  Bug 146213 (filed in Dec.2021 for LO 6.3.0.4) 
traced a similar problem for B5 paper size. It was never assigned, so never 
resolved, so I'm trying to take a more systematic approach.  Is there a 
coherent way of thinking about this?

John

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

Re: [libreoffice-users] Rotating labels to landscape

2023-02-13 Thread John Kaufmann


Hi Michael,

On 2023-02-12 15:32, Michael H wrote:

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


I don't disagree, but it's a matter of context: Rod asked a LibreOffice 
question in a LibreOffice forum, so I gave a LibreOffice answer. I respect your 
effort to widen the context [like you, I'm also dedicated to maximizing 
efficiency and minimizing waste], and the same thought occurred to me at the 
time, but did not widen the context for a few reasons:
(1) Rod asked about a specific form, so he already had his form.
(2) When/If Rod runs out of Avery 5388, he can revisit his choice of form ... but 
I don't know of a cardstock form of 3"x5" cards arranged 2x2. Do you?
(3) A 1x3 format uses 48% of a letter-size (8.5x11) sheet, while a 2x2 
format uses 64% -- a welcome improvement, but (a) obviously neither is great in 
that context, and (b) the 1x3 format may be more efficient in non-material 
ways, such as the presentation on his screen.

IOW, the most efficient choice may not be knowable to us without a lot more 
information and context.

John

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

Re: [libreoffice-users] Rotating labels to landscape

2023-02-11 Thread John Kaufmann


Hi Rod,

On 2023-02-11 21:52, Roderick Anderson wrote:

On 2/11/23 11:21, John Kaufmann wrote:

On 2023-02-11 13:28, Roderick Anderson wrote:

...
I have a need to create some 3X5 index cards with the content oriented along the 
3" axis.
I'm having no joy rotation the label form (Avery 5388) to landscape. ...


Trying to understand what you want to do that, I looked at Avery 5388, which has 3 3"x5" cards 
(labels, for form purposes) arranged (landscape) vertically on what appears to be an 8.5"x11" 
(portrait) card sheet, with unused borders on that sheet of 1" top/bottom, 1.75" left/right. 
Correct?

And you want to treat each card/label as if it were in portrait orientation for text purposes? 


Yes. This is what I want to do.


OK, then, lets start with the simplest way (easy as 1-2-3, literally):

(1) Forget the label template.

(2) Treat the card sheet in landscape mode (which puts the cards in portrait mode) by defining your page 
(either Format the Default Page Style or define a new "Index Cards" style from the Default Page 
Style): With either the new or Default Page Style, go to the Page tab and define it with Format=Letter, 
Orientation=Landscape, with margins L=1", R=1", T=1.75", B=1.75", then OK.

(3a) Now define a 3-column/1-row table (which will automatically be set to three 
3"-wide columns; if not, you can make it so).
(3b) Set the table's row height (Table>Size>Row height) to 5".
(3c) Set the table's borders (Table>Properties>Borders tab) as you like. I'd 
suggest no lines, but you may want non-zero padding.

Now you're ready to go -- and because the page/sheet is in Landscape mode, you 
have all three cards on your computer screen, at maximum size for maximum 
convenience.

Variation on this approach: You could substitute three 3"x5" frames for the 
three-column table; same idea, just slightly more work.

Hope that helps,
John

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

Re: [libreoffice-users] Rotating labels to landscape

2023-02-11 Thread John Kaufmann


On 2023-02-11 13:28, Roderick Anderson wrote:

...
I have a need to create some 3X5 index cards with the content oriented along the 
3" axis.
I'm having no joy rotation the label form (Avery 5388) to landscape. ...


Trying to understand what you want to do that, I looked at Avery 5388, which has 3 3"x5" cards 
(labels, for form purposes) arranged (landscape) vertically on what appears to be an 8.5"x11" 
(portrait) card sheet, with unused borders on that sheet of 1" top/bottom, 1.75" left/right. 
Correct?

And you want to treat each card/label as if it were in portrait orientation for 
text purposes?  If so, there are different ways to accomplish that, but before 
going further please confirm or correct that understanding (no point giving 
answers to the wrong question).

John

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

Re: [libreoffice-users] Islamic Calendar Dates

2022-12-10 Thread John Kaufmann


On 2022-12-08 18:13, Toki wrote:

...
In Islam:
* The new day begins at sunset.
* The new month begins at sunrise, after the new moon has been sighted.

Judaism, is slightly more logical. Both the new day and new month begin at 
sunset.
The new month begins on the sunset of the day that the new moon was sighted.

By way of example.
Sunset is at 5:00 PM  on Thursday.
The New moon is sighted at 5:10 PM on Thursday.
In Islam, the first of the month starts at sunrise on Friday.
In Judaism, the first of the month starts at sunset on Friday.
(If you want to be technical, replace _Judaism_ with _Karaite Judaism_.)

When going through journals of pious Muslims, you will occasionally see dates 
like 30 Shaʿbān 12th hour immediately followed by 1 Ramaḍān 13th hour.The first 
through twelfth hour doesn't exist for 1 Ramadan.
This is why knowing what assumptions are made about the converted date are 
important.


When I found the questions interesting, I did not imagine how interesting: that 
the last day of each month is also the first day of the following month -- not 
just for Shaʿbān to Ramadan, but for all monthly transitions. The implications 
are fascinating.

That said, your use of "12th hour" suggests that "sunset" and "sunrise" are (like 
Gregorian "midnight") formal based on a 24-hour day, not literal - correct?

[Sorry that you came to the list for answers, and ended up providing answers. 
Sadly, the topic is esoteric, but it is important.]

--
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] Islamic Calendar Dates

2022-12-07 Thread John Kaufmann


On 2022-12-07 19:57, Toki wrote:

All:

When LibreOffice converts Gregorian to/from Islamic Calendar dates, when does 
it assume that the new Islamic day begins:
* Sunset;
* Midnight;
* Sunrise;

When LibreOffice converts Gregorian to/from Islamic Calendar dates, when does 
it assume that the first of the Islamic month begins:
* Sunset;
* Midnight;
* Sunrise;


I'm completely ignorant in this area but find the questions interesting.
However, doesn't the second (on first principles) follow from the first?

--
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: Threading [was: Header beginning on page 2?]

2022-11-29 Thread John Kaufmann


And yet... this time your reply (containing *both* In-reply-to and References 
headers, for the first time) threaded! Be it ever so curious, I withdraw my 
question. Thanks for satisfying my curiosity.

BTW, my prior post used Reply-All (rather than Reply-List) because I was not 
sure about how you were receiving. Now that I see Reply-List works for you, 
that [my norm on this list] is what I'm using - so you won't see double ;-)

On 2022-11-29 23:58, RealNameTBA wrote:

Truly don't know. It's never been an issue. And for a long time now replyto: 
has had issues such that I considered its use to be bad practice -- indeed, it 
screws up many mailing lists. (For example, this is the one list I'm on that 
seems to reply to both the original poster and to the list, resulting in 
duplicates. There may be sound reasons for this, but elsewhere it's been seen 
as a misconfiguration and has been eradicated almost immediately.) Not 
complaining, just explaining why my mailer is configured as it is.

On Tue, Nov 29, 2022 at 11:51 PM, John Kaufmann  wrote:


Dear RealNameTBA-as an aside to questions about LO operation: One can't help 
notice that none of your posts are threaded (because of the absence of 
In-reply-to and References headers). Does ProtonMail not support (a) 
Reply-to-List and (b) threading generally?


--
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] Threading [was: Header beginning on page 2?]

2022-11-29 Thread John Kaufmann


Dear RealNameTBA-as an aside to questions about LO operation: One can't help 
notice that none of your posts are threaded (because of the absence of 
In-reply-to and References headers). Does ProtonMail not support (a) 
Reply-to-List and (b) threading generally?

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

2022-11-27 Thread John Kaufmann


On 2022-11-27 18:45, RealNameTBA wrote:

... [The problem is] this (as illustrated in the small attached
screenshot fragment): ...

The first thing to be noted is that by now you are aware that the attachment 
did not make it to this list. Sorry, that's just the state of things, so it's 
necessary to be as descriptive as possible. To that end:


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

A little more descriptive: Is the splitting done such that the right ends of 
the line are aligned (or would be aligned with a monospace font), as if to put 
the same number of characters in each line?


... If I save the file and open it in something else, the words are
wrapped normally, ...


Saving the file as .ODT?  If not, in what format?  In what did you open it, 
that presented properly?

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

[libreoffice-users] Position references

2022-10-15 Thread John Kaufmann


[Please excuse that the initial attempt to post this used HTML (for a table, to 
enhance clarity) but that was more mangled than anticipated in the list 
conversion to plaintext. So (again for clarity) I post again, in plaintext.]


Anchoring an entity (frame, box, image, ...) is done with respect to position 
references:
*Horizontal*:
Paragraph area
Paragraph text area
Left paragraph border
Right paragraph border
Left page border
Right page border
Entire page
Page text area
*Vertical*:
Margin
Paragraph text area
Entire page
Page text area

Where are these references defined?  They are not covered in the Help or the 
Writer Guide or the OpenDocument Format OASIS standard, and the names and 
experimentation have not given a clear picture. For example, what are these 
differences:
1. Top (or Bottom) with respect to Margin or Page text area?
2. Left with respect to Left page border or Entire page?
3. Left with respect to Left paragraph border or Paragraph area or 
Paragraph text area or Page text area?
4. Right with respect to Right page border or Entire page?
5. Right with respect to Right paragraph border or Paragraph area or 
Paragraph text area or Page text area?

I'm sure these references are defined somewhere, and I have just missed it; can 
someone point me in the right direction?  If there is not a little graphical 
aid somewhere, I would like to produce one, but don't have the clarity of 
definitions to do so.

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

[libreoffice-users] Position references

2022-10-15 Thread John Kaufmann

Anchoring an entity (frame, box, image, ...) is done with respect to
position references:Horizontalreferences:Verticalreferences:Paragraph 
areaParagraph text areaLeft paragraph borderRight paragraph borderLeft page 
borderRight page borderEntire pagePage text areaMarginParagraph text areaEntire 
pagePage text areaWhere are these references defined?  They are not covered in 
the
Help or the Writer Guide or the OpenDocument Format OASIS standard,
and the names and experimentation have not given a clear picture. 
For example, what are these differences:
* Top (or Bottom) with respect to Margin or Page text area?
* Left with respect to Left page border or Entire page?
* Left with respect to Left paragraph border or Paragraph area
or Paragraph text area or Page text area?
* Right with respect to Right page border or Entire page?
* Right with respect to Right paragraph border or Paragraph area
or Paragraph text area or Page text area?I'm sure these references are 
defined somewhere, and I have just
missed it; can someone point me in the right direction?  If there is
not a little graphical aid somewhere, I would like to produce one,
but don't have the clarity of definitions to do so.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

Re: [libreoffice-users] Writer Character styles: "Default Paragraph Font" vs "No Character Style" vs "- None -"

2022-10-10 Thread John Kaufmann


Hi Michael,

I apologize for taking days to reply. As I noted to Harald, I had to get 
through a week's emergencies to be able to think about what you both had 
written.

On 2022-10-02 10:01, Michael H wrote:


If you save your document as .fodt - Flat Opendocument, you can then open the 
document in a plain text editor and see exactly what each style does.  That is 
you'll be able to see the underlying XML spelled out.


Thanks. I did so. It was instructive, but what I learned most (in a couple 
hours of study) was to get a sense of how much time I might need to build tools 
to parse a Writer file (which I presume you have done already) -- and I just do 
not have the much time now, or even this year. (It would be rewarding to return 
to that someday.)

However, regarding the specific question of inheritance (from "-None-" or from "No 
Character Style"), your answer was particularly helpful:

...
- ... "none" means you get the "create new style" dialogs with no parent style 
filled in.  This means the character style definition will be more complete, and rely less on the 
parent style.


Yes, that I understood.


- the "No Character Style" option while typing doesn't insert XML for a 
character style, but moves the editing cursor after the already open Character style if 
you're at the end, or creates an end/open for the style if there are more visible 
characters and leaves the cursor in between these tags.


If I select "No Character Style" as the parent of a Character style, do I not get the 
same effect as selecting "-None-"?

Thanks again,
John

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

Re: [libreoffice-users] Writer Character styles: "Default Paragraph Font" vs "No Character Style" vs "- None -"

2022-10-10 Thread John Kaufmann

Hi Harald,

i apologize for taking days to reply. After a week of work emergencies, I have
finally had a chance to digest your link and think through the issues.

On 2022-10-02 12:35, lo.harald.ber...@t-online.de wrote:

Am 02.10.2022 um 14:30 schrieb John Kaufmann:

On 2022-10-02 02:50, lo.harald.ber...@t-online.de wrote:

Am 02.10.2022 um 07:06 schrieb John Kaufmann:

...

Discussing Character styles, the Help says of the particular style "No Character
Style" that:

"No Character Style is actually the set of character properties of the current
paragraph style. Choose No Character Style to reset the character properties of the
selection to those of the paragraph style."

That sounds fine -- a needed function (though it is new in LO 7, isn't it?).

Yes and No, this Character Style is called "Default" in older LibreOffice
versions.

Thank you. After thinking about your point, I realize that the "Default" character style was
renamed "No Character Style" for the benefit of dummies (like me) who did not see the point
earlier, that "Default" means revert to the character attributes of the underlying paragraph style.
(No release notes are needed for that.)

That said, this exposes my second problem:

But then how does that differ from the particular style "Default Paragraph Style" (about
which the Help is silent)? Is not the Default Paragraph Style already set by the current Paragraph
style? What does it mean to designate a Character style as "Default Paragraph Style"?

The "Default Paragraph Style" is sort of the mother of all paragraph styles, IMHO it
should not be used, but "Text Body" instead.

I'm sorry, but isn't "Text Body" a Paragraph style, not a Character style? My question is about the different purposes
of the /Character/ styles "Default Paragraph Style" [about which, as I asked, What does it mean to designate a
/Character/ style as "Default Paragraph Style"?], "No Character Style" and "- None -".

I must have misunderstood that then.

If you misunderstood, it was only because my question was confused. What I did not know then about the "Default
Paragraph Style" *character* style is that it was *NOT* part of the LO package, but was a *custom* character
style, produced in our office to try to produce what LO's "Default"/"No Character Style" already
provided (and was given the name "Default Paragraph Style" (which happens to be the same name as the base
*paragraph* style) to emphasize its purpose: to revert any character attributes to the default attributes defined by
the relevant paragraph style).

I apologize for the noise in that regard; before posting, I should have noticed
that it was a *custom* character style. (When I realized that -- and that it
was unnecessary and confusing -- I removed it from the system.)

Finally: though "- None -" is not among the pre-defined Character styles, it is among the parent choices when
defining a new Character style. How does the behavior of a Character style change when "Inherit from" is set
to ... "No Character Style" vs "- None -"? [I have not detected a difference.]

...
Let's look at it from the text. Let's say you have written 10 paragraphs and
each paragraph has a different paragraph style.
Now you want to bold one word in each paragraph. You select the words and assign the
character style "Strong Emphasis" to each.
Now you have added one word too many with the character style sheet "Strong
Emphasis".
You now select the word and assign the "No Character Style" character style
sheet. The word now has its old format meaning again.

Here is some more, I hope, helpful information:
https://wiki.documentfoundation.org/Videos/Professional_work_in_Writer

...

That was very good [though I could offer a couple minor suggestions*], but I'm
sorry to have given the impression that I was unaware of either (a) the basic
value of styles or (b) the relationship of Writer's character to paragraph
styles.

The most important thing I learned from your link was about the Style
Inspector, a great addition to the LO toolset. I'm embarrassed that I did not
remark on it when I moved to LO 7, and somehow managed to work with the other
Sidebar tools (mostly Navigator and Styles) without noticing it.

[* I mentioned that I could offer two minor suggestions on your link. In doing
so, I recognize that these are problems inherent in any system produced in
multiple languages: How to name something in translation? However, since the
page was translated from German (Professionelle Arbeit in Writer) to English
(Professional work in Writer), I assume that the translation wants to use the
corresponding English naming used in the LO system. To that end,
(1) "Delete Dir

Re: [libreoffice-users] Writer Character styles: "Default Paragraph Font" vs "No Character Style" vs "- None -"

2022-10-02 Thread John Kaufmann

On 2022-10-02 02:50, lo.harald.ber...@t-online.de wrote:

Am 02.10.2022 um 07:06 schrieb John Kaufmann:

Discussing Character styles, the Help says of the particular style "No Character
Style" that:

That sounds fine -- a needed function (though it is new in LO 7, isn't it?).

Yes and No, this Character Style is called "Default" in older LibreOffice
versions.

Do you know exactly when it changed? I'm searching for release notes.

The "Default Paragraph Style" is sort of the mother of all paragraph styles, IMHO it
should not be used, but "Text Body" instead.

Finally: though "- None -" is not among the pre-defined Character styles, it is among the parent choices when defining
a new Character style. How does the behavior of a Character style change when "Inherit from" is set to "Default
Paragraph Font" vs "No Character Style" vs "- None -"? [I have not detected a difference.]

Unfortunately, I did not understand your last paragraph (sorry). Why vs?

Sorry. The contraction "vs" [versus] is simply a shorthand way of contrasting
members of a class. In other words, what is the difference between Inheriting a Character
style:
- from "Default Paragraph Font" or
- from "No Character Style" or
- from "- None -" ?

Here is some more, I hope, helpful information:
https://wiki.documentfoundation.org/Videos/Professional_work_in_Writer

Thanks. I look forward to seeing that. Unfortunately, for the past hour the
status of that URL is:

"Sorry! This site is experiencing technical difficulties."

"Try waiting a few minutes and reloading."

"(Cannot access the database: Unknown error (localhost))"

I will keep trying that, because it sounds promising. As you say, there is a
change here (which makes sense; Character styles have always suffered somewhat
from unclear motivation). I'm sure that there are release notes on this topic
somewhere, but don't know where to find them. However, I will continue looking,
and am currently looking in:

<https://bugs.documentfoundation.org/buglist.cgi?quicksearch=%22Character%20style%22>.

I appreciate your response.
Kind regards,
John

[libreoffice-users] Writer Character styles: "Default Paragraph Font" vs "No Character Style" vs "- None -"

2022-10-01 Thread John Kaufmann


Discussing Character styles, the Help says of the particular style "No Character 
Style" that:


No Character Style is actually the set of character properties of the current 
paragraph style. Choose No Character Style to reset the character properties of 
the selection to those of the paragraph style.


That sounds fine -- a needed function (though it is new in LO 7, isn't it?).  But then how does 
that differ from the particular style "Default Paragraph Style" (about which the Help is 
silent)?  Is not the Default Paragraph Style already set by the current Paragraph style?  What does 
it mean to designate a Character style as "Default Paragraph Style"?

Finally: though "- None -" is not among the pre-defined Character styles, it is among the parent choices when defining 
a new Character style.  How does the behavior of a Character style change when "Inherit from" is set to "Default 
Paragraph Font" vs "No Character Style" vs "- None -"? [I have not detected a difference.]

John

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

Re: [libreoffice-users]

2022-09-21 Thread John Kaufmann


Hi Robert,

On 2022-09-21 12:03, Robert Großkopf wrote:


That said, I can't say that I've noticed the change.  Was this a change? If so, 
at what point?  If we know that, the most useful place to start is probably 
with the release notes.


Has been in edit-menue of Writer also in older versions. Opend LO 6.1.5.2 and 
it is already part of edit-menue.


Thanks for checking that. I'm not very observant, so it's nice to know that I 
did not miss a change.
Now I really don't understand what promoted the question ("Keep 'Go to Page' option 
in view menu...").

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

Re: [libreoffice-users]

2022-09-21 Thread John Kaufmann


On 2022-09-20 10:02, rajpal bisht wrote:

Keep 'Go to Page' option in view menu not in edit menu


It's a small thing, but -- if you are posting that recommendation here, rather than 
in Bugzilla , in order to test sentiment 
-- I will agree with you: putting 'Go to Page' (Ctrl-G) in the View menu, rather than 
the Edit menu, would seem more logical and more consistent with other applications.


That said, I can't say that I've noticed the change.  Was this a change? If so, 
at what point?  If we know that, the most useful place to start is probably 
with the release notes.


I suspect there are two reasons for never thinking about this:

(1) The keyboard Go-to (Ctrl-G) is mnemonically natural enough (and therefore 
quick) that I'm never tempted to mouse through a menu for the function.

(2) More important, LO does not have in any form (via keystrokes or menu) the 
usual complement to 'Go-to', which is 'Go-back' (return to prior page/view, 
usually implemented via something like Alt-LeftArrow).  Without a complementary 
'Go-back', 'Go-to' lacks the utility to be a compelling part of the toolkit.  
It might be most useful to address that before thinking about where to organize 
the function in the menu.

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

Re: [libreoffice-users] Text Box - Font Size Changing in Libre Writer

2022-09-13 Thread John Kaufmann


On 2022-09-13 21:16, charles meyer wrote:


I've only used text angling in a text box in Libre Writer once a while ago.

I think I chose Format > Text Box and there's a text direction where you
can pull this dial icon and it moves the test in any direction 360 degrees
which is cool.

The challenge is now I want to enlarge that text in the text Box but I
don't see the Font Style or Size in there.

How does one change the font size in the Text Box?


A text box is like text in a frame, in this basic sense: The whole (text-in-box 
or text-in-frame) is composed of two parts, the text and the box/frame. The 
text in either case is handled simply by text attributes: Select (highlight) 
the text, then select the desired attribute(s).  If your attempts to select the 
text, rather than the box/container, are not successful, either zoom in or 
temporarily enlarge the box to allow you to reach the text.

BTW: the difference between these two ways of encapsulating/presenting text is 
simply in the ways that LO provides for manipulating the particular 
encapsulation:

A Box allows position/size/anchorage as a drawing object, with all of 
the attributes of drawing objects, including tilt/slant/rotation. (If you look 
at the text box context menu (right-click), you can see the other drawing 
attributes.) It can be anchored to text but is essentially treated as a 
separate layer from the text flow.

A Frame also allows position/size/anchorage (Type), as a text object, 
/within/ the text flow (depending on its wrap configuration).  As a container 
of text, it also allows Transparency, Columns, Macros, and semantic linking for 
dynamic content (Options and Hyperlink).

Of course, for both container types, moving or deleting the container moves or 
deletes the text.

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

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

2022-09-04 Thread John Kaufmann


On 2022-09-04 04:09, jindam, vani wrote:


is it possible to quickly tell whether lo is
fresh or still by looking at version number?


Does "Help" > "Check for Updates..." not do what you want?

--
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 Base Views and Queries

2022-08-12 Thread John Kaufmann


On 2022-08-12 12:44, Robert Großkopf wrote:

...
MySQL/MariaDB with different drivers will be a new thread - or shouldn't we try 
it per private mail?
...


Robert, I have only been following this thread as a lurker, not contributor, 
but if I may offer a view on that question: I'm surely not the only person 
finding this thread educational, and do not see this latest turn as off-topic. 
However, whether or not you find it appropriate to start a new thread, I do 
hope you will continue on-list. You are doing the world a service.

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

Re: [libreoffice-users] LOWrite page numbers

2022-06-24 Thread John Kaufmann


On 2022-06-24 21:21, Chris J. wrote:

...
I write stories where the chapters are individual files. First chapter has 
pages 1-15. Second chapter in a whole other file has to start with page 16. Is 
there a really straight forward example of this somewhere? I remember this 
being easier in Word. I can't get it to work in LO Writer. ...


That is, you want each chapter to be numbered based on the preceding chapter 
numbering? Are you familiar with Master Documents? If not, it would be helpful to 
read Chapter 16 of the WriterGuide 
.

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

Re: [libreoffice-users] searching in Calc does not find anything

2022-06-06 Thread John Kaufmann


Hi Thomas,

On 2022-06-06 20:48, Thomas Blasejewicz wrote:

...
For years Crtl+F and then entering entering numbers or words used to find 
those, if they are in the sheets somewhere.

For a few days now trying to find anything, numbers, digits, words ..., ALWAYS 
gives me
"Search key not found", even if the item in question sits right in the middle 
of the screen.

I tried all sorts of settings and options in the search box.
Apparently I am not smart enough to figure out what I am missing.
I would be grateful for a hint.


Sorry, I just tried Ctrl+F in an existing spreadsheet, and (as always) had no 
problem finding either numbers or text.  7.1.4.2

What is your environment? Have you tried a reboot?

John

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

Re: [libreoffice-users] Calc insists on capitalizing m^2 ...

2022-05-01 Thread John Kaufmann


Brian and Johnny,

On 2022-05-01 08:50, Brian Barker wrote, and
On 2022-05-01 10:52, Johnny Rosenberg wrote:

Den sön 1 maj 2022 kl 14:46 skrev John Kaufmann:


... or any other quantity raised to any other power.  Of course this is
silly in a spreadsheet, where one wants to identify a measurement.

"m" is OK, but "m^2" gets auto-'corrected' to "M^2". Likewise "Cm^2",
"In^2", "Ft^2", "Inch^2", and so forth.

It's embarrassing that I don't see how to turn off this behavior.


Tools → Options for Auto-correction… → Click the Options tab → ☐ Start
every sentence with a capital letter


I /thought/ I had done that (hence the embarrassment). Now I find that I had 
clicked the box above (so the embarrassment is compounded).
[The things one does in the wee hours of the morning ...]


You can also just type m², then you don't need to change any settings. And
it looks better.


I never thought about that! For decades, through many spreadsheet programs, my 
habit has been to treat text cells like formula cells. For me, learning that 
it's not necessary represents a conceptual leap. ;-)  Thanks.

Every day is a school day.  Thanks again to both of you,
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

[libreoffice-users] Calc insists on capitalizing m^2 ...

2022-05-01 Thread John Kaufmann


... or any other quantity raised to any other power.  Of course this is silly 
in a spreadsheet, where one wants to identify a measurement.

"m" is OK, but "m^2" gets auto-'corrected' to "M^2". Likewise "Cm^2", "In^2", "Ft^2", 
"Inch^2", and so forth.

It's embarrassing that I don't see how to turn off this behavior.

John

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

Re: [libreoffice-users] Using the Gallery - removing the descriptive text

2022-04-25 Thread John Kaufmann

Thank you, Harald.

[I should also begin with a note on language: I am always humbly grateful for
those who are willing to speak and write in my native language. (I once worked
in a multi-national engineering office in Brussels. There were about a dozen
client languages, and office business was conducted mostly in French and
English. Americans and Brits were generally regarded as the least capable
linguistically.) My lesson from cross-language experience was that it is easier
to receive than to give, so we might best be served by everyone speaking and
writing natively, but I am grateful for those who go beyond that -- and
especially grateful that English is the world's default second language. ;-) ]

I hope you saw that Regina (who may be more knowledgeable about LO than anyone)
provided a full and simple answer in the same vein as your approach - but she
showed how to edit directly in Writer, without resort to Draw: just F2. I will
be looking at bugs.documentfoundation.org to see if I should file a request to
have that added to the context menu.

You have helped my success. I hope someday to return the favor.

Kind regards,
John

On 2022-04-25 03:01, lo.harald.ber...@t-online.de wrote:

Supplement:

There also seems to be another bug in Draw.
To be able to edit the text in a flow chart object, you must first right-click on the
object and select "Break".

Kind regards,
Harald

Dear John,

first of all, thank you very much for your feedback.
This has led me to probe a little deeper into the theme.

Well I am not a developer but also just a user like you.
Therefore, as a user, you can only ever tell about experiences.

It is also possible that I did not understand your question correctly. Sorry,
English is not my native language.

But now to the point. I'm glad you are familiar with frames, because they are a
powerful tool in Writer.

There is also what I hope is a pleasing development for you.
You can use and change the flowchart graphics.
However, this only works in Draw.

I think it is a mistake that this does not work in Writer.
In this respect it would be appropriate to write a bug report.

Now for the differences, which I found out thanks to your feedback.

-- Flow charts in Writer. --

When you insert a flowchart object into Writer, you can't actually change it
(as I said, probably a bug).
In this example I used the graphic object "Process".
Right-click the object and select Properties from the context menu.
The dialog shows you that it is an image and this is therefore not editable.

-- Flow charts in Draw. --

In Draw, add again the flow chart object "Process".
If you now double-click on the text, the cursor will appear for editing.
(Heureka)

Try right-clicking on the object.
With "Break" you can learn that it is a composite object. Use the navigator to
see the individual sub-objects.

-- Workaround - my proposal --

Create flowchart objects for your purposes in Draw and copy them to Writer.

I wish you much success.

Kind regards,
Harald

Am 25.04.2022 um 01:28 schrieb John Kaufmann:

Thanks, Harald. That article is about using frames (including linked frames) to
layout a DTP project; it does not address the Gallery, or even the inclusion of
graphics generally. FWIW, I'm familiar with frames (and even use them in this
document), but don't see how they relate to the question of included graphics,
from the Gallery or elsewhere.

Most of the Gallery contents seem to be traditional clip-art (graphical symbols), including those collected in the
"Flow chart" category. How do those flowchart symbols differ from others? [The Gallery has three other
categories - "BPMN", "Diagrams", "Shapes" - that also contain descriptive text with
graphics; my original question would also apply in those cases.] Is your point that I should forget the Gallery and
make my own graphics (from Draw or elsewhere)? (If so, what is the purpose of the Gallery?)

Kind regards,
John

On 2022-04-24 09:30, lo.harald.ber...@t-online.de wrote:

IMHO, the flowchart symbols are not suitable for your purposes.
For graphical symbols that should contain text, text boxes, drawing symbols or
frames are suitable.
Please have a look if this article helps you:
https://wiki.documentfoundation.org/Videos/Layout_in_Writer

Harald

Am 24.04.2022 um 14:52 schrieb John Kaufmann:

In years of using OO/LO (now @ 7.1.4.2), I have never been interested in the
Gallery of multimedia objects. Now I have an application for it, and can't see
how to execute a simple inclusion of a graphic without its attached descriptive
text.

Re: [libreoffice-users] Using the Gallery - removing the descriptive text

2022-04-25 Thread John Kaufmann

Hi Regina,

On 2022-04-25 04:25, Regina Henschel wrote:

John Kaufmann schrieb am 24.04.2022 um 14:52:

Do you mean the text, which is included in shapes of theme "Flow chart"? Insert
the object and mark it. Then press key F2 to enter edit mode. Now you can delete the text
with backspace key.

That's it!

Some of the objects in the "Flow chart" gallery theme are groups. In that case
you first need to enter the group (see item in context menu) and then you can select the
object, which actually has the text.

I assumed it was a group, but did not find the key to un-group it. (I was looking for options like
"Ungroup" or "Edit" or "Properties".) I should remember F2, but seldom use it;
now I will do so more often. Still, it would probably be nice if the context menu included that. I should
check bugs.documentfoundation.org to see if someone has filed such request.

As I said to Dave, in the context of the wealth of tools LO offers: every day is a
school day, and I like that. But this episode has raised a sometimes-recurring
question about how those tools are coordinated. Dave suggested to forget the
Gallery (at least for this purpose) and use Insert>Shape to the same end. That
worked fine, but left me wondering about use of the Gallery. You pointed out that
the Gallery is fine for this purpose (in fact, I prefer the equivalent graphic,
which is different from the brace in the Shapes library), for an even better
result.

I'm sure there's a lot of history behind why those two approaches coexist,
apparently independently. Are they in fact independent? Is this a case where
one would prune/rationalize the tools to a common base (maybe with multiple
entry points in the user interface) if time allowed, or is there a positive
benefit from maintaining both the Shapes menu and the Gallery as separate
graphics libraries? If the latter, how do you decide where to add a new graphic
or collection of graphics?

Thanks so much for your insight.

Kind regards,
John

Re: [libreoffice-users] changing currency in a spreadsheet

2022-04-25 Thread John Kaufmann


Hi Dave,

On 2022-04-24 17:26, Dave Howorth wrote:


I have a financial spreadsheet that was designed in the USA but I live
in the UK. Is there any way in LO to change all the cells that are
formatted as numeric $ amounts to be the same format but using the
equivalent numeric £ format instead?


When you do "Format Cells" (Ctrl+1) and select "Currency", do you not get a drop-down "Format" 
menu that allows designation of the currency of choice? (In fact, if you select a "Language" different from your 
default language {Tools > Options > Language Settings > Languages}, it should allow you to select from two different 
currencies at the same time.)

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

Re: [libreoffice-users] Using the Gallery - removing the descriptive text

2022-04-25 Thread John Kaufmann


Thanks, Dave! That did the job nicely.  It's easy to forget how many tools LO 
offers. [For some (like the Gallery) I still have not figured out a use. ;-)]

Every day is a school day,
John
 


On 2022-04-25 02:04, Dave Barton wrote:

I believe Harald was trying to give a more complete answer than the
simple option you were looking for.

Yes, forget the bitmap images in the Gallery Flowchart set, where the
name of the flowchart symbols have the name embedded in them and are
intended to be used in a different situation than you wish to use.


From Writer's main menu select "Insert -> Shape -> Symbol Shapes", then

choose either "Left Brace" or "Right Brace" as required. Once the shape
is drawn and inserted you can freely position and size it to your
requirements.


On 25/04/2022 00:28, John Kaufmann wrote:

Thanks, Harald. That article is about using frames (including linked
frames) to layout a DTP project; it does not address the Gallery, or
even the inclusion of graphics generally.  FWIW, I'm familiar with
frames (and even use them in this document), but don't see how they
relate to the question of included graphics, from the Gallery or elsewhere.

Most of the Gallery contents seem to be traditional clip-art (graphical
symbols), including those collected in the "Flow chart" category. How do
those flowchart symbols differ from others? [The Gallery has three other
categories - "BPMN", "Diagrams", "Shapes" - that also contain
descriptive text with graphics; my original question would also apply in
those cases.]  Is your point that I should forget the Gallery and make
my own graphics (from Draw or elsewhere)? (If so, what is the purpose of
the Gallery?)

Kind regards,
John


On 2022-04-24 09:30, lo.harald.ber...@t-online.de wrote:

IMHO, the flowchart symbols are not suitable for your purposes.
For graphical symbols that should contain text, text boxes, drawing
symbols or frames are suitable.
Please have a look if this article helps you:
https://wiki.documentfoundation.org/Videos/Layout_in_Writer

Harald

Am 24.04.2022 um 14:52 schrieb John Kaufmann:

In years of using OO/LO (now @ 7.1.4.2), I have never been interested
in the Gallery of multimedia objects. Now I have an application for
it, and can't see how to execute a simple inclusion of a graphic
without its attached descriptive text.

Specifically: in Writer I have a 4-page booklet/pamphlet in which the
two facing inner pages have related content: The left side (page 2)
has a list of summarized thoughts (each a few lines), two of which
are expanded on the right side (page 3). To help the reader make the
connection, it seems helpful in both cases to point from the
condensed version to its expansion.  The Gallery has a set of "Flow
chart" graphics, including braces and brackets designed to serve the
function of grouping a few lines and pointing to a conclusion.
Unfortunately, all come with the description "Callout" which is
inserted along with the graphic -- kind of like clip-art that
includes a message "This is clip-art" (as part of the clip-art
display). This can't be right, can it? - yet I have searched in vain
(including the Help and Guides) for how to turn off that descriptive
text. What am I missing?

John










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

Re: [libreoffice-users] Using the Gallery - removing the descriptive text

2022-04-24 Thread John Kaufmann

Kind regards,
John

On 2022-04-24 09:30, lo.harald.ber...@t-online.de wrote:

Harald

Am 24.04.2022 um 14:52 schrieb John Kaufmann:

Specifically: in Writer I have a 4-page booklet/pamphlet in which the two facing inner pages have related
content: The left side (page 2) has a list of summarized thoughts (each a few lines), two of which are
expanded on the right side (page 3). To help the reader make the connection, it seems helpful in both cases
to point from the condensed version to its expansion. The Gallery has a set of "Flow chart"
graphics, including braces and brackets designed to serve the function of grouping a few lines and pointing
to a conclusion. Unfortunately, all come with the description "Callout" which is inserted along
with the graphic -- kind of like clip-art that includes a message "This is clip-art" (as part of
the clip-art display). This can't be right, can it? - yet I have searched in vain (including the Help and
Guides) for how to turn off that descriptive text. What am I missing?

John

[libreoffice-users] Using the Gallery - removing the descriptive text

2022-04-24 Thread John Kaufmann


In years of using OO/LO (now @ 7.1.4.2), I have never been interested in the 
Gallery of multimedia objects. Now I have an application for it, and can't see 
how to execute a simple inclusion of a graphic without its attached descriptive 
text.

Specifically: in Writer I have a 4-page booklet/pamphlet in which the two facing inner pages have related 
content: The left side (page 2) has a list of summarized thoughts (each a few lines), two of which are 
expanded on the right side (page 3). To help the reader make the connection, it seems helpful in both cases 
to point from the condensed version to its expansion.  The Gallery has a set of "Flow chart" 
graphics, including braces and brackets designed to serve the function of grouping a few lines and pointing 
to a conclusion. Unfortunately, all come with the description "Callout" which is inserted along 
with the graphic -- kind of like clip-art that includes a message "This is clip-art" (as part of 
the clip-art display). This can't be right, can it? - yet I have searched in vain (including the Help and 
Guides) for how to turn off that descriptive text. What am I missing?

John

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

Re: [libreoffice-users] lines and movement with arrow keys

2022-03-09 Thread John Kaufmann


Carl,

On 2022-03-09 17:00, Carl Paulsen wrote:

I have inserted a line into a text document and have a few questions. ...  I 
have done this in the past using tab spaces with a right justified tab, but LO 
won't underline tab spaces. ...


At the conclusion of her elegant reply to your question, Regina advised,


It would be good, if you describe the purpose of such line. There might exist a 
totally different solution for your goal.


In particular, when you say that, "I have [made a line] using tab spaces with a 
right justified tab, but LO won't underline tab spaces", I wonder what you mean, 
since LO's Right Tab setting includes the underline as one of the options for Fill 
Character (fourth choice). So I'm surely not understanding your question and/or approach. 
Could please clarify what you are doing?

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

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

2022-03-06 Thread John Kaufmann


On 2022-03-06 16:49, charles meyer wrote:

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


Don't over-complicate this.
o Like the OP of the thread you link, you want the printed paper 
divided into 4 parts (2x2) [A6=(1/4)A4].
o Whether each part has the same or different content is (like every 
other content question) up to you.
o The linked thread discusses (the) two (obvious) ways to achieve that 
effect:
  (1) Use the built-in "Pages per sheet" function in the print driver 
interface.
  (2) Use a 2x2 table sized to fit the whole page, so that each cell is 
1/4 page.

(1) and (2) look the same but are not logically the same. You don't care about 
the logical distinction, but Writer must care, because sheets and pages and 
table and cells are all defined by different attributes and thus are logically 
different things. So you just have to decide which approach you want to use: a 
sheet of 4 pages or a table of 4 cells? Once you have made that choice, it's 
easy enough to do it, as long as you do so deliberately and consistently. 
Either way, content is up to you: If you want 1 page or cell replicated to 
additional pages or cells, you have to copy it. Writer can do everything but 
read your mind.

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

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

2021-12-15 Thread John Kaufmann


On 2021-12-15 14:11, Hylton Conacher (ZR1HPC) wrote:

...
I am quickly losing patience with a task that requires a sum of values that 
occur on the same date, but at different times.

My raw data sheet is in 4 columns [spaced for comprehension]
 Date/Time [stamp] | Value 1| Value Y| Value z
2021-10-08 08:00:00|5   |7   |   0.15
2021-10-08 14:05:16|3   |   10   |   5
2021-10-09 10:05:30|   15   |3   |  25
2021-10-09 18:00:00|   15   |9   |   6
...
..
.

I have a secondary sheet with just the date i.e. 2010-10-08, acquired with 
formula `=LEFT($Data.A4,10)'. Column B of this sheet needs to be the SUM of all 
the numbers in the 3rd column, BUT only for the date in column A i.e.

2010-10-08| 17
2010-10-09| 12
...
..
.


Just trying to understand your question properly, so for clarification:
 (1a) Your two sheets differ in column A, in that the first has a date/time 
stamp, the second date only (extracted from the first)?
 (1b) Does each row of the second sheet reflect the date of the corresponding 
row in the first sheet (in other words, dates are repeated on the second sheet, 
as suggested by your formula ($Data.A4, $Data.A5, $Data.A6, ...), or is each 
date on the second sheet listed just once?
 (2) We don't need to worry about columns B or D of the first sheet, just 
column C? [Any significance to columns B-C-D being indexed in three different 
formats (Numeric-UPPERCASE-lowercase)?]



I have tried many Google searches and seen many videos on how this is supposed 
to work yet for some reason, being race, colour, creed, or stupidity, I cannot 
get the result I seek. It would seem that the summation of data with the same 
date, but different time component in the main data sheet is causing an issue.


 (3a) Did you try confirming that conjecture using a test example with just the 
date, not a date/time stamp?
 (3b) How is that date/time field acquired? Could it be acquired/input as two 
separate fields, date and time?



I'd really appreciate some pointers here, even if not possible. If not possible 
what could be done. I just don't understand the INDEX(MATCH())/vlookup  
argument.


 (4) [This is related to questions 1 and 3] Given that you acquire the date for 
your second sheet's column A as a text field, is there a possible data type 
mismatch?


--
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] Font size settings in paragraph styles

2021-11-22 Thread John Kaufmann


On 2021-11-22 17:50, Philip Jackson wrote:

LO 6.4.7.2 in Ubuntu 20.4

Normally over the years with all my Writer documents I've been able to set font 
sizes in pts for H1, H2, H3, H4 etc heading styles with no problems. In the 
past couple of weeks I've come across documents where the font sizes are 
specified as % for these heading styles (other styles appear to be still 
directly set in pt values).

I've not been able to find any reference to this in the help files. Is there a 
way to drop the % settings and revert to direct setting in pts?


Can't you do either - % or pt - just by so specifying?

john

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

Re: [libreoffice-users] have a cell with text in different colors with function

2021-11-15 Thread John Kaufmann


On 2021-11-15 09:38, gmail-xplaster wrote:

...
P,S, OT, I noted that the nabble platform doesn't work anymore, is it in use or 
not?


There have been several threads in the past year about attempts to consolidate 
channels to improve support. With respect to nabble in particular, I think the latest 
was in July. This 
 was 
the last message in that thread.

-John

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

Re: [libreoffice-users] Defaults in Find dialogue and toolbar for Calc

2021-10-23 Thread John Kaufmann


On 2021-10-23 18:14, Johnny Rosenberg wrote:

Den tors 7 okt. 2021 kl 00:28 skrev T. R. Valentine :

On Tue, 5 Oct 2021 at 07:07, David Lynch  wrote:


The defaults in the Find toolbar and the Find dialog are:

Direction: Rows Search in: Formulae

I normally want the opposite: Search in columns (because columns usually
consist of more homogeneous data than columns) and search in Data
(because usually I'm usually looking at the finished spreadsheet rather
than constructing it, and even when constructing a spreadsheet, search
for a formula is infrequent).

You cannot change the default from the toolbar and, if you change the
default from the dialog then move to another sheet, it changes back to
the unwelcome default.

Is there a way to change the default permanently?


Not that I've been able to find. I also prefer to search columns
before rows and wish there were a way to make that the default.


+1


I think it would be even nicer if it remembered the settings from last time.


+2

--
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 print a section of a SS

2021-10-16 Thread John Kaufmann


On 2021-10-15 20:25, John R. Sowden wrote:

I went to Format->Print Range--> define.  Failed
Went to Help (when all else fails) read, follow instructions, blank screen (no 
examples)

Help?,


Which version? [Defining a print range is where I usually start, but I just 
realized I have not printed a Calc sheet since LO6.]

--
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] Writer indents and spacing in "ch" and "line"

2021-08-28 Thread John Kaufmann


LO 7 introduced a new way of thinking about, and sizing, indents and spacing in Writer - from 
definite units of measure (inch, mm, pt, ...) to "ch" and "line" of a reference 
style's font characteristics.  I'm sure there's a reason for that change, but still have not found 
it, and have not even found how it connects to such reference style (set in the Page style).

I read the guide on "Page Line-spacing Printing" but don't find it on-point, as 
these new measures apply whether or not page-line-spacing is activated in the relevant 
Page and Paragraph styles.  Can someone point me to an explanation of the reason for, and 
use of, these new units of spacing?

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

Re: [libreoffice-users] Re: Multi-column Format

2021-08-08 Thread John Kaufmann


Dave,

On 16-Feb-2021 you started a thread ["How to ask a question on Ask 
LibreOffice?"] in this forum mentioning that you also [like Rob now] have a problem 
with the Ask system, and so tend to use this list instead -- which is fine: as noted in 
an earlier thread, Ask and this list are alternative communities to get help, and should 
serve the same purpose. But, as Sophi noted in reply to you, TDF hopes to combine those 
communities (web and mailing list) with an implementation of Discourse (which would also 
eliminate nabble, which existed mostly as an archive for this list).

So far, the plan has only been executed as far as eliminating nabble; Ask and 
this list are still both alive and not combined, so Rob can subscribe here (as 
an alternative to ask.libreoffice.org) to ask questions, and keep an open (and 
patient) mind about whatever succeeds this list.

Meanwhile, to answer Rob's question: This sounds like what is usually called "n-up 
printing" (with, in Rob's case, n=2) or "combination printing" -- that is, putting n 
(2 or more) pages on a sheet, where a sheet is one side of a piece of paper.  As such, that is 
usually a function of the printer driver.

If I have misunderstood the issue, maybe Rob can reply to the list?

John


On 2021-08-08 13:40, Dave Barton wrote:

I don't know the answer to Rob's question.

Can someone on this list offer any suggestions?

Please cc Rob in any reply.

Thanks & Regards
Dave

 Original Message 
From: Rob MM [mailto:robm...@hotmail.com]
Sent: Friday, August 6, 2021, 18:06 UTC
To: Dave Barton
Subject: Multi-column Format


I can't make Ask.LibreOffice work so I'm sending this to you.  Thank
you for your past support.

How can I make a four-column spread sheet print in two parts, side by
side?  I am currently cutting the last half of the spread-sheet and
pasting it into the columns to the right of the original sheet.

I used to do this in Excell but can't find any information about it in
Libre.



--
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 Callout Style settings

2021-07-25 Thread John Kaufmann


On 2021-07-25 16:54, Regina Henschel wrote:

John Kaufmann schrieb am 25.07.2021 um 15:49:

On 2021-07-23 20:30, Regina Henschel wrote:

Steve Edmonds schrieb am 18.07.2021 um 23:05:

...
Is it possible to set Writer callout text paragraph style (or default settings, 
if so where please.
This is to avoid having to change the font and left hand offset in every line 
callout one at a time.


No, it is not possible. Using the legacy callouts or the custom shape callouts 
makes no difference. You get always a shape and in Writer neither for the shape 
itself nor for the text in the shape styles are possible. You can only use 
direct formatting in Writer.


Your distinction between legacy callouts and custom shape callouts implies that 
the basic idea has been around for some time, and special callout shapes were 
added later. Do you recall when it started, and at what point someone was moved 
to add custom shapes?


The legacy callouts are a kind of text box. They exists from the beginning in 
StarOffice. Custom shapes are introduced in OpenOffice.org 2.0. They are part 
of the change from OpenOffice XML to ODF 1.0.

  In order to

understand the issue (and any possible deficiencies) further, I would like to:
  (4) try to understand when and why Vertical Callouts were added to the 
Drawing toolbar (but not made visible).


They are visible, if you have enabled support for East Asian languages in Tools > 
Options > Language Settings > Languages > Asian.


Perfect! Thank you! - This has been an important education.

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

Re: [libreoffice-users] Writer Callout Style settings

2021-07-25 Thread John Kaufmann

Hi Philip,

On 2021-07-25 16:04, Philip Jackson wrote:

On 25/07/2021 15:49, John Kaufmann wrote:

On 2021-07-23 20:30, Regina Henschel wrote:

Steve Edmonds schrieb am 18.07.2021 um 23:05:

...
Is it possible to set Writer callout text paragraph style (or default settings,
if so where please.
This is to avoid having to change the font and left hand offset in every line
callout one at a time.

No, it is not possible. Using the legacy callouts or the custom shape callouts
makes no difference. You get always a shape and in Writer neither for the shape
itself nor for the text in the shape styles are possible. You can only use
direct formatting in Writer.

Your distinction between legacy callouts and custom shape callouts implies that
the basic idea has been around for some time, and special callout shapes were
added later. Do you recall when it started, and at what point someone was moved
to add custom shapes? In order to understand the issue (and any possible
deficiencies) further, I would like to:
(1) see the earliest Writer Guide and Help in which callouts are mentioned;
(2) try to understand why special shapes were of more interest than style
support;
(3) try to understand the intended use of the "Callouts" toolbar, and why it
has not been made visible;
(4) try to understand when and why Vertical Callouts were added to the Drawing
toolbar (but not made visible).

I've been intrigued by this thread. Callouts was something I'd never heard of
but I've now found them quite useful. As far as documentation is concerned, I
have an old file, GS42-GettingStartedLO.pdf, from 2014 in which a search for
'callouts' gets several hits on 3 pages.

I don't have GS42, but do have GS60, and it seems the same: 6 instances of "callouts" and
1 "callout" over 3 pages.

The first says "For more information, see the Draw Guide Chapter 7 Getting Started
with Draw, or the Impress Guide Chapters 4, 5, and 6." ...

Check (p.183).

The next says "Click on the triangle to the right of the Callouts icon to open the
Callouts toolbar for drawing". So it would appear that the callouts toolbar is
nothing more than a dropdown from the callouts icon in the Drawing toolbar.

Check (p.212): Yes-though note that "Callouts" is not shown in View=>Toolbars.

Now I think I understand why: "Toolbar" is a generic term for two related entities: groupings of commands (like
"Callout" and "Vertical Callout") and groupings of command /options/ (like "Callout Shapes", Flowchart
Shapes", "Star Shapes", ...). Only groupings of *commands* are shown under View=>Toolbars. Groupings of *command
/options/* (what might be called 'option toolbars') are invoked only from their respective commands on the Drawing toolbar:
CalloutsBasic ShapesLines and ArrowsBlock Arrows
Flowchart Symbol Shapes Curves and Polygons Stars and
Banners

[That answers my question (3) above.]

The 3rd page just shows that there are 2 callout icons on the Drawing toolbar.
In fact, in my copy of Writer (6.4.7.2 in UbuntuStudio 20.04.2) there are those
2 icons, one with a dropdown list of 7 icons (the toolbar?) and the other a
single icon which gives a simple rectangular callout shape.

Check (p.330): Yes-though note that a third callout icon ("Vertical Callouts")
is shown under:
View => Toolbars => Customize... => Toolbars tab =>
It is:

Note that this command is enabled, but still does not show on the Drawing
toolbar. So [question (4) above], why not?

Thanks for your reply, which nudged me a little closer to understanding this topic. The
fact that GS42 and GS60 are essentially identical in this regard (including the custom
shapes, as opposed to what Regina called "the legacy callouts") suggests that
finding the first mention of callouts [question (1) above] may not yield much additional
information. Still, it might be nice. I am routinely amazed at how much lies beneath
the surface of the LO project, waiting to be implemented or exploited.

Kind regards,
John

Re: [libreoffice-users] Writer Callout Style settings

2021-07-25 Thread John Kaufmann


Hi Regina,

On 2021-07-23 20:30, Regina Henschel wrote:

Steve Edmonds schrieb am 18.07.2021 um 23:05:

...
Is it possible to set Writer callout text paragraph style (or default settings, 
if so where please.
This is to avoid having to change the font and left hand offset in every line 
callout one at a time.


No, it is not possible. Using the legacy callouts or the custom shape callouts 
makes no difference. You get always a shape and in Writer neither for the shape 
itself nor for the text in the shape styles are possible. You can only use 
direct formatting in Writer.


Your distinction between legacy callouts and custom shape callouts implies that 
the basic idea has been around for some time, and special callout shapes were 
added later. Do you recall when it started, and at what point someone was moved 
to add custom shapes? In order to understand the issue (and any possible 
deficiencies) further, I would like to:
 (1) see the earliest Writer Guide and Help in which callouts are mentioned;
 (2) try to understand why special shapes were of more interest than style 
support;
 (3) try to understand the intended use of the "Callouts" toolbar, and why it 
has not been made visible;
 (4) try to understand when and why Vertical Callouts were added to the Drawing 
toolbar (but not made visible).

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

Re: [libreoffice-users] Writer Callout Style settings

2021-07-23 Thread John Kaufmann

OK, Steve.
So:

I have View>Toolbars>Drawing enabled. In that I have 2 callout options, a
speech bubble and a rectangular text callout. ...

That answers my two questions:
(1) You don't use a Callouts toolbar [contra the Help, confirming a bug there].
(2) Instead, from the Drawing toolbar [which is where I found them] you use
these callout commands:

But [as I noted earlier] there /is/ a "Callouts" toolbar listed among the
toolbars in:
View => Toolbars => Customize...
=> Toolbars tab => Target
I would love to know what that is about, and how to make that Callouts toolbar
visible to use.

In the same vein [and I will bet related], there is also a callouts command
that is *not* visible on the Drawing toolbar (though I suspect, if you check
the Customize options, it is enabled and so should be visible):

IOW, if I had to guess, I suspect that callouts are not a completely
implemented function, though they are a good beginning to extend text boxes
into a special use case that will be very valuable when it is more functional.
That would explain some things:
*** the Help bug (probably had to be written before they really knew how it
will turn out);
*** a lack of style support that you expected (or requested) in your OP;
*** a labelled but still unimplemented "Vertical Callouts" command;
*** anomalies you have found, reflecting sparse user feedback. [Bugs can exist
with lots of user feedback.]

That said, when I was trying to understand your OP, and callouts generally, my
search led to this page -
"Callout Sidebars on LibreOffice"

<https://writingdoneright.net/videos/tutorials/callout-sidebars-on-libreoffice>
- which uses a slightly different (but related) definition of "callout", presenting how
to do /its/ callout function in LO without any special LO callout commands. Both functions are
useful, but it can only cause confusion to call both functions "callouts".

John

On 2021-07-23 16:58, Steve Edmonds wrote:

Thanks for the reply.
I have View>Toolbars>Drawing enabled. In that I have 2 callout options, a
speech bubble and a rectangular text callout. Your icon set may differ.
I am using the callouts to annotate some images for reference in my explanation
text.

If I add a rectangular text callout I can right click and edit some
characteristics. With the callout selected, I can use the menu Format>Text Box
and Shape.
Possibly callouts are still "in development" as, although my document units are
cm and last week the callout properties were in cm, today callout properties are in
inches.

There is also a funny quirk where callouts become invisible (but still there)
when the anchor is not in an appropriate place.

Steve

On 24/07/2021 08:18, John Kaufmann wrote:

On 2021-07-18 17:05, Steve Edmonds wrote:

Is it possible to set Writer callout text paragraph style (or default settings,
if so where please.
This is to avoid having to change the font and left hand offset in every line
callout one at a time.

When I first saw this question, I had no clue what you were asking (having never used
callouts), so looked forward to an answer, to at least help understand the question.
When no answer came, I tried the LibreOffice 7.1 Help on "callout" -- and found
it unhelpful:

"Opens the Callouts toolbar from which you can insert graphics into your
document."

But that leaves these problems:
(1) It's not clear WHAT "Opens the Callouts toolbar" [apparent bug in the
Help], and IAC:
(2) As installed (that is, in the default configuration), View=>Toolbars shows *no*
"Callouts toolbar".

As for (1): *WHAT* opens the Callouts toolbar?

As for (2): The lack of a toolbar, which is supposed to exist, led me to:
View => Toolbars => Customize...
In the Toolbars tab, with , the box shows
"Callouts" among the possible tool bars, but gives no control (that I can see) for how to make
it appear in the View=>Toolbars menu.

Further, after much searching, I found that the Drawing toolbar has these three
apparently-relevant commands:
"Callout Shapes"
"Callouts"
"Vertical Callouts"
(The command categories were found in a subsequent command search on "callout".)

But none of that gets any closer to /using/ these commands. So, at the most
basic level of use: How do you /invoke/ callouts? - via a Callouts toolbar or
the Drawing toolbar? If you use a Callouts toolbar, how do you make it appear?

John

Re: [libreoffice-users] Writer Callout Style settings

2021-07-23 Thread John Kaufmann


On 2021-07-18 17:05, Steve Edmonds wrote:


Is it possible to set Writer callout text paragraph style (or default settings, 
if so where please.
This is to avoid having to change the font and left hand offset in every line 
callout one at a time.


When I first saw this question, I had no clue what you were asking (having never used 
callouts), so looked forward to an answer, to at least help understand the question.  
When no answer came, I tried the LibreOffice 7.1 Help on "callout" -- and found 
it unhelpful:


"Opens the Callouts toolbar from which you can insert graphics into your 
document."


But that leaves these problems:
(1) It's not clear WHAT "Opens the Callouts toolbar" [apparent bug in the 
Help], and IAC:
(2) As installed (that is, in the default configuration), View=>Toolbars shows *no* 
"Callouts toolbar".

As for (1): *WHAT* opens the Callouts toolbar?

As for (2): The lack of a toolbar, which is supposed to exist, led me to:
View => Toolbars => Customize...
In the Toolbars tab, with , the  box shows 
"Callouts" among the possible tool bars, but gives no control (that I can see) for how to make 
it appear in the View=>Toolbars menu.

Further, after much searching, I found that the Drawing toolbar has these three 
apparently-relevant commands:
"Callout Shapes"
"Callouts"
"Vertical Callouts"
(The command categories were found in a subsequent command search on "callout".)

But none of that gets any closer to /using/ these commands.  So, at the most 
basic level of use: How do you /invoke/ callouts? - via a Callouts toolbar or 
the Drawing toolbar? If you use a Callouts toolbar, how do you make it appear?

John

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

Re: [libreoffice-users] specify an absolute sheet address (SOLVED)

2021-06-14 Thread John Kaufmann


On 2021-06-14 20:25, Thomas Blasejewicz wrote:

On 2021/06/13 2:55, Johnny Rosenberg wrote:

Another way to get around it is to name your range. Then your
formula could look something like =VLOOKUP(N76;ZipCodes;2;0)
Named ranges are absolute, always.

...
Defining the data range in the sheet "Zip codes", naming it
"zipcodes" (this setting apparently does not accept spaces), the
formula seems to be working .. AND .. looks a lot friendlier!
=VLOOKUP(N79,zipcodes,2,0)

Your idea was VERY helpful! Thank you.
Even I can understand that formula.
(You used semicolons in your formula, mine has commas. Is there a difference?


Tools > Options > LibreOffice Calc > Formula > Separators


--
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] LoCalc- convert a 4 digit number to time

2021-06-12 Thread John Kaufmann


On 2021-06-12 13:59, Johnny Rosenberg wrote:

Den lör 12 juni 2021 kl 01:05 skrev Dutton:


In cell A1 there's the number 1230
In cell A2 I want the number to appear as 12:30 (a time figure)


If you only mean ”appear”, then just format the cell as:
00”:”00
or
#0":"00
depending on w how you want three digit numbers to appear, ”09:30” or
”9:30”...


Johnny, that's a very nice insight into Calc formatting, with more general 
application. Do you recall where you found it?

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

Re: [libreoffice-users] Libreoffice impress presentation - metropolis - exported as PDF, doesn't display correctly on some devices

2021-05-16 Thread John Kaufmann


Without knowing what you are exporting, I would not make a suggestion, but did 
you consider HTML?

On 2021-05-16 23:43, Daffy Duck wrote:

Yes, for distribution to a large amount of people, none of which use 
libreoffice.



On Sun, 2021-05-16 at 23:36 -0400, John Kaufmann wrote:

On 2021-05-16 19:27, Daffy Duck wrote:

I made a presentation with impress, used Metropolis theme.

I then exported it as PDF.

The problem is, some, when opening on such things as iphones, get the
text cut off, like the top part of the text is not showing, etc.

Others, until they turn the phone sideways, it doesn't display the text
correctly.

How do I make sure the text looks correct for all, or at least most,
users on different devices?


Don't use PDF. The whole idea of PDF is to represent a physical page; it is not 
intended to adapt to different screens of a large range of sizes. Is there some 
reason for exporting to PDF?



--
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 impress presentation - metropolis - exported as PDF, doesn't display correctly on some devices

2021-05-16 Thread John Kaufmann


On 2021-05-16 19:27, Daffy Duck wrote:

I made a presentation with impress, used Metropolis theme.

I then exported it as PDF.

The problem is, some, when opening on such things as iphones, get the
text cut off, like the top part of the text is not showing, etc.

Others, until they turn the phone sideways, it doesn't display the text
correctly.

How do I make sure the text looks correct for all, or at least most,
users on different devices?


Don't use PDF. The whole idea of PDF is to represent a physical page; it is not 
intended to adapt to different screens of a large range of sizes. Is there some 
reason for exporting to PDF?

--
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] Treating Labels like Envelopes

2021-05-12 Thread John Kaufmann


LO Writer provides three kinds of document constructs for similar structured 
purposes:
o Envelopes  (invoked by Insert > Envelope...);
o Labels (invoked by File > New > Labels);
o Business Cards (invoked by File > New > Business Cards).
For the purpose of this question, Business Cards are a special case of Labels, 
so I will ignore them.

I think it's accurate to characterize:
o Labels as intended for a single entity frame (either fixed text or 
merged from database);
o Envelopes as intended for an addressing function of two entity frames:
 -- "Sender" (fixed text, normally from LO default) and
 -- "Addressee" (either fixed text or merged from database).

But sometimes (often?) one wants to treat Labels as serving the same addressing 
function as Envelopes -- that is, with two frames: Sender (normally fixed text 
from LO default) and Addressee (either fixed text or merged from database).
- For one-off labels, it's reasonable to treat the label frame as the 
Sender block (upper, left-justified) and insert an additional frame-anchored 
frame (lower, to the right edge) for Addressee, which is then filled in 
manually.
- But what about multiple labels, with Addressee filled in from a database?  Is there a 
"standard" way to do that?  The "Labels" tab "Label text" box does not seem to 
have a good way to mix fixed text in one frame and field codes in another -- or have I missed something 
obvious?

John

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

Re: [libreoffice-users] docx file formatting question. Using LO 7.0.5.2

2021-05-03 Thread John Kaufmann


On 2021-05-03 08:15, Ianseeks wrote:

...
I downloaded a docx file ... where some pages were landscape format in the 
middle of the document. ... She then started editing it and when she got to the 
landscape pages, the landscape format had reverted to portrait and the table on 
the tried used the landscape dimensions and it squashed the right hand columns 
... Can i make LO use landscape on various pages i choose and correct the 
problem.  I did try but it landscaped every page.


This is not a question of file format (DOCX or whatever); it's a question of 
having multiple page styles (at least one portrait style and one landscape 
style) in the document. You just need to specify both styles, according to use 
and when you make a page break from one style to the other, do so explicitly:
 Insert > More Breaks > Manual Break > Page Break, and specify the 
Style of the next page.


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

2021-04-16 Thread John Kaufmann


Hi Harvey,

Good point! That is an another good reason for doing the columns of the page(s) 
as table columns: It simplifies selecting a column as a syntactic field. I 
never thought about that, and appreciate you generalizing the solution in that 
way, which is an interesting variation on style management.

Thanks,
John


On 2021-04-16 16:23, Harvey Nimmo wrote:

I just klick on the top of the one column to select the content of the
whole column. Then go to Tools > Language > For Selection and select
the language to be checked for that column.


On Fri, 2021-04-16 at 07:45 -0400, John Kaufmann wrote:

Sorry, but I was hoping you would ask HOW the spell-check language is
set separately on each column.
[I hate it when someone says "Of course" on an issue I don't see.] ;-
)
Since you grasped it immediately, I'm afraid I must ask one of you:
How do you do that?


On 2021-04-15 14:22, 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

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

2021-04-16 Thread John Kaufmann


Hi Dan,

Yes I did, but the Font tab is a Character tab in a Paragraph style. (If you do 
Format > Paragraph from the menu, the dialog has no Font tab, because that is 
under Format > Character. One of the idiosyncrasies about OO/LO Paragraph /styles/ 
[related to MS Word history?] is that they incorporate Character style functions.)  
So I tend to think of those as attributes of a Character style -- but as you say, in 
this case they are (also) in a Paragraph style.

Thanks again for checking my understanding,
John

On 2021-04-16 15:47, Dan Lewis wrote:

the language setting is also in the Font tab for all paragraph styles. Did you 
notice this?

Dan

On 4/16/21 9:33 AM, John Kaufmann wrote:

Thanks, Dan. It's funny: I thought I knew styles, which are indispensable to 
any kind of serious writing, but never noticed that Language setting in the 
Character style Font tab.
Every day is a school day.
-John

On 2021-04-16 08:50, Dan Lewis wrote:

This requires knowing how to use styles. For the column in German, all of the 
styles you use (paragraph, heading, or character styles need to be modified to 
list German as the language. For the column in English, all of the styles you 
use (paragraph, heading, or character styles need to be modified to list 
English as the language.This results in two sets of styles, one for German and 
one for English. For detailed instructions on doing this, you need to download 
the latest Writer Guide or download the the chapter on styles and the chapters 
on styles from the Getting Started Guide. Or, you could just download the 
entire Writer Guide so you would have a good reference for other questions 
about Writer.

Dan

On 4/16/21 7:45 AM, John Kaufmann wrote:

Sorry, but I was hoping you would ask HOW the spell-check language is set 
separately on each column.
[I hate it when someone says "Of course" on an issue I don't see.] ;-)
Since you grasped it immediately, I'm afraid I must ask one of you: How do you 
do that?


On 2021-04-15 14:22, 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

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

2021-04-16 Thread John Kaufmann


Thanks, Dan. It's funny: I thought I knew styles, which are indispensable to 
any kind of serious writing, but never noticed that Language setting in the 
Character style Font tab.
Every day is a school day.
-John

On 2021-04-16 08:50, Dan Lewis wrote:

This requires knowing how to use styles. For the column in German, all of the 
styles you use (paragraph, heading, or character styles need to be modified to 
list German as the language. For the column in English, all of the styles you 
use (paragraph, heading, or character styles need to be modified to list 
English as the language.This results in two sets of styles, one for German and 
one for English. For detailed instructions on doing this, you need to download 
the latest Writer Guide or download the the chapter on styles and the chapters 
on styles from the Getting Started Guide. Or, you could just download the 
entire Writer Guide so you would have a good reference for other questions 
about Writer.

Dan

On 4/16/21 7:45 AM, John Kaufmann wrote:

Sorry, but I was hoping you would ask HOW the spell-check language is set 
separately on each column.
[I hate it when someone says "Of course" on an issue I don't see.] ;-)
Since you grasped it immediately, I'm afraid I must ask one of you: How do you 
do that?


On 2021-04-15 14:22, 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

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

2021-04-16 Thread John Kaufmann


Sorry, but I was hoping you would ask HOW the spell-check language is set 
separately on each column.
[I hate it when someone says "Of course" on an issue I don't see.] ;-)
Since you grasped it immediately, I'm afraid I must ask one of you: How do you 
do that?


On 2021-04-15 14:22, 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

Re: [EXTERNAL] [libreoffice-users] Non-breaking dash/hyphen

2021-03-24 Thread John Kaufmann


Very nice! Thanks for the background - that was a good discussion, and nice to 
understand your concern about applying NPC treatment to a printing character.  
There is a case to be made for some kind of visual discrimination (on the 
working screen, not the printed page) between typographically identical glyphs 
which behave differently, like breaking and non-breaking hyphen.


On 2021-03-24 16:38, V Stuart Foote wrote:

NPC -- Non-Printing Character [1]

The LibreOffice VCL canvas will apply "field" shading to a broad class of 
control and non-printing characters, we've asked to give them more distinction from 
fielded values [2]

=-ref-=
[1] https://en.wikipedia.org/wiki/Control_character

[2] https://bugs.documentfoundation.org/show_bug.cgi?id=58434


____
From: John Kaufmann 
Sent: Wednesday, March 24, 2021 2:21 PM
To: users@global.libreoffice.org 
Subject: Re: [EXTERNAL] [libreoffice-users] Non-breaking dash/hyphen

Excellent! (I was wondering what happened to U+2011 as I investigated the "General 
Punctuation" group.) So it's just a matter of the Liberation family not covering the 
U+2011 codepoint - but a replacement glyph is provided. Thanks!

You used a term I don't recognize: "NPC".  My search turned up that it is a popular abbreviation for 
"non-playing character" in domains like WoW, Runelite and lots of other things of which I know nothing, but 
fortunately I don't think you used it in that context. I suspect it is close to that textually -- "non"  
"character" -- but I decided I had best ask: ?


On 2021-03-24 14:56, V Stuart Foote wrote:

You've missed the one Unicode point that does exactly what you require, but its 
use will depend on the font in use.

U+2011 NON-BREAKING HYPHEN

You can enter via LibreOffice Special Character dialog, or LibreOffice's Unicode 
toggle. That is you can type U+2011 and then +X to toggle the glyph.

If the font in use does not "cover" the codepoint, you'll get a fallback 
replacement or possibly the no glyph value for the font.

When added to canvas the non-breaking hyphen character will receive NPC 
highlighting.



--
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: [EXTERNAL] [libreoffice-users] Non-breaking dash/hyphen

2021-03-24 Thread John Kaufmann


Even easier! - y'know, I think I /knew/ that. [I certainly knew about the hard 
(non-breaking) space on that same menu.]
Thanks for the reminder, Robert!
(- and sorry for the list noise)

On 2021-03-24 15:09, W. Robert J. Funnell, Prof. wrote:

Or you can do Insert > Formatting Mark > Non-breaking hyphen.
Does that work for you?
- Robert

From: V Stuart Foote 
Sent: March 24, 2021 14:56
To: LibreOffice Users
Subject: Re: [EXTERNAL] [libreoffice-users] Non-breaking dash/hyphen

You've missed the one Unicode point that does exactly what you require, but its 
use will depend on the font in use.

U+2011 NON-BREAKING HYPHEN

You can enter via LibreOffice Special Character dialog, or LibreOffice's Unicode 
toggle. That is you can type U+2011 and then +X to toggle the glyph.

If the font in use does not "cover" the codepoint, you'll get a fallback 
replacement or possibly the no glyph value for the font.

When added to canvas the non-breaking hyphen character will receive NPC 
highlighting.


____
From: John Kaufmann 
Sent: Wednesday, March 24, 2021 1:31 PM
To: LibreOffice Users 
Subject: [EXTERNAL] [libreoffice-users] Non-breaking dash/hyphen

   **EXTERNAL EMAIL**
   This email originated outside of The University of Texas at San Antonio.
   Please exercise caution when clicking on links or opening attachments.



I had always thought that the difference between a "dash" and a "hyphen" is 
that the dash is a character (that is, will not break a character string), while the hyphen 
hyphenates (that is, breaks at the end of a line if the character string following the hyphen is 
too long to fit on the line).  So, needing a non-breaking substitute for that horizontal bar on my 
keyboard, I invoked:
 Insert > Special Character
to get (what I would call) a dash.

LibreOffice has such mid-height horizontal-bar characters in three character 
groups:
"General punctuation", characters:
 U+2010 (HYPHEN)
 U+2012 (FIGURE DASH)
 U_2013 (EN DASH)
 U+2014 (EM DASH)
 U+2015 (HORIZONTAL BAR)
"Mathematical Operators", character:
 U+2212 (MINUS SIGN)
"Box Drawing", character:
 U+2500 (BOX DRAWINGS LIGHT HORIZONTAL)

The five characters of the "General Punctuation" group mostly seem to just 
represent different widths of hyphen (despite three being called FIGURE DASH, EN DASH, EM 
DASH), in that in a character string each will end a line of characters if the string 
following is too long to fit. Only the HORIZONTAL BAR acts as a common character, such 
that the string of which it is a member will not break there; but it is very long to be 
used as a non-breaking hyphen.

The MINUS SIGN in the "Mathematical Operators" group has a special operation: 
It will break at the end of a line, but will itself move to the next line, to stay with 
the character following MINUS SIGN.

The BOX DRAWINGS LIGHT HORIZONTAL character acts like the HORIZONTAL BAR -- 
that is, as a true, non-breaking character -- but is also too long to be used 
generally as a non-breaking hyphen.

Is there a clean way to make a non-breaking dash/hyphen?

-John

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? 
https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.libreoffice.org%2Fget-help%2Fmailing-lists%2Fhow-to-unsubscribe%2Fdata=04%7C01%7Cvstuart.foote%40utsa.edu%7C45998350bbe84d1015b308d8eef33dc9%7C3a228dfbc64744cb88357b20617fc906%7C0%7C1%7C637522075778288123%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000sdata=uViKRsdeUCeZibj6iDLg2bvxpIiI16c7fjya%2B6rp49I%3Dreserved=0
Posting guidelines + more: 
https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.documentfoundation.org%2FNetiquettedata=04%7C01%7Cvstuart.foote%40utsa.edu%7C45998350bbe84d1015b308d8eef33dc9%7C3a228dfbc64744cb88357b20617fc906%7C0%7C1%7C637522075778288123%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000sdata=GsCYvDHe1BJ8vWu6cQiZbTmWbi4W6REXOrdYV%2BacjKE%3Dreserved=0
List archive: 
https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Flistarchives.libreoffice.org%2Fglobal%2Fusers%2Fdata=04%7C01%7Cvstuart.foote%40utsa.edu%7C45998350bbe84d1015b308d8eef33dc9%7C3a228dfbc64744cb88357b20617fc906%7C0%7C1%7C637522075778288123%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000sdata=a2XSTngahR6i%2FuXXSSxushiS1VvKXoFE6TnwEcLVveM%3Dreserved=0
Privacy Policy: 
https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.documentfoundation.org%2Fprivacydata=04%7C01%7Cvstuart.foote%40utsa.edu%7C45998350bbe84d1015b308d8eef33dc9%7C3a228dfbc64744cb88357b20617fc906%7C0%7C1%7C637522075778298124%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzI

Re: [EXTERNAL] [libreoffice-users] Non-breaking dash/hyphen

2021-03-24 Thread John Kaufmann


Excellent! (I was wondering what happened to U+2011 as I investigated the "General 
Punctuation" group.) So it's just a matter of the Liberation family not covering the 
U+2011 codepoint - but a replacement glyph is provided. Thanks!

You used a term I don't recognize: "NPC".  My search turned up that it is a popular abbreviation for 
"non-playing character" in domains like WoW, Runelite and lots of other things of which I know nothing, but 
fortunately I don't think you used it in that context. I suspect it is close to that textually -- "non"  
"character" -- but I decided I had best ask: ?


On 2021-03-24 14:56, V Stuart Foote wrote:

You've missed the one Unicode point that does exactly what you require, but its 
use will depend on the font in use.

U+2011 NON-BREAKING HYPHEN

You can enter via LibreOffice Special Character dialog, or LibreOffice's Unicode 
toggle. That is you can type U+2011 and then +X to toggle the glyph.

If the font in use does not "cover" the codepoint, you'll get a fallback 
replacement or possibly the no glyph value for the font.

When added to canvas the non-breaking hyphen character will receive NPC 
highlighting.



From: John Kaufmann 
Sent: Wednesday, March 24, 2021 1:31 PM
To: LibreOffice Users 
Subject: [EXTERNAL] [libreoffice-users] Non-breaking dash/hyphen

   **EXTERNAL EMAIL**
   This email originated outside of The University of Texas at San Antonio.
   Please exercise caution when clicking on links or opening attachments.



I had always thought that the difference between a "dash" and a "hyphen" is 
that the dash is a character (that is, will not break a character string), while the hyphen 
hyphenates (that is, breaks at the end of a line if the character string following the hyphen is 
too long to fit on the line).  So, needing a non-breaking substitute for that horizontal bar on my 
keyboard, I invoked:
 Insert > Special Character
to get (what I would call) a dash.

LibreOffice has such mid-height horizontal-bar characters in three character 
groups:
"General punctuation", characters:
 U+2010 (HYPHEN)
 U+2012 (FIGURE DASH)
 U_2013 (EN DASH)
 U+2014 (EM DASH)
 U+2015 (HORIZONTAL BAR)
"Mathematical Operators", character:
 U+2212 (MINUS SIGN)
"Box Drawing", character:
 U+2500 (BOX DRAWINGS LIGHT HORIZONTAL)

The five characters of the "General Punctuation" group mostly seem to just 
represent different widths of hyphen (despite three being called FIGURE DASH, EN DASH, EM 
DASH), in that in a character string each will end a line of characters if the string 
following is too long to fit. Only the HORIZONTAL BAR acts as a common character, such 
that the string of which it is a member will not break there; but it is very long to be 
used as a non-breaking hyphen.

The MINUS SIGN in the "Mathematical Operators" group has a special operation: 
It will break at the end of a line, but will itself move to the next line, to stay with 
the character following MINUS SIGN.

The BOX DRAWINGS LIGHT HORIZONTAL character acts like the HORIZONTAL BAR -- 
that is, as a true, non-breaking character -- but is also too long to be used 
generally as a non-breaking hyphen.

Is there a clean way to make a non-breaking dash/hyphen?

-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

[libreoffice-users] Non-breaking dash/hyphen

2021-03-24 Thread John Kaufmann


I had always thought that the difference between a "dash" and a "hyphen" is 
that the dash is a character (that is, will not break a character string), while the hyphen 
hyphenates (that is, breaks at the end of a line if the character string following the hyphen is 
too long to fit on the line).  So, needing a non-breaking substitute for that horizontal bar on my 
keyboard, I invoked:
Insert > Special Character
to get (what I would call) a dash.

LibreOffice has such mid-height horizontal-bar characters in three character 
groups:
"General punctuation", characters:
U+2010 (HYPHEN)
U+2012 (FIGURE DASH)
U_2013 (EN DASH)
U+2014 (EM DASH)
U+2015 (HORIZONTAL BAR)
"Mathematical Operators", character:
U+2212 (MINUS SIGN)
"Box Drawing", character:
U+2500 (BOX DRAWINGS LIGHT HORIZONTAL)

The five characters of the "General Punctuation" group mostly seem to just 
represent different widths of hyphen (despite three being called FIGURE DASH, EN DASH, EM 
DASH), in that in a character string each will end a line of characters if the string 
following is too long to fit. Only the HORIZONTAL BAR acts as a common character, such 
that the string of which it is a member will not break there; but it is very long to be 
used as a non-breaking hyphen.

The MINUS SIGN in the "Mathematical Operators" group has a special operation: 
It will break at the end of a line, but will itself move to the next line, to stay with 
the character following MINUS SIGN.

The BOX DRAWINGS LIGHT HORIZONTAL character acts like the HORIZONTAL BAR -- 
that is, as a true, non-breaking character -- but is also too long to be used 
generally as a non-breaking hyphen.

Is there a clean way to make a non-breaking dash/hyphen?

-John

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

Re: [libreoffice-users] typing delay?

2021-03-18 Thread John Kaufmann


On 2021-03-17 11:43, Suzie Reedy wrote:


I am getting a delay when I type documents in Libre Office.  (what appears on 
the screen is several words behind what I am actually typing).  We have other 
users in our office who are not having this problem.  Any ideas on how to fix 
it?  I am using a Mac running 10.14 Mojave.


That sounds like a system problem, not an application problem.  Are your other 
LibreOffice users running the same system on the same hardware?

--
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: Autocorrect Problem

2021-03-12 Thread John Kaufmann


Thanks for posting what you found - it led to learning something really useful 
.

On 2021-03-12 00:51, das wrote:


(Though no one responded to my mail, I am replying with the solution, for
information service.)

For around two months I was facing this problem with both the two versions
of libreoffice in arch linux -- the 'still' one and the 'fresh' one. With
none of them Autocorrect was working. I tried en_US, en_Gb, and obviously
my own language bn_IN. Nowhere it was working. So, I wrote to this mailing
list.

This morning I got the solution. I installed snap and then enabled
snapd.socket with systemctl and installed libreoffice with snap. And now it
is working exactly as it should.



On Thu, Mar 4, 2021 at 1:43 PM das wrote:


Dear Friends

My Libreoffice is 7.0.4.2 on Arch Linux, Kernel is 5.10.19-1-lts. My
default language is en_US. And I also use Indic Language Bangla with it.

Autocorrect was working fine some time back. But these days I am seeing
that they are not working anymore.

Any help?

Thanks in Advance

Dipankar Das


--
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] Write Closed but Windows 10 won't provide safe to remove flash drive

2021-03-08 Thread John Kaufmann


On 2021-03-07 10:03, Luuk wrote:

...
Using openfiles.exe (from Microsoft) you can see which files are open.


first you have to enable it using: openfiles /Local ON    (and do a reboot)
After that you can query with files are open using : openfiles /Query .


Thanks! Very handy to know about.

--
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 ask a question on Ask LibreOffice?

2021-02-17 Thread John Kaufmann



On 2021-02-17 16:07, Dave Howorth wrote:

On Wed, 17 Feb 2021 11:36:34 -0500 John Kaufmann wrote:
...

... It sounds like you know Discourse and find the mailing list
side wanting. But if Discourse is an attempt to serve in a single
forum users comfortable in both media, it may at least /become/ a
solution to the problem of a fragmented user knowledge base.


In my experience it becomes a way of forcing the email users to use
the web forum instead. The only purpose the email interface serves
in practice is notifying of web posts.


AskLibO already gives us that. I have to believe (and certainly hope) Discourse 
offers something more.


Even a bridge as Sophie suggests is likely to kill the mailing list IMHO.


If "kill" means changing the list address, that may be a price worth paying for 
a larger user base. (FTM, I wonder how the larger user base on AskLibO will react/adapt 
to Discourse.) If it means losing anyone now on the mailing list, I can only hope that is 
incorrect.

--
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 ask a question on Ask LibreOffice?

2021-02-17 Thread John Kaufmann


On 2021-02-17 10:22, Dave Howorth wrote:

On Wed, 17 Feb 2021 09:03:41 -0500 John Kaufmann wrote:

On 2021-02-17 04:06, sophi wrote:


Just to let you know, we, at TDF, are working on replacing the Ask
forum by Discourse. We have had a test period with the members
regularly answering on Ask. If Discourse is not fully replacing a
Q forum, it is the most appropriate at the moment and we can
extend it to serve other purposes on the future. ...


Looks interesting, and seems to have potential to subsume also the
mailing list system. (It needs to be integrated with a MTA, which it
does not provide, but merging web and mailing list forums seems to be
an explicit objective.) If so, that could solve the problem of which
forum (AskLibO or mailing list) to use for a question. Is the intent
to also migrate the mailing lists to Discourse?


I seriously hope not! Discourse works OK as a forum but the mailing
list side is very much a poor cousin. Far easier and better to use a
plain mailing list IME & IMHO.


I sympathize, Dave; I also like a mailing list or newsgroup. It sounds like you 
know Discourse and find the mailing list side wanting. But if Discourse is an 
attempt to serve in a single forum users comfortable in both media, it may at 
least /become/ a solution to the problem of a fragmented user knowledge base.

I'm hopeful,
-John

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

Re: [libreoffice-users] How to ask a question on Ask LibreOffice?

2021-02-17 Thread John Kaufmann


On 2021-02-17 04:06, sophi wrote:


Just to let you know, we, at TDF, are working on replacing the Ask forum
by Discourse. We have had a test period with the members regularly
answering on Ask. If Discourse is not fully replacing a Q forum, it is
the most appropriate at the moment and we can extend it to serve other
purposes on the future.
The difficulty is currently to migrate the Ask archive to Discourse, but
that will be worked out by our infra team on the next months.


Looks interesting, and seems to have potential to subsume also the mailing list 
system. (It needs to be integrated with a MTA, which it does not provide, but 
merging web and mailing list forums seems to be an explicit objective.) If so, 
that could solve the problem of which forum (AskLibO or mailing list) to use 
for a question. Is the intent to also migrate the mailing lists to Discourse?


BTW, it was amusing to learn that not everyone is a fan. The Wikipedia description is the 
third hit on a search "discourse forum" in both DuckDuckGo and Google, but they 
summarize it differently:
Google: "Discourse is an open source Internet forum and mailing list 
management software application ..."
DuckDuckGo: "Discourse is an awful open source Internet forum and mailing 
list management software application ..."
:-)
FWIW, I look forward to seeing it,
-John

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

Re: [libreoffice-users] How to ask a question on Ask LibreOffice?

2021-02-16 Thread John Kaufmann


Dave,

Like Rob, I've never had a problem with the mechanics of asking on AskLibO, but a few weeks ago 
asked a "meta"-question related to yours ("LO help communities", Jan.21, if you 
want to look it up in Nabble): How to determine the best place to ask a question. LO has a rich 
panoply of help resources -- most notably AsLibO and this list, with some great people sharing 
their knowledge on both, but usually (with notable exceptions) staying within one venue. [AskLibO 
tends to get more traffic than this list.]

Given that diversity, and the fact that time is limited, it's perfectly 
reasonable that people with knowledge, and a conscientious willingness to share 
it, simply won't see questions for which they might have answers. I don't know 
how to mitigate that problem, because I don't know how to integrate the 
web-based AskLibO with a mailing list (or even with the web-based Nabble forum).

Reading between lines of the archives, I infer that the Ask system is or was a 
project of Drew Jensen, who has been extremely helpful also as a content 
contributor to LO in lots of ways, including on this list (and the earlier OO 
list), as well as on AskLibO. Your LO email address indicates that you may know 
him or have worked with him. Maybe you could take it up with him directly on 
both these issues. Likely he has answers about your posting problems, and he 
may have thoughts, from his Ask experience, about the number of questions that 
don't make it to the full range of people with answers. If there are concerns 
in TDF about the Ask system, that could be a particularly apt discussion at 
this time.

John


On 2021-02-16 10:31, Dave Barton wrote:

Thanks for taking the time to reply Rob.
Unfortunately my experience of Ask is the total opposite of yours.
I log into Ask enter my question, add the details, tags, go through
the "I'm not a robot" reCAPTCHA and click the "Ask Your Question"
button and ZIP, nothing happens.
Tried with 4 different browsers and 3 OS, with same result.

Dave

 Original Message 
From: Rob Jasper
Sent: Tuesday, February 16, 2021, 14:33 UTC
To: Dave Barton
Cc: LibreOffice Users
Subject: [libreoffice-users] How to ask a question on Ask LibreOffice?


Dave,

I never had a problem with ask. I just get there the easy way by
clicking Help -> Get help online. Type you question (or keyword) to
find equivalent questions and answers, after that click the orange
button to ask the question.

Success, Rob.


Op 16 feb. 2021, om 13:52 heeft Dave Barton het volgende geschreven:

Since I got no response to an earlier post to this list, I
attempted to post in the Ask forum. Numerous attempts to post
failed. I guess a bug report in Bugzilla is now the only option.

I recall some murmurings about TDF seeking an alternative to the
Ask software. In my opinion, this should happen sooner rather
than later.

Dave


--
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] Date auto-mangle

2021-02-03 Thread John Kaufmann


LO 6.4.6.2 (x64)

Revisiting a 3-year-old document (probably produced in LOW 5.4.x [that information is not in File 
Properties, where I thought to find it]), I find that Writer now insists on rendering dates in a 
table in "localized" (m/d/) format -- an action triggered as soon as the cursor lands 
on such date and then leaves that cell. Of course I don't want that crap (had I wanted that format, 
I would have written it that way) so looked for a way to turn off such "help". But I 
don't see it in either the Autocorrect|Options or in the Options settings. That prompts these 
questions:

(1) How does one turn off such "help"?

(2)  Does anyone know when (with what version) such "help" began?
[Going through the archive 
, I don't even 
/see/ release notes, even five levels down, short of actually downloading a package 
(and maybe not even then). Even if those release notes exist, 70+ releases just since 
5.4.7 make looking through all those release notes a daunting prospect. I /have/ 
looked through the 7.0.4 and 7.1.0 release notes, and do not see a correction of this 
behavior.]

(3) An important bug, 46448 of 2012-02-22  addressed the problems with LO's 
misguided "localization" efforts, going back at least to OO in 2011. It has 59 comments, with simple solution summaries in comments 53 
and 57 (no dissents). Noting that the number of LO duplicates of the bug exceeded 5 (currently 14 duplicates), Xisco Fauli (comment 23) changed 
priority to "high". Noting the large number of comments, and the consequences of some date/numeric failures, Christopher Lee (comment 
59) suggested changing that priority from "high" to "fatal" (no dissenting comments). Yet throughout that process, LO has 
gone in the /other direction/, toward more extreme "localization" "help", with even more of the consequences described in the 
bug thread. Does anyone know how that happens?

John

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

Re: [libreoffice-users] Re: Meet the 2020 IEEE PES Wanda Reder Pioneer Power Award Recipient

2021-01-28 Thread John Kaufmann


On 2021-01-28 16:47, John Kaufmann wrote:

What is sychropopular?  Do you mean synchrophasor? ...


My profound apologies to the list for that. I have no idea how this list was 
added to the distribution of that reply to an (HMTL) mail from IEEE Power and 
Energy Society.

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

[libreoffice-users] Re: Meet the 2020 IEEE PES Wanda Reder Pioneer Power Award Recipient

2021-01-28 Thread John Kaufmann

What issychropopular?  Do you meansynchrophasor?-John Kaufmann1-724-433-0459On 
2021-01-28 16:00, IEEE Power and Energy Society wrote:
#outlook a {
  padding: 0;
}.ReadMsgBody {
  width: 100%;
}.ExternalClass {
  width: 100%;
}.ExternalClass,
.ExternalClass p,
.ExternalClass span,
.ExternalClass font,
.ExternalClass td,
.ExternalClass div {
  line-height: 100%;
}html { -webkit-text-size-adjust:none; }body{font-family:Arial, Helvetica, 
sans-serif;}p, .undoreset div p, .undoreset p {
margin-top: 14px;
margin-bottom:14px;  
}img{border:0px !important;}a[x-apple-data-detectors] {
color: inherit !important;
text-decoration: none !important;
font-size: inherit !important;
font-family: inherit !important;
font-weight: inherit !important;
line-height: inherit !important;
}ul.webinar {
padding: 0; margin-left: 1em;
}.textColor {color:#33  !important;outline: none !important; 
text-decoration:none !important; }.btnLine{text-decoration:underline  
!important;}a{outline: none !important; text-decoration:none !important; 
}.mktoVideo a table{width:100% !important;}To view this
  email as a web page,click here
  


  

  At IEEE PowerEnergy Society
  (PES), we are incredibly
  proud to spotlight the
  finale of our series with
  Yilu Lu, the 2020 IEEE PES
  Wanda Reder Pioneer Power
  Award Recipient.
Yilu Lu is a
  Professor at the
  University of
  Tennessee, Knoxville
  (UTK) and Governer’s
  Chair at Oak Ridge
  National Laboratory.
  We thank Yilu for
  innovative
  contributions and
  leadership in
  sychropopular-based
  wide area monitoring
  and control systems.


  Learn
more about Yilu and other
IEEE PES Award recipientsby 
downloading the awards
program here.



Join
  PES todayand receive
complimentary access to our
continuingeducation
program content in ourResource
  Center, PDF downloadsof
our PES magazines 
-ElectrificationandPowerEnergy,
exclusive reduced rates to
PES financially sponsored
events, and more!


  
Join
  PowerEnergy
  Society!


Reduced
IEEE membership
available, to those who
qualify. Learn morehere.


  
  
  


You received this
  communication because you have
  expressed interest in learning
  more about IEEE PowerEnergy related 
topics.
If you no longer wish to
  receive all communications
  related to this technical
  interest, please update yourTechnical
Interest Profile.To unsubscribe 
from PES Awards
  communicationsclick
here.


  
 © 2021
  IEEE– All
  rights
  reserved.


 Website | Privacy
  Policy | Contact


Access
  Your Free
  Papers




  
-- 
To unsubscribe e-mail to:

Re: [libreoffice-users] LO help communities

2021-01-22 Thread John Kaufmann


On 2021-01-21 06:37, Dave Howorth wrote:

On Thu, 21 Jan 2021 03:17:38 -0500 John Kaufmann wrote:


This is a meta-question about help for LibreOffice questions.

(1) LibreOffice has a comprehensive array of mailing lists
...
(2) There is another great resource, the AskLibO system
<https://ask.libreoffice.org/en/>.
...
... There are some really thoughtful people in both communities,
but [with notable exceptions] most do not seem to mix from one to
the other, though both communities cover the same scope of
questions. It makes sense that people are not active in both
places: there are limited hours in the day. But I'm never sure
where is the best place to ask a use question, and at the same time
would like to pay back something in the form of information to
whichever community I use. How do others handle that issue?


I can only speak for myself, although I suspect others also think
similarly. I prefer the medium of mailing lists to that of forums in
general. It may be to do with previous experience and age in general.
So I use mailing lists whenever they are available, and forums only if
I must. Hence I subscribe to this list, and ask questions here when I
need to and otherwise use a search engine to find relevant pages on the
web, which might include hits on the forums.


That's certainly my inclination (likely for the same reasons) -- though both 
communities are so valuable that it almost seems that each deprives the other 
of excellent resources. Also, it's telling that it seemed easier to ask this 
meta-question in this mailing list rather than on the AskLibO forum. However, I 
guess the follow-on question, about the discrepancies between AskLibO's 
web-based questions and emailed question digests, will have to be put in that 
forum.

As I try to think about how to make best use of these resources, Thanks for 
your reply,
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

[libreoffice-users] LO help communities

2021-01-21 Thread John Kaufmann

This is a meta-question about help for LibreOffice questions.

(1) LibreOffice has a comprehensive array of mailing lists
@global.libreoffice.org, each of which
seems to be reflected and archived in Nabble
.
(This list is one of those lists.) That combination is a
wonderful resource.

In addition to global lists @global.libreoffice.org (all in English), there
are dozens of local/regional/national lists @.libreoffice.org, which vary
in scope and quality and lack the Nabble archive.

Finally, there are global lists @documentfoundation.org, and a set of
development and QA lists at freedesktop.org. These are all beyond the scope of
my question here.

(2) There is another great resource, the AskLibO system
. It is less comprehensive in scope than the mailing
list system @global.libreoffice.org, essentially covering the scope of this users list. It
does so in 15 languages, but English has by far the most traffic, so is roughly equivalent
to this list .

(a) With that context, here is my question, essentially comparing the communities in the
mailing list and the AskLibO forum
: There are some really thoughtful people in both
communities, but [with notable exceptions] most do not seem to mix from one to the other,
though both communities cover the same scope of questions. It makes sense that people are
not active in both places: there are limited hours in the day. But I'm never sure where is
the best place to ask a use question, and at the same time would like to pay back something
in the form of information to whichever community I use. How do others handle that issue?

(b) Having asked that question, I offer my own (incomplete) take on it: Because
time is limited, a mailing list (or newsgroup) has an inherent push advantage
over a web forum; you don't have to check into the forum to see questions.
That's why AskLibO pushes a daily list of questions by mail, and you then
follow the links in the mail. OTOH, the web forum is its own archive, which has
advantages. Am I missing anything in the advantages of each?

(c) Having said that AskLibO pushes a daily list of questions/links, there is
one additional fillip: When you contribute an answer to a question, you become
part of a mailing list group for that question. When there is an update due to
one or more new contributions, you get mail with a digest of the issue and a
link to return to the question page -- which seems fair enough, except that the
digest can contain comments that never make it onto the question page! So you
can have someone answer a follow-up question or comment in the mailed digest,
but only the answer, and not the question, is recorded on the question page!
The result can be disorienting (hard to follow the thread), and of course gives
an incomplete record of the discussion. Unfortunately, I don't even know who or
how to ask about that (including how user comments or questions even get into
the digest if they are not on the page!) in AskLibO. If anyone knows how that
works, I would love some direction.

John

Re: [libreoffice-users] Re: Fit last column in spreadsheet to print

2021-01-10 Thread John Kaufmann


On 2021-01-11 01:14, John Kaufmann wrote:

On 2021-01-11 00:45, Brian Barker wrote:

At 00:21 11/01/2021 -0500, John Kaufmann wrote:

Sorry, but I don't follow: What does it mean for a spreadsheet to print one 
sheet wide?


See "Printing options for page styles" in Chapter 6, "Printing, Exporting, 
E-mailing, and Signing" of the Calc Guide.

o Go to Format | Page... | Sheet | Scale.
o Set "Scaling mode" to "Fit print range(s) to width/height" and "Width in 
pages" to 1.


Very nice! I had overlooked that. Thanks, Brian.


... (especially in an environment where a sheet could be a million columns wide)


... (Er, sorry, but maximum columns per sheet is 1024.)


I did exaggerate, didn't I? 10^6 high, but only 10^3 (AMJ) wide. I should have 
checked.


Um, sorry: That should be 2^20 high by 2^10 (AMJ) wide.
[That was sloppy.]

--
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: Fit last column in spreadsheet to print

2021-01-10 Thread John Kaufmann


On 2021-01-11 00:45, Brian Barker wrote:

At 00:21 11/01/2021 -0500, John Kaufmann wrote:

Sorry, but I don't follow: What does it mean for a spreadsheet to print one 
sheet wide?


See "Printing options for page styles" in Chapter 6, "Printing, Exporting, 
E-mailing, and Signing" of the Calc Guide.

o Go to Format | Page... | Sheet | Scale.
o Set "Scaling mode" to "Fit print range(s) to width/height" and "Width in 
pages" to 1.


Very nice! I had overlooked that. Thanks, Brian.
 

... (especially in an environment where a sheet could be a million columns wide)


... (Er, sorry, but maximum columns per sheet is 1024.)


I did exaggerate, didn't I? 10^6 high, but only 10^3 (AMJ) wide. I should have 
checked.


I trust this helps.


You bet. Thanks again,
John

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

Re: [libreoffice-users] Re: Fit last column in spreadsheet to print

2021-01-10 Thread John Kaufmann


On 2021-01-10 18:07, Alan B wrote:

...
Your initial question was "...see how I can fit the last column in to print
on  8/12 x 11..." which to me is equivalent to "fit all columns on a single
sheet". So the answer is to set the page width of the printout to one sheet
wide.


? Sorry, but I don't follow: What does it mean for a spreadsheet to print one 
sheet wide?
(especially in an environment where a sheet could be a million columns wide)

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

2021-01-01 Thread John Kaufmann


Hi Michael,

With the help of Dave Howorth's links to the OpenDocument spec, I just spent a 
couple hours trying to track down and understand your references, and realize 
that I am:
 (a) in over my head (even just to understanding the relevance of the different 
files organized under v.1.2), and
 (b) nowhere near a solution to how to test if a field is empty for the purpose 
of controlling conditional text.

[Indeed, I could not even see the connection between the schema for 
text:condition and my understanding of Writer's conditional text functions. It 
appears that working through the spec would take months -- and even then I'm 
not sure I would see the relationship to LO program design and functionality. 
(I wonder if that does not reflect your own experience, as you described it.)]

Thank you so much for the education in LO design, which I will mark to study 
further, but I can't afford to study it further now. I'm afraid I will have to 
accept that LO Writer cannot (for now) do what I thought it might do.

Kind regards,
John


On 2021-01-01 15:46, Michael H wrote:

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.



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

2021-01-01 Thread John Kaufmann

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?

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

2021-01-01 Thread John Kaufmann


Hi Michael,

Sorry, I should have given an example:
Suppose there is a daily or weekly report, which includes a database query of 
birthday(s) for that report period. If so, the birthday-relevant text or table 
is included, with the specific birthdays; otherwise, no such text or table.

So the generalization is that you have a class -- say, birthdays -- and the 
test is whether you have any instances of that class for the period (or other 
domain) of interest. Writer makes it easy to conditionally hide or reveal a 
section of text, but not (AFAIK) to include as a condition whether a field is 
instantiated or empty.

The example you give is extremely interesting. I would not have thought of it, 
if only because it requires coordination of Calc and Writer [which I have not 
thought about how to do].  But the biggest essential difference is one that you 
identify -- keeping the 'conditions' outside the document itself -- where my 
initial premise was (and I think remains) to use Writer's conditional-text 
features within the Writer document.

Your example is a great one to study (and to think about how you coordinate 
Calc and Writer), but I think that Writer alone can do this job [as WordPerfect 
does] if there is a way to implement the condition that a field is either empty 
or filled/instantiated.  Moreover, that approach (rather than keeping the 
conditional text outside the document) allows the use of Writer's rich 
conditional-text features.  The one feature that I'm trying to reproduce is 
WordPerfect's ability to test whether any field of merged data is empty or 
instantiated, and use that test to conditionally hide or reveal a section of 
text.

Thanks for your reply,
John


On 2021-01-01 10:39, Michael H wrote:

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

1 2 >

1 - 100 of 170 matches

Mail list logo