from:"Steve Edmonds"

Re: [libreoffice-users] Different character spacing on different PCs in writer.-Update, May be Resolved

2024-08-28 Thread Steve Edmonds




On 27/08/2024 17:29, Steve Edmonds wrote:




On 26/08/24 10:03 pm, aguador wrote:


El lun, 26-08-2024 a las 17:02 +1200, Steve Edmonds escribió:


On 26/08/2024 12:17, Steve Edmonds wrote:


On 24/08/2024 12:08, Steve Edmonds wrote:


On 22/08/2024 22:46, Dave Howorth wrote:

On Thu, 22 Aug 2024 07:44:13 +1200
Steve Edmonds  wrote:


I am sure this must have come up before but can't locate any
discussion. In writer the same odt file presents different
horizontal
character spacing between different PCs. This means sharing
the
document for editing is not necessarily possible.
In the manual I am editing at present the difference adds 4
pages.
The font used is installed from the same font file. Nothing
is
inherited from the default paragraph style.

It seems likely to have something to do with the font you are
using, so
more details would be helpful. When considering different
machines,
what do you mean by 'the same font file'?

Specifically what is the full path of the font file, and have
you
compared the files on the different machines (using e.g. diff)?

Also what versions of writer are you using?



Thanks for the tips

Versions of Writer.
PCs with wider character spacing.
Linux Opensuse 15.5, LO 24.2.4.2, Intel and Nvidia graphics card
Macbook Air, Monterey 12.7.6, LO 24.2.5.2

PCs with narrower spacing.
Linux Opensuse 15.5, LO 24.2.4.2, Intel and Nvidia graphics card
Windows Laptop, Win 10.0, LO 24.2.3.2

The Font is Roboto-Regular.ttf.
The font was installed from the same .ttf file. The Macbook (with
wide spacing) and the Win10 laptop (narrow spacing) both have
only
the one version of Roboto-Regular.ttf, the same size.

The Opensuse machines both have the same font as above installed
in
/usr/share/fonts/truetype/Roboto-Regular.ttf
The Opensuse machine displaying closer characters has a different
version of the font in
/home/steve/Qt/6.6.2/Src/qtwebengine/src/3rdparty/chromium/third_
party/skia/tools/perf-canvaskit-
puppeteer/canvas_perf_assets/Roboto-Regular.ttf

The Opensuse machine displaying wider spaced characters has a
different version of the font in ./fonts/truetype/Roboto-
Regular.ttf.
This may be the issue, I will remove it and check.


The duplicate of the font has been removed from the Opensuse
machine
displaying wider spaced characters and no difference is observed
making this PC the same as the Macbook with only one copy of the
font.


I have done a little more detailed comparison between the document on
the Macbook and the Linux machine displaying narrower character
spacing.
The line spacing on the Macbook is also greater than on the Linux
machine, I get 2 fewer lines on a page.
Is there a setting that affects the font size that overrides the
paragraph style, no character style is applied.
Steve


Hi Steve,

This is probably not it, but in work for a translation client who
produces large files I discovered that on one of my machines in
Settings>Load>General I had the first box ticked that applies the users
format to the document. That was slowing the loading time and changing
the number of pp.

I would also check that the compatibility options for Writer are the
same on your machines.

Interesting problem. Hope you find the solution.

Best,
Roy


Thanks Roy. I may have a way to resolve the issue.
Settings>Load>General are the same. Compatibility options are the 
same. Thanks for the suggestions.


In short, the document with the issue has paragraphs that are bulleted 
using the bullet button in the tool bar. I found that by turning these 
bullets off and using a bullet list style instead adjusted to the same 
measurements as the button list the document that showed wider 
character spacing and increased line spacing on the mac now displays 
the same as the Linux and Win10 machines with the narrower character 
spacing. I will check the other Linux machine tomorrow.


It was not just the bulleted lists, the issue persisted. It was not the 
font, a basic document with 150 pages of flowing text in the same Roboto 
font displayed identical on both machines.
What I have noticed now is that when a numbering list style is applied 
the character style on the Customise tab of the style definition is not 
applied, neither is the paragraph font. By chance I noticed when the 
cursor was in front of the numbering it was of a font that was not 
installed so line spacing was arbitrarily affected by the font 
substitution.


I can change the font at any level of numbering from the tool bar in the 
head of the window (with the cursor in front of that font) and this 
change is automatically saved in the list style definition currently 
active (even though it contradicts the character style showing) for just 
that level and applied to all occurrences in the document of that list 
style and level.

I couldn't find a related bug posted.
steve


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-l

Re: [libreoffice-users] Different character spacing on different PCs in writer.-Resolved

2024-08-26 Thread Steve Edmonds





On 26/08/24 10:03 pm, aguador wrote:


El lun, 26-08-2024 a las 17:02 +1200, Steve Edmonds escribió:


On 26/08/2024 12:17, Steve Edmonds wrote:


On 24/08/2024 12:08, Steve Edmonds wrote:


On 22/08/2024 22:46, Dave Howorth wrote:

On Thu, 22 Aug 2024 07:44:13 +1200
Steve Edmonds  wrote:


I am sure this must have come up before but can't locate any
discussion. In writer the same odt file presents different
horizontal
character spacing between different PCs. This means sharing
the
document for editing is not necessarily possible.
In the manual I am editing at present the difference adds 4
pages.
The font used is installed from the same font file. Nothing
is
inherited from the default paragraph style.

It seems likely to have something to do with the font you are
using, so
more details would be helpful. When considering different
machines,
what do you mean by 'the same font file'?

Specifically what is the full path of the font file, and have
you
compared the files on the different machines (using e.g. diff)?

Also what versions of writer are you using?



Thanks for the tips

Versions of Writer.
PCs with wider character spacing.
Linux Opensuse 15.5, LO 24.2.4.2, Intel and Nvidia graphics card
Macbook Air, Monterey 12.7.6, LO 24.2.5.2

PCs with narrower spacing.
Linux Opensuse 15.5, LO 24.2.4.2, Intel and Nvidia graphics card
Windows Laptop, Win 10.0, LO 24.2.3.2

The Font is Roboto-Regular.ttf.
The font was installed from the same .ttf file. The Macbook (with
wide spacing) and the Win10 laptop (narrow spacing) both have
only
the one version of Roboto-Regular.ttf, the same size.

The Opensuse machines both have the same font as above installed
in
/usr/share/fonts/truetype/Roboto-Regular.ttf
The Opensuse machine displaying closer characters has a different
version of the font in
/home/steve/Qt/6.6.2/Src/qtwebengine/src/3rdparty/chromium/third_
party/skia/tools/perf-canvaskit-
puppeteer/canvas_perf_assets/Roboto-Regular.ttf

The Opensuse machine displaying wider spaced characters has a
different version of the font in ./fonts/truetype/Roboto-
Regular.ttf.
This may be the issue, I will remove it and check.


The duplicate of the font has been removed from the Opensuse
machine
displaying wider spaced characters and no difference is observed
making this PC the same as the Macbook with only one copy of the
font.


I have done a little more detailed comparison between the document on
the Macbook and the Linux machine displaying narrower character
spacing.
The line spacing on the Macbook is also greater than on the Linux
machine, I get 2 fewer lines on a page.
Is there a setting that affects the font size that overrides the
paragraph style, no character style is applied.
Steve


Hi Steve,

This is probably not it, but in work for a translation client who
produces large files I discovered that on one of my machines in
Settings>Load>General I had the first box ticked that applies the users
format to the document. That was slowing the loading time and changing
the number of pp.

I would also check that the compatibility options for Writer are the
same on your machines.

Interesting problem. Hope you find the solution.

Best,
Roy


Thanks Roy. I may have a way to resolve the issue.
Settings>Load>General are the same. Compatibility options are the same. 
Thanks for the suggestions.


In short, the document with the issue has paragraphs that are bulleted 
using the bullet button in the tool bar. I found that by turning these 
bullets off and using a bullet list style instead adjusted to the same 
measurements as the button list the document that showed wider character 
spacing and increased line spacing on the mac now displays the same as 
the Linux and Win10 machines with the narrower character spacing. I will 
check the other Linux machine tomorrow.


Steve


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

Re: [libreoffice-users] Different character spacing on different PCs in writer.

2024-08-25 Thread Steve Edmonds

On 26/08/2024 12:17, Steve Edmonds wrote:

On 24/08/2024 12:08, Steve Edmonds wrote:

On 22/08/2024 22:46, Dave Howorth wrote:

On Thu, 22 Aug 2024 07:44:13 +1200
Steve Edmonds wrote:

I am sure this must have come up before but can't locate any
discussion. In writer the same odt file presents different horizontal
character spacing between different PCs. This means sharing the
document for editing is not necessarily possible.
In the manual I am editing at present the difference adds 4 pages.
The font used is installed from the same font file. Nothing is
inherited from the default paragraph style.

It seems likely to have something to do with the font you are using, so
more details would be helpful. When considering different machines,
what do you mean by 'the same font file'?

Specifically what is the full path of the font file, and have you
compared the files on the different machines (using e.g. diff)?

Also what versions of writer are you using?

Thanks for the tips

Versions of Writer.
PCs with wider character spacing.
Linux Opensuse 15.5, LO 24.2.4.2, Intel and Nvidia graphics card
Macbook Air, Monterey 12.7.6, LO 24.2.5.2

PCs with narrower spacing.
Linux Opensuse 15.5, LO 24.2.4.2, Intel and Nvidia graphics card
Windows Laptop, Win 10.0, LO 24.2.3.2

The Font is Roboto-Regular.ttf.
The font was installed from the same .ttf file. The Macbook (with
wide spacing) and the Win10 laptop (narrow spacing) both have only
the one version of Roboto-Regular.ttf, the same size.

The Opensuse machines both have the same font as above installed in
/usr/share/fonts/truetype/Roboto-Regular.ttf
The Opensuse machine displaying closer characters has a different
version of the font in
/home/steve/Qt/6.6.2/Src/qtwebengine/src/3rdparty/chromium/third_party/skia/tools/perf-canvaskit-puppeteer/canvas_perf_assets/Roboto-Regular.ttf

The Opensuse machine displaying wider spaced characters has a
different version of the font in ./fonts/truetype/Roboto-Regular.ttf.
This may be the issue, I will remove it and check.

The duplicate of the font has been removed from the Opensuse machine
displaying wider spaced characters and no difference is observed
making this PC the same as the Macbook with only one copy of the font.

I have done a little more detailed comparison between the document on
the Macbook and the Linux machine displaying narrower character spacing.
The line spacing on the Macbook is also greater than on the Linux
machine, I get 2 fewer lines on a page.
Is there a setting that affects the font size that overrides the
paragraph style, no character style is applied.

Steve

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

Re: [libreoffice-users] Different character spacing on different PCs in writer.

2024-08-25 Thread Steve Edmonds




On 23/08/2024 17:57, Robert Großkopf wrote:

Hi Steve,

only a question about the two Linux-configurations:

Do you use LO from repositories of OpenSUSE or from LibreOffice directly?
Do you use different window manager like kde or gtk?
Using the same version of OpenSUSE here…


Hi Robert.
For the 2 Linux machines I use LO from the same Opensuse repository. 
24.2.4.2-150500.20.6.5, I use the same window manager KDE.
The Macbook and the Win10 machine that are also different use packages 
from the LO download page, although different versions.


--
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] Different character spacing on different PCs in writer.

2024-08-25 Thread Steve Edmonds

On 24/08/2024 12:08, Steve Edmonds wrote:

On 22/08/2024 22:46, Dave Howorth wrote:

On Thu, 22 Aug 2024 07:44:13 +1200
Steve Edmonds wrote:

It seems likely to have something to do with the font you are using, so
more details would be helpful. When considering different machines,
what do you mean by 'the same font file'?

Specifically what is the full path of the font file, and have you
compared the files on the different machines (using e.g. diff)?

Also what versions of writer are you using?

Thanks for the tips

Versions of Writer.
PCs with wider character spacing.
Linux Opensuse 15.5, LO 24.2.4.2, Intel and Nvidia graphics card
Macbook Air, Monterey 12.7.6, LO 24.2.5.2

PCs with narrower spacing.
Linux Opensuse 15.5, LO 24.2.4.2, Intel and Nvidia graphics card
Windows Laptop, Win 10.0, LO 24.2.3.2

The Font is Roboto-Regular.ttf.
The font was installed from the same .ttf file. The Macbook (with wide
spacing) and the Win10 laptop (narrow spacing) both have only the one
version of Roboto-Regular.ttf, the same size.

The Opensuse machine displaying wider spaced characters has a
different version of the font in ./fonts/truetype/Roboto-Regular.ttf.
This may be the issue, I will remove it and check.

The duplicate of the font has been removed from the Opensuse machine
displaying wider spaced characters and no difference is observed making
this PC the same as the Macbook with only one copy of the font.

Re: [libreoffice-users] Different character spacing on different PCs in writer.

2024-08-23 Thread Steve Edmonds

On 22/08/2024 22:46, Dave Howorth wrote:

On Thu, 22 Aug 2024 07:44:13 +1200
Steve Edmonds wrote:

It seems likely to have something to do with the font you are using, so
more details would be helpful. When considering different machines,
what do you mean by 'the same font file'?

Specifically what is the full path of the font file, and have you
compared the files on the different machines (using e.g. diff)?

Also what versions of writer are you using?

Thanks for the tips

Versions of Writer.
PCs with wider character spacing.
Linux Opensuse 15.5, LO 24.2.4.2, Intel and Nvidia graphics card
Macbook Air, Monterey 12.7.6, LO 24.2.5.2

PCs with narrower spacing.
Linux Opensuse 15.5, LO 24.2.4.2, Intel and Nvidia graphics card
Windows Laptop, Win 10.0, LO 24.2.3.2

The Font is Roboto-Regular.ttf.
The font was installed from the same .ttf file. The Macbook (with wide
spacing) and the Win10 laptop (narrow spacing) both have only the one
version of Roboto-Regular.ttf, the same size.

The Opensuse machine displaying wider spaced characters has a different
version of the font in ./fonts/truetype/Roboto-Regular.ttf. This may be
the issue, I will remove it and check.

Re: [libreoffice-users] Different character spacing on different PCs in writer.

2024-08-22 Thread Steve Edmonds



On 22/08/24 12:57 pm, ady wrote:

In writer the same odt file presents different horizontal character
spacing between different PCs.


Just a semi-random possibility...

Open (a backup of) your ODT file -> menu Tools -> Options ->
LibreOffice Writer -> Compatibility

Compare those settings in both installations.
Thanks Ady. The settings are the same there. A correction on the windows 
PC spec.

PCs with wider character spacing.
Linux Opensuse 15.5, LO 24.2.4.2, Intel and Nvidia graphics card
Macbook Air, Monterey 12.7.6, LO 24.2.5.2

PCs with narrower spacing.
Linux Opensuse 15.5, LO 24.2.4.2, Intel and Nvidia graphics card
Windows Laptop, Win 10.0, LO 24.2.3.2

Steve

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

[libreoffice-users] Different character spacing on different PCs in writer.

2024-08-21 Thread Steve Edmonds

I am sure this must have come up before but can't locate any discussion. 
In writer the same odt file presents different horizontal character 
spacing between different PCs. This means sharing the document for 
editing is not necessarily possible.

In the manual I am editing at present the difference adds 4 pages.
The font used is installed from the same font file. Nothing is inherited 
from the default paragraph style.
I have 2 Linux machines, same OS, same version of LO (24.2.4.2). One has 
wider character spacing than the other, wrapping more lines, moving 
images and adding 4 pages. If I apply a character style with -0.1pt 
character spacing it brings the wider spacing back close to the original 
spacing.
I have given the document to a colleague with Win11 for amendments and 
he sees the closer spacing. I have also loaded the document onto my MAC 
with LO 24.2.5.2 which displays the wider spacing.


I would appreciate any help in what may be causing this issue and how to 
control it. I am particularly perplexed with the fact that it can be 
different on 2 near identical PCs.

TIA

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

2024-05-20 Thread Steve Edmonds

For me this often happens if my document switches to English US when my 
dictionary is English UK.
Check the document language displayed in the bottom bar of writer and 
the dictionaries you have.


On 20/05/2024 03:27, D V wrote:

My spell check is no longer working! I don't believe I made any changes to
the settings but I may be mistaken. I've checked online for reasons that
may be causing this to happen but none have solved my situation.
Effectively, each time I select text to be checked the spell check pop up
window indicates that the process is complete indicating that there are no
misspelled words, which is not accurate. I have purposefully misspelled
words to test it. Can you please help resolve this?




--
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] Annoying reformatting issue.

2024-04-14 Thread Steve Edmonds




On 15/04/2024 02:30, Philip Jackson wrote:

Hi Chris,

On 13/04/2024 18:10, Chris J. wrote:

Ubuntu linux 23.10

LibreOffice 7.6.5.2


So, question; is there a way to automate the application of the 
styles and remove the tabs at the beginning of paragraphs. Normal 
find and replaces doesn't cut it. Otherwise I'm forced to go through 
several books by hand.


You can find tabs using the standard Find and Replace (Ctrl+H). In the 
Find box, enter \t and leave the Replace box  empty.


You will need to check the *Regular Expressions* box in the Find and 
Replace dialog.


Like all Find and Replace ops, be wary of hitting the 'Replace All' 
button in case you have used tabs anywhere else in the document other 
than at the start of a paragraph. \t will locate all the tabs used 
within the the doc.


If you *only* want to find a tab at the beginning of a paragraph, you 
can use ^\t in the Find box.  I checked this in LO 7.3.7.2 in Ubuntu 
2204 and it works fine.


You can also use Find and Replace to locate one paragraph style and 
replace it with another. In this case you will have to select the 
Paragraph Styles box. This operation works fine to change styles but 
it will not remove any 'ad hoc' manual formatting such as Bold, 
Italic, tabs which you may have applied in the unwanted paragraph 
style's text.


Chris, does chapter and heading text have leading tabs. When you talk 
about tabs a the beginning of paragraphs, I assume just the first lines 
of a paragraphs are indented with tabs and the rest of the paragraph 
text just flows without line breaks. Do you have multiple leading tabs 
or is it always a single tab with may be varying tab position. I have 
had occasion to clean a plain text document by removing line breaks from 
single lines to form a paragraph and remove indenting tabs. i.e. replace 
a linebreak followed by 1 or more tabs with a single space when the line 
break is not at the beginning of a line. Hopefully this is not your 
situation.


--
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] Printer not showing in LO print dialog

2024-04-09 Thread Steve Edmonds

I am using openSUSE with KDE. The printing was was working fine under 
Leap 15.4 before I screwed the HD then after a fresh install of Leap 
15.5 it's not.

Probably something simple but I haven't taken the time to delve into it.

On 10/04/2024 00:56, Franck Henry wrote:

bonjour Steve

which kind of Linux desktop are you using ? have you tried with 
another one ?

i'm not using Fedora anymore
i better like MX with Xfce but without printer

Le lun. 8 avr. 2024 à 23:31, Steve Edmonds 
 a écrit :

It's not much help, but I get a similar thing in openSUSE 15.5.
(on my
laptop, wifi connected - my desktop wired Ethernet is fine). In my
case
it is the Brother MFC (network connected) that doesn't show on the
laptop.
Are your printers connected USB or Ethernet? I suspect it is an OS
thing.

On 03/04/2024 11:34, Eric Beversluis wrote:
> This doesn't seem to be an answer (it's not an absence of scroll
> bars--the printer is just not listed). The scroll bars are there
once
> I touch base with the Printer page in Settings and then go back
to LO.
>
> I'm not happy with "it is what it is." It seems rather to be a
bug in
> how the print dialogue works. Either something in Fedora 39 or
in this
> version of LO. (7.6.6.7 (x86_64). It doesn't happen, e.g., with
> Document Viewer or Text Editor, which suggests it's something in LO.
>
>
> On 4/2/24 13:58, Paul D. Mirowsky wrote:
>> I have not noticed scroll bars on certain occasion that block
other
>> printers from being seen.
>>
>> I drive myself crazy, but it is what it is.
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

<mailto:users%2bunsubscr...@global.libreoffice.org>
Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:
https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

Re: [libreoffice-users] Printer not showing in LO print dialog

2024-04-08 Thread Steve Edmonds

It's not much help, but I get a similar thing in openSUSE 15.5. (on my 
laptop, wifi connected - my desktop wired Ethernet is fine). In my case 
it is the Brother MFC (network connected) that doesn't show on the laptop.

Are your printers connected USB or Ethernet? I suspect it is an OS thing.

On 03/04/2024 11:34, Eric Beversluis wrote:
This doesn't seem to be an answer (it's not an absence of scroll 
bars--the printer is just not listed). The scroll bars are there once 
I touch base with the Printer page in Settings and then go back to LO.


I'm not happy with "it is what it is." It seems rather to be a bug in 
how the print dialogue works. Either something in Fedora 39 or in this 
version of LO. (7.6.6.7 (x86_64). It doesn't happen, e.g., with 
Document Viewer or Text Editor, which suggests it's something in LO.



On 4/2/24 13:58, Paul D. Mirowsky wrote:
I have not noticed scroll bars on certain occasion that block other 
printers from being seen.


I drive myself crazy, but it is what it is. 





--
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] V. 7.6.4.1 - header won't print

2024-01-24 Thread Steve Edmonds


If you export as PDF, does the PDF show the header and print OK?

On 25/01/2024 00:27, lo.harald.ber...@t-online.de wrote:

Hi,

> borderless.

Check your printer manual to see how far from the edge the printer can 
print.

Many printers have restrictions for the outer margin.
If your header is in the non-printable area, the printer will not be 
able to print it.


Regards

Am 24.01.2024 um 05:19 schrieb Troid:

the header will no longer print regardless of checking header , footer
in the print settings.choosing 8.5" x 11.5"  as the document size,
borderless.

print preview shows the entire page , including the header text. it just
  WON'T print it the header text.

wasting so much ink trying to print to see if the header will show up!





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

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

2023-10-25 Thread Steve Edmonds

If it is a short document, it is easy to use your phone with an app to 
convert the text.

Steve

On 26/10/2023 05:55, Kenneth Groninga wrote:

How do I scan a text document and save it and then later open it and edit
it?

Kenneth Groninga




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

Re: [libreoffice-users] MailMerge Bug Report

2023-10-23 Thread Steve Edmonds

No, I thought I would just ask the question while I considered the 
feasibility of contributing by confirming the bug.

And yes, 200+ addresses is quite feasible.

On 24/10/2023 08:59, Dave Howorth wrote:

On Tue, 24 Oct 2023 08:22:17 +1300
Steve Edmonds  wrote:


Hi. What do you call a large list.

Did you look at the bug report?


On 24/10/2023 06:40, Reinhard Klapproth wrote:

Hi,

I've reported a bug on bugzilla concerning Libreoffice Writer
MailMerge on Oct. 10:

https://bugs.documentfoundation.org/show_bug.cgi?id=157691

MailMerge ist bloating pdf files when mailing to a large list of
recipients. No one has yet confirmed the bug. That might be
difficult, because the error only occurs when mailing to a large
list. Has anyone an idea what can be done about the bug?

Reinhard
  







--
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] MailMerge Bug Report

2023-10-23 Thread Steve Edmonds


Hi. What do you call a large list.

On 24/10/2023 06:40, Reinhard Klapproth wrote:

Hi,

I've reported a bug on bugzilla concerning Libreoffice Writer 
MailMerge on Oct. 10:


https://bugs.documentfoundation.org/show_bug.cgi?id=157691

MailMerge ist bloating pdf files when mailing to a large list of 
recipients. No one has yet confirmed the bug. That might be difficult, 
because the error only occurs when mailing to a large list. Has anyone 
an idea what can be done about the bug?


Reinhard




--
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] Fwd: opening documents

2023-10-20 Thread Steve Edmonds

Generally you would search for file associations in your settings and 
set to open the document type with the extension in LibreOffice writer.

On 21/10/2023 10:02, Kenneth Groninga wrote:

-- Forwarded message -
From: Kenneth Groninga 
Date: Fri, Oct 20, 2023 at 10:14 AM
Subject: opening documents
To: 

When I open a document and chose to open in Libre Office Writer it opens in
Libre Office Draw instead. Why is that and how can I change it so the
document opens in Libre Office Writer?

Kenneth Groninga

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

Re: [libreoffice-users] Address Book Conundrum

2023-09-11 Thread Steve Edmonds

Did you install 7.6.0.3 from the LO website DL page. Base is a separate 
component in the openSuse repositories with an optional install.


On 12/09/2023 06:57, Paul D. Mirowsky wrote:
I confirm that Base was _always_ installed with the rest of the suite 
for me.


Do you have LibreOffice Start Center with your installation?

On 9/11/23 13:45, Robert Großkopf wrote:

Hi Peter,

Am 10.09.23 um 13:07 schrieb Peter Hillier-Brook:
For donkey's years I've been using an address book created from a 
calc spreadsheet, assigned via the Address Data Source Wizard. In a 
freshly installed version of LibreOffice (7.6.0.3) it's no longer 
available as it requires the "base" component that is not present.


It has required Base also in the past, but many people didn't 
recognize this. You connect from Writer thruogh Base to Calc.


Why isn't Base available for your installation. I never git an 
installation without Base component (OpenSUSE 64bit rpm Linux here).


Regards

Robert



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

[libreoffice-users] Nabble forum is being deprecated for LibreOffice

2023-09-04 Thread Steve Edmonds


A reference here that may need removing.
https://sid.libreoffice.org/get-help/nabble/

Steve

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

Re: [libreoffice-users] can anybody hear??

2023-09-04 Thread Steve Edmonds

This has happened for me for a long time using Thunderbird and IMAP 
connection with gmail accounts.
If you want to really check you can look at the list archives. (link 
added by the list server).


On 05/09/2023 01:29, Alif "al1r4d" Radhitya Wardana wrote:

Seems like everything is normal. I can see your message.

On September 3, 2023 9:31:59 PM GMT+07:00, t jackson  
wrote:

Messages I submit to users@global.libreoffice.org do not come back to me as a 
subscriber, and so I assume nobody else sees them either.

This is just a test to see if perchance that blockage has been cleared since my 
last try.

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

—
Alif "al1r4d" Radhitya Wardana (radhitya.org)

Sent from my Android device with K-9 Mail. Please excuse my brevity.



--
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: (unresolved) Re: [libreoffice-users] weirdness in save dialogue box

2023-08-24 Thread Steve Edmonds

Years. I have had this issue for years. I had no response from this list 
and thought it must be an "improvement" and don't think I filed a bug as 
I just got used to working with it.


On 24/08/2023 20:44, Mike Scott wrote:

On 14/08/2023 12:11, Mike Scott wrote:

On 12/08/2023 19:19, Steve Edmonds wrote:

Hi, you could file a bug and post the number here.


156765

.


And there it has sat for 10 days, and remains unassigned and un-updated.

Oh well. Nice idea though. What's the usual timescale for someone to 
at least say it's not going to be addressed?







--
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] alter appearnce hypertext

2023-08-20 Thread Steve Edmonds


I have just stuck with TB 102.

On 20/08/23 08:13, Lois Shumaker wrote:

Any recommendations for a different email client to run with Windows 10?

On 8/19/2023 9:49 AM, DaveB wrote:

On 19/08/2023 17:34, Brad Rogers wrote:

On Sat, 19 Aug 2023 15:59:11 +
DaveB  wrote:

Hello DaveB,


See attached ODT document

*All* attachments get stripped on this ML.

Yes Brad I am aware of that and have been for many years. I had 
intended to send the email off-list to Martin, but the new 
Thunderbird is such a screw up it didn't indicate it was also sending 
to the list as well. Pity Mozilla have destroyed a great email client.









--
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: (unresolved) Re: [libreoffice-users] weirdness in save dialogue box

2023-08-12 Thread Steve Edmonds


Hi, you could file a bug and post the number here.
Since I have had these issues for a few years now I have adjusted to 
them, and working on Linux the file extension doesn't even seem 
necessary so I just have to remember to add it if forwarding the file to 
someone else.


On 11/08/23 02:13, Mike Scott wrote:
OK, I see this thread's died out, so I assume there's no-one with a 
magical cure. I guess I'll have to persuade my wife that LO's own 
dialogue's are the way to go, although I confess I dislike them myself 
intensely.  It won't put me off LO :-}


But thanks to all for commenting.





--
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] weirdness in save dialogue box

2023-08-01 Thread Steve Edmonds




On 02/08/2023 00:50, Mike Scott wrote:

On 01/08/2023 10:32, Steve Edmonds wrote:

Are the goings on with LO 7.5.5.2 from the LO website using the OS 
native file dialogue and the goings on stop when using the LO file 
dialogue. If so it would point to a bug in LO.




OS native fails; AFAICT the LO-peculiar dialogues work OK. Does look 
like an LO issue; but how come lots of others aren't seeing the same, 
and how come it's so seemingly random?


(Not that I'm changing which I use: sorry, but the LO dialogue boxes I 
find confusingly different.)


I posed a question a few weeks ago about "Save As" not having a 
suggested file name in the "Name" field, I had no replies possibly 
because no one else saw this incorrect behaviour. I see issues in KDE 
Dolphin, are you seeing the issues in MATE Caja. Has the issue been 
observed in Gnome Nautilus.


--
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] weirdness in save dialogue box

2023-08-01 Thread Steve Edmonds




On 1/08/23 21:08, Mike Scott wrote:

On 01/08/2023 00:53, Peter Hillier-Brook wrote:

sudo dpkg -iR /Downloads/

I don't see that as any harder than using the system package manager 
and repositories.





Hmmm. My reply from an hour or so ago doesn't seem to have made it 
through the list. But it's superseded anyway.


I've pulled out a spare machine and checked that it too was failing 
(LO 7.3.5.2 from the ub repo running on Mint Mate 21)


I've installed LO 7.5.5.2 from the LO website, which to my relief 
installed alongside the older version.


7.5.5.2 shows exactly the same symptoms. So whatever is going on is 
nothing to do with the ubuntu packaging.



Are the goings on with LO 7.5.5.2 from the LO website using the OS 
native file dialogue and the goings on stop when using the LO file 
dialogue. If so it would point to a bug in LO.


--
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] weirdness in save dialogue box

2023-07-31 Thread Steve Edmonds

I was thinking also to try direct from the LO site, it is just so much 
easier to install/remove upgrade/downgrade using the system package 
manager and repositories.


On 31/07/2023 22:56, Peter Hillier-Brook wrote:

Mike,

It seems that you have not yet installed directly from the LibreOffice 
download site. Many years ago, when I still thought Ubuntu was a 
viable option for me, I had problems with their variant of 
LibreOffice. Installing the real thing eliminated the problems.


Best wishes.

Peter HB

On 31/07/2023 09:14, Mike Scott wrote:

On 30/07/2023 21:17, Steve Edmonds wrote:
.


I just switched from the KDE file manager (Dolphin) to the LO file 
load/save dialogues, there is definitely an issue with LO when using 
Dolphin that is not evident with other apps using Dolphin.

Philip, are you using LO from their site or an Ubuntu packaged version.


Mike, you say both machines are Mint, MATE or Xfce? Did you install 
from a PPA or the LO website.


Mint Mate; versions 21 and (iirc) 20.2 on the lappy.

LO is installed from the relevant ubuntu PPA. This machine (mint 21) 
says (synaptic) 1:7.3.7-0ubuntu0.22.0.4.3, but I think the other 
machine is on LO 6.something (IMBW) from the ub PPA. They have the 
same issue.


I do find the unpredictability rather concerning. I've just had to 
hunt for a "failing" file, but did find one. 'Save As' consistently 
(well, for the moment anyway!) adds the file extension in the 
dialogue. I switched to LO style dialogue boxes, and they behave as 
expected (file name given, no extension) - switching back to system 
style dialogues restores the wrong behaviour.


BTW, of two files -- an original plus a copy made with Caja (^C and 
^V) -- they consistently (for now) behave in the two different ways.


Thanks all for more comments. I hesitate to raise a bug report over 
this; for one thing the LO web bug page I found last time pretty 
incomprehensible, but for another it's really not repeatable enough. 
I'm not really sure where to go from here.









--
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] weirdness in save dialogue box

2023-07-30 Thread Steve Edmonds




On 31/07/2023 08:44, Philip Jackson wrote:

On 30/07/2023 22:17, Steve Edmonds wrote:



On 31/07/2023 01:09, Philip Jackson wrote:

On 29/07/2023 20:07, Steve Edmonds wrote:



On 29/07/23 19:32, Mike Scott wrote:

On 25/07/2023 21:17, Steve Edmonds wrote:



On 25/07/2023 22:17, Mike Scott wrote:

On 24/07/2023 17:39, Paul D. Mirowsky wrote:
Just out of curiosity, at any time did you receive a "Confirm 
File Format" window and unchecked the "Ask when not saving in 
ODF or default format" dialog?


An error in this function might react oddly, even though unlikely.


The "Confirm File Format" window only (and always) pops up when 
a non-odf format is picked from the drop-down box in the 'Save 
As' dialogue. "Ask when not saving in ODF..." is set in the LO 
options and re-appears (set) in the "Confirm format" window.


The odd thing today is that on this machine at least, I can't 
provoke the erroneous behaviour... I must have just clicked 
"Save As" 30 or more times, and all works perfectly. Would fail 
regularly when I last posted. The machine has just been rebooted 
though... surely that can't affect things!


Thanks to you and to all for comments.


Yesterday I observed the behaviour you described, just once, 
first time in a few years since the bug saving with file names 
containing multiple '.'s (i.e. API12.578.PT100SB.odt) was fixed. 
This time also I had a file name suggested in the "Save As" Name 
field, no extension showing, file type .odt selected and LO saved 
the file without any extension.

I couldn't repeat it. I have no idea what logic is involved.



Hmm the gremlins persist - my last email seems not to have made it 
to the list.


First, in answer to a query, the dialogue box style is set to 
system not LO's own. But as, today, I can't provoke the behaviour 
at all, I can't say whether the choice of style affects matters.


And the text of my last email, telling of a very odd thing, was as 
follows (apologies if anyone's already seen this):


===

Thanks for the comment; similar I guess.

The craziest thing today though. Having tried and failed to make 
my desktop fail again, I've just tried my rather slower laptop. 
The dialogue box briefly flashed up something I couldn't make out, 
so I set a screen recorder running. Serious weirdness is evident.


When I do the 'Save As', the dialogue box comes up. At one point 
as I step through frame-by-frame, the main area (the panel with a 
list of file names on disk) is empty, and the save as file name 
box at the top contains the highlighted file name, no type.


At the next frame, the main area is populated, and the filename 
box now contains the name plus highlighted type - which is the bad 
behaviour I have noted.


I should add, it took a couple of tries to get it to happen.

I can't imagine what's going on internally to do this. And 
seemingly randomly at that.


Maybe the gremlins are getting restless? :}

===

If it happens again, try the LO file dialogue. I had do do this a 
while back for a period where the KDE dialogue was acting badly 
under LO.


The last two responses (Mike and Steve) mentioned dialogs - system 
and LO. That was something I hadn't considered so I just checked 
what I'm using.


In my UbuntuStudio LTS 2204 with KDE Plasma desktop, I'm using every 
day LO's own dialog boxes. Not thro a specific choice but because it 
never occurred to me to do otherwise. And as I've said in a couple 
of posts to this thread, I've never experienced the OP's issue 
although 'save as' is part of my daily routine.


So I just changed the setting - I deselected the use LO open/save 
dialogs and then tried a 'save as'. The suggested filename was then 
complete with the odt suffix.  I re-selected the LO open/save 
dialogs and tried again - the suggested filename was without the odt 
suffix.  So it seems that using system dialogs does play a part in 
this affair.  And my distro now uses the KDE desktop whereas for 
years it was XFCE.


I just switched from the KDE file manager (Dolphin) to the LO file 
load/save dialogues, there is definitely an issue with LO when using 
Dolphin that is not evident with other apps using Dolphin.

Philip, are you using LO from their site or an Ubuntu packaged version.
Mike, you say both machines are Mint, MATE or Xfce? Did you install 
from a PPA or the LO website.


It's over a year since I upgraded to UbuntuStudio LTS 2204 and I don't 
recall whether I just stuck with the distro version of LO or 
downloaded from the LO site - I've done both over the years. When I 
check "which libreoffice" it returns /usr/bin/libreoffice so I imagine 
I'm using the distro supplied version otherwise it would be in /opt/ 
wouldn't it?


I don't have any trouble with opening Write

Re: [libreoffice-users] weirdness in save dialogue box

2023-07-30 Thread Steve Edmonds




On 31/07/2023 01:09, Philip Jackson wrote:

On 29/07/2023 20:07, Steve Edmonds wrote:



On 29/07/23 19:32, Mike Scott wrote:

On 25/07/2023 21:17, Steve Edmonds wrote:



On 25/07/2023 22:17, Mike Scott wrote:

On 24/07/2023 17:39, Paul D. Mirowsky wrote:
Just out of curiosity, at any time did you receive a "Confirm 
File Format" window and unchecked the "Ask when not saving in ODF 
or default format" dialog?


An error in this function might react oddly, even though unlikely.


The "Confirm File Format" window only (and always) pops up when a 
non-odf format is picked from the drop-down box in the 'Save As' 
dialogue. "Ask when not saving in ODF..." is set in the LO options 
and re-appears (set) in the "Confirm format" window.


The odd thing today is that on this machine at least, I can't 
provoke the erroneous behaviour... I must have just clicked "Save 
As" 30 or more times, and all works perfectly. Would fail 
regularly when I last posted. The machine has just been rebooted 
though... surely that can't affect things!


Thanks to you and to all for comments.


Yesterday I observed the behaviour you described, just once, first 
time in a few years since the bug saving with file names containing 
multiple '.'s (i.e. API12.578.PT100SB.odt) was fixed. This time 
also I had a file name suggested in the "Save As" Name field, no 
extension showing, file type .odt selected and LO saved the file 
without any extension.

I couldn't repeat it. I have no idea what logic is involved.



Hmm the gremlins persist - my last email seems not to have made it 
to the list.


First, in answer to a query, the dialogue box style is set to system 
not LO's own. But as, today, I can't provoke the behaviour at all, I 
can't say whether the choice of style affects matters.


And the text of my last email, telling of a very odd thing, was as 
follows (apologies if anyone's already seen this):


===

Thanks for the comment; similar I guess.

The craziest thing today though. Having tried and failed to make my 
desktop fail again, I've just tried my rather slower laptop. The 
dialogue box briefly flashed up something I couldn't make out, so I 
set a screen recorder running. Serious weirdness is evident.


When I do the 'Save As', the dialogue box comes up. At one point as 
I step through frame-by-frame, the main area (the panel with a list 
of file names on disk) is empty, and the save as file name box at 
the top contains the highlighted file name, no type.


At the next frame, the main area is populated, and the filename box 
now contains the name plus highlighted type - which is the bad 
behaviour I have noted.


I should add, it took a couple of tries to get it to happen.

I can't imagine what's going on internally to do this. And seemingly 
randomly at that.


Maybe the gremlins are getting restless? :}

===

If it happens again, try the LO file dialogue. I had do do this a 
while back for a period where the KDE dialogue was acting badly under 
LO.


The last two responses (Mike and Steve) mentioned dialogs - system and 
LO. That was something I hadn't considered so I just checked what I'm 
using.


In my UbuntuStudio LTS 2204 with KDE Plasma desktop, I'm using every 
day LO's own dialog boxes. Not thro a specific choice but because it 
never occurred to me to do otherwise. And as I've said in a couple of 
posts to this thread, I've never experienced the OP's issue although 
'save as' is part of my daily routine.


So I just changed the setting - I deselected the use LO open/save 
dialogs and then tried a 'save as'. The suggested filename was then 
complete with the odt suffix.  I re-selected the LO open/save dialogs 
and tried again - the suggested filename was without the odt suffix.  
So it seems that using system dialogs does play a part in this 
affair.  And my distro now uses the KDE desktop whereas for years it 
was XFCE.


I just switched from the KDE file manager (Dolphin) to the LO file 
load/save dialogues, there is definitely an issue with LO when using 
Dolphin that is not evident with other apps using Dolphin.

Philip, are you using LO from their site or an Ubuntu packaged version.
Mike, you say both machines are Mint, MATE or Xfce? Did you install from 
a PPA or the LO website.


--
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] weirdness in save dialogue box

2023-07-29 Thread Steve Edmonds




On 29/07/23 19:32, Mike Scott wrote:

On 25/07/2023 21:17, Steve Edmonds wrote:



On 25/07/2023 22:17, Mike Scott wrote:

On 24/07/2023 17:39, Paul D. Mirowsky wrote:
Just out of curiosity, at any time did you receive a "Confirm File 
Format" window and unchecked the "Ask when not saving in ODF or 
default format" dialog?


An error in this function might react oddly, even though unlikely.


The "Confirm File Format" window only (and always) pops up when a 
non-odf format is picked from the drop-down box in the 'Save As' 
dialogue. "Ask when not saving in ODF..." is set in the LO options 
and re-appears (set) in the "Confirm format" window.


The odd thing today is that on this machine at least, I can't 
provoke the erroneous behaviour... I must have just clicked "Save 
As" 30 or more times, and all works perfectly. Would fail regularly 
when I last posted. The machine has just been rebooted though... 
surely that can't affect things!


Thanks to you and to all for comments.


Yesterday I observed the behaviour you described, just once, first 
time in a few years since the bug saving with file names containing 
multiple '.'s (i.e. API12.578.PT100SB.odt) was fixed. This time also 
I had a file name suggested in the "Save As" Name field, no extension 
showing, file type .odt selected and LO saved the file without any 
extension.

I couldn't repeat it. I have no idea what logic is involved.



Hmm the gremlins persist - my last email seems not to have made it to 
the list.


First, in answer to a query, the dialogue box style is set to system 
not LO's own. But as, today, I can't provoke the behaviour at all, I 
can't say whether the choice of style affects matters.


And the text of my last email, telling of a very odd thing, was as 
follows (apologies if anyone's already seen this):


===

Thanks for the comment; similar I guess.

The craziest thing today though. Having tried and failed to make my 
desktop fail again, I've just tried my rather slower laptop. The 
dialogue box briefly flashed up something I couldn't make out, so I 
set a screen recorder running. Serious weirdness is evident.


When I do the 'Save As', the dialogue box comes up. At one point as I 
step through frame-by-frame, the main area (the panel with a list of 
file names on disk) is empty, and the save as file name box at the top 
contains the highlighted file name, no type.


At the next frame, the main area is populated, and the filename box 
now contains the name plus highlighted type - which is the bad 
behaviour I have noted.


I should add, it took a couple of tries to get it to happen.

I can't imagine what's going on internally to do this. And seemingly 
randomly at that.


Maybe the gremlins are getting restless? :}

===

If it happens again, try the LO file dialogue. I had do do this a while 
back for a period where the KDE dialogue was acting badly under LO.


--
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] LOW - Auto-wrap text in cells - how to remove empty line?

2023-07-27 Thread Steve Edmonds


Hi Budge.
I assumed this is a cell in Calc and not a writer table.
Right click the row number and select "Optimal height"

On 28/07/2023 07:48, Budge wrote:
I have been using automatic wrapping of text when entering lines in a 
cell.  This automatically increases the number of text lines in the 
cell when line is too long to fit.  All good so far and this also adds 
text lines in all columns in the same line so the sheet looks fine.


My problem is that in editing and then re-editing text in a cell so 
that at one point there are three lines of text and then I edit and 
only two lines are needed, there is no automatic reduction of the 
empty line so I am left with a three line text box with only two lines 
of text and an empty line.


How do I remove the empty line so that all the cells in the line only 
have the required two lines?

Budge.




--
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] Is anyone using Libreoffice SYNCHED to Google drive or One drive or Soho Drive or similar online / cloud drives ?

2023-07-26 Thread Steve Edmonds

I am not sure of your meaning, can you confirm that you are meaning that 
when Tools>Options>Load/Save "Always create a backup copy" is checked 
you can set Tools>Options>General>Paths "Backups" to a web drive to 
automatically save backups to that location or are you meaning you wish 
to automatically save a duplicate to a web drive when you save a document.


On 26/07/2023 16:09, Hastham S wrote:

dear allGood day
Is anyone using Libreoffice SYNCHED to Google drive or One drive or Soho Drive 
or similar online / cloud drives ?When I save a Libre office sheet, that should 
be auto saved to Google drive or One Drive ..or ...I am NOT talking of backup 
end of day or end of hourI am talking of cloud drive
Pls helpPls pointTIA
regardsSubu




--
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] My files disappear

2023-07-25 Thread Steve Edmonds


Hi Linda, what version of Libreoffice do you have and what operating system.
Can you see the files in your file manager (not through Libreoffice), if 
you click (double click) on the file does it open in Libreoffice.
If you create a new document in Libreoffice and save it, can you then 
see it in your file manager?


On 26/07/2023 07:36, Linda Rutenberg wrote:

Hi Thanks for your help.. when I go to retrieve files that i have written a 
couple of days earlier, they always say that they do not exist.. I see them 
when I go to recent documents but they are not there..
I deleted the application and reinstalled it but i have the same issue..
Why??
Thanks
Linda






--
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] weirdness in save dialogue box

2023-07-25 Thread Steve Edmonds




On 25/07/2023 22:17, Mike Scott wrote:

On 24/07/2023 17:39, Paul D. Mirowsky wrote:
Just out of curiosity, at any time did you receive a "Confirm File 
Format" window and unchecked the "Ask when not saving in ODF or 
default format" dialog?


An error in this function might react oddly, even though unlikely.


The "Confirm File Format" window only (and always) pops up when a 
non-odf format is picked from the drop-down box in the 'Save As' 
dialogue. "Ask when not saving in ODF..." is set in the LO options and 
re-appears (set) in the "Confirm format" window.


The odd thing today is that on this machine at least, I can't provoke 
the erroneous behaviour... I must have just clicked "Save As" 30 or 
more times, and all works perfectly. Would fail regularly when I last 
posted. The machine has just been rebooted though... surely that can't 
affect things!


Thanks to you and to all for comments.


Yesterday I observed the behaviour you described, just once, first time 
in a few years since the bug saving with file names containing multiple 
'.'s (i.e. API12.578.PT100SB.odt) was fixed. This time also I had a file 
name suggested in the "Save As" Name field, no extension showing, file 
type .odt selected and LO saved the file without any extension.

I couldn't repeat it. I have no idea what logic is involved.

--
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] Copy/past a table changes following paragraph style

2023-07-23 Thread Steve Edmonds


Hi Harald.
Hopefully you can download a document created from scratch here
https://drive.google.com/file/d/1SFA7STG_5rSg435gZTZ_mhWoz5XMqO_d/view?usp=sharing

The procedure described in the document is a little different from my 
first description but replication of the bug seems more consistent. In 
my original document inserting above a blank line is not always required 
and the change of style can occur before or after the inserted table.

Steve


On 23/07/2023 08:45, lo.harald.ber...@t-online.de wrote:

Hi Steve,
I think you can assume that your description is not a normal 
obsolescence.
I tested it on my end and the table can be inserted without another 
blank line or changed paragraph style.
You can also test this yourself with a new fresh file, short 
paragraphs and a minimal table.
However, it will be a bit difficult to find out what the problem is in 
your described file.
From experience I know that the end of a paragraph can cause a 
different style to appear for the rest of the text.

This is a mess that usually cannot be tracked well.
A control character could have been inserted by mistake, text from 
other sources could have been inserted,
an already contaminated document template could have been used or 
other things.
You will only be able to solve the problem if you rebuild the document 
and insert the existing text as unformatted text and then use only 
styles.
If you want, you can also upload a sample file (1-2 pages with the 
problem) somewhere in the cloud and post the link on the list so 
someone can look at it and examine it.


Kind regards
Harald

Am 20.07.2023 um 01:36 schrieb Steve Edmonds:

I have an arrangement on a page; (LO 7.5.4.2)

text in paragraph style A
text in paragraph style A
table (containing paragraph style B)
text in paragraph style A
text in paragraph style A

If I highlight the table (little arrow top left), copy and then paste 
the table, say between the 2 lower style A paragraphs above, a blank 
line is inserted below the table but in Default Paragraph Style which 
I always have to change back to style A.


If I copy a portion including text before and after the table, as in;

aph style A
table (containing paragraph style B)
tex

And paste it between the 2 lower style A paragraphs then the text 
"aph style A" changes to Default Paragraph Style.


If I copy a portion including the full paragraph before and some text 
after the table, as in;


text in paragraph style A
table (containing paragraph style B)
tex

And paste it between the 2 lower style A paragraphs then no change to 
Default Paragraph Style  occurs and styles remain as desired.


Can I assume this variable change to Default Paragraph Style is not 
the desired functionality? 





--
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] weirdness in save dialogue box

2023-07-22 Thread Steve Edmonds




On 23/07/23 04:42, Philip Jackson wrote:

On 22/07/2023 11:02, Mike Scott wrote:

On 20/07/2023 00:14, Steve Edmonds wrote:

Does this still happen if you update to LO7.4?
If I open yyy.odt, and  click 'Save As' the field "Name" for file 
name is always blank.


On 19/07/2023 05:38, Philip Jackson wrote:

Hi :

I'm using 7.3.7.2 on UbuntuStudio and I'm always using 'save as' 
but I've never had the problem you describe. Sorry.


Philip

On 18/07/2023 16:13, Mike Scott wrote:
Hi all; a very weird issue has been found by my wife, which I can 
repeat on a separate machine. Both use LO 7.3.7.2 on Mint 21.


What happens is this. Take an odt file, open it in Writer then go 
to 'Save As'. The expected behaviour is that the filename in the 
dialogue box will be filled in and selected/highlighted and 
there'll be no file type appended. Eg, I open yyy.odt, and 'Save 
As' displays just 'yyy' (highlighted).


However, sometimes and for no apparent reason, the dialogue box 
instead displays filename and file type ('yyy.odt'), with the type 
(only) highlighted. This causes issues when trying to save as a 
different type (eg as .docx)


(TLDR: open question at end! The details of my testing results are 
too long; sorry.)



Thanks all for comments, including one off-list. Ap[ologies for not 
getting back sooner - family matters intervened.


To clarify, my made-up name yyy.odt was (previously) by way of 
indicating what happens, not that that was the literal file causing 
problems. Apologies for any mis-direction.


I'm still none the wiser as to what's happening. I've just checked 
again the environment for the files. I have a file in a directory 
/dhome/mike, and an identical copy (^C ^V in a file manager) in 
/dhome/mike/temp of a file called

Saturday  song sheet.odt
(yes - there are two spaces together there, but that's not the issue)

I close LO. Double-click on the one in the temp directory, head for 
File|Save As. The filename is filled in

Saturday  song sheet
and selected. No file type.

So, I close LO. Double-click on the one in the higher directory; 
again File|Save As. This time, the file name and type appear;

Saturday  song sheet.odt
the /type/ alone is selected.

I cannot for the life of me understand why the behaviour in the two 
cases should be different.


To add to my confusion, I've just tried the following sequence of 
operations, starting with the "failing" file in /dhome/mike:


make a copy and change name:
cp Saturday\ \ song\ sheet.odt yyy.odt
open yyy.odt and see that Save As prefills the file name box as 
"yyy.odt" with the odt selected.


Rename and do the same again:
mv yyy.odt yy.odt
Same issue - Save As shows the name and type.

Finally, do it again:
mv yy.odt y.odt
But now y.odt opens the same, but Save As simply shows a highlighted 
"y" in the file name box.


Oh, and if I rename y.odt back to yy.odt, the problem comes back. 
And, if I copy yy.odt (fails) to my temp directory, all is well with 
the copy.


The thing is, when trying to save as .doc having the file type 
pre-set in the box causes a problem - LO will try to save a .doc (or 
whatever) as the type shown, and it needs manually changing. That's 
hazardous for someone like my wife, and can potentially lose the 
original .odt file.


I've just tried a similar sequence with the same file in my "real" 
home directory (/home/mike) with identical results.



**?
Does LO perhaps treat "top-level" directories in some way specially? 
My current guess is that multi-character file names in a "top-level" 
directory are treated differently from others. That would be very odd 
though, so IMBW!



Thanks for reading. I find this sort of problem hard to describe 
concisely. Am I missing something obvious?



Hi Mike,
I've tried to replicate your series of moves listed in your latest 
email. I even started with a file of the same name, Saturday  song 
list.odt, and used mv and cp as close as I could following your 
sequence. In every case, when I came to 'save as' in LO Writer 7.3.7.2 
in UbuntuStudio 2022LTS, only the file name without extension was 
shown in the 'file name' box. I tried saving into the ~/ directory and 
into other lower levels.


I have been unable to replicate your case where the file name and its 
extension are given in the 'save as' | 'file name box'.


I'm commonly working on Writer docs three and four levels down from 
the home directory and 'save as' is one of my most common ways of 
duplicating a file to provide a starter in a new directory. I've never 
seen the behavior you describe.


This doesn't help you, I'm afraid. Could it be something connected 
with your OS version? I can't exactly recall if my LO is the 
UbuntuStudio distribution version or wh

[libreoffice-users] Copy/past a table changes following paragraph style

2023-07-19 Thread Steve Edmonds


I have an arrangement on a page; (LO 7.5.4.2)

text in paragraph style A
text in paragraph style A
table (containing paragraph style B)
text in paragraph style A
text in paragraph style A

If I highlight the table (little arrow top left), copy and then paste 
the table, say between the 2 lower style A paragraphs above, a blank 
line is inserted below the table but in Default Paragraph Style which I 
always have to change back to style A.


If I copy a portion including text before and after the table, as in;

aph style A
table (containing paragraph style B)
tex

And paste it between the 2 lower style A paragraphs then the text "aph 
style A" changes to Default Paragraph Style.


If I copy a portion including the full paragraph before and some text 
after the table, as in;


text in paragraph style A
table (containing paragraph style B)
tex

And paste it between the 2 lower style A paragraphs then no change to 
Default Paragraph Style  occurs and styles remain as desired.


Can I assume this variable change to Default Paragraph Style is not the 
desired functionality?




--
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] weirdness in save dialogue box

2023-07-19 Thread Steve Edmonds


Does this still happen if you update to LO7.4?
If I open yyy.odt, and  click 'Save As' the field "Name" for file name 
is always blank.


On 19/07/2023 05:38, Philip Jackson wrote:

Hi :

I'm using 7.3.7.2 on UbuntuStudio and I'm always using 'save as' but 
I've never had the problem you describe. Sorry.


Philip

On 18/07/2023 16:13, Mike Scott wrote:
Hi all; a very weird issue has been found by my wife, which I can 
repeat on a separate machine. Both use LO 7.3.7.2 on Mint 21.


What happens is this. Take an odt file, open it in Writer then go to 
'Save As'. The expected behaviour is that the filename in the 
dialogue box will be filled in and selected/highlighted and there'll 
be no file type appended. Eg, I open yyy.odt, and 'Save As' displays 
just 'yyy' (highlighted).


However, sometimes and for no apparent reason, the dialogue box 
instead displays filename and file type ('yyy.odt'), with the type 
(only) highlighted. This causes issues when trying to save as a 
different type (eg as .docx)


Even more odd is that simply copying  (^C, ^V in a file manager) a 
wrongly-behaving file to a different directory can change the behaviour.


I wondered if my wife had managed to include some weird character, but
the filename /looks/ kosher: 'ls -1 | od -cb' shows nothing untoward. 
And indeed, one or two of my own files show the same behaviour. (I 
rarely use 'Save As' anyway.)



I'm at a bit of a loss about where to check next. Has anyone else 
experienced this please and can say what's happening?


TIA.







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

Brad is doing better than me, may be include the link to be sure we are 
on the same page, so to speak.

steve

On 7/07/23 03:15, Budge wrote:
I have downloaded a document from the VistitBritain/VisitEngland 
website which is in which is in a Windows 2007 .docx format.
When I open the document it LibreOffice Writer it opens to show 7 
pages all at once and showing in the same window.


How may I break this down into individual pages within the document 
please so I may work on each page and then page down?


Hope somebody can help me with this as I have never seen this format 
before!

Budge




--
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 fields to time fields

2023-06-28 Thread Steve Edmonds

It depends how you want the sheet to function. If you use Edit>Find and 
Replace... find a.m. replace with AM, find p.m. replace with PM it 
automatically converts.


On 29/06/2023 08:31, James wrote:

I have text fields like:

10:06:59 a.m.
8:57:36 p.m.

How do I convert them to 24-hour time fields?



--
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] Ubuntu messed up LO!

2023-06-28 Thread Steve Edmonds

I decided many years ago to stick with my distributions (SUSE) packaging 
of LO, not for the ease of installation but for the ease of uninstalling 
and rollback (a 2 minute job) when I encountered an issue in LO that 
interrupted my work flow and then roll forward again when the issue was 
resolved.


On 27/06/2023 15:10, James wrote:

I would stick to the ubuntu one unless there is a bug you need fixed.
Then try to upgrade.

https://www.debugpoint.com/libreoffice-upgrade-update-latest/

I wonder if it can run from a usb flash drive.




--
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] problems with border menu

2023-06-23 Thread Steve Edmonds




On 21/06/23 10:54, James wrote:

The borders menu is hard to read.
1. The shadow lines up the top and left of each box look like an 
actual border.
2. Is the setting of the selected cell highlighted because I can't see 
anything.


I uploaded a screenshot here:
https://www.mediafire.com/view/d8h07ti16gnbpt8/borders.jpg/file
I have seen these as quick presets. The dark line of the boarder is 
clear to me in the images and I don't find the shadow confusing. I don't 
understand the meaning of the dashed boarder as no boarders is clearly 
no boarders.


The setting of a selected cell is best seen in Format>cells, Boarders 
tab, as boarders could be more complex than in the quick presets.


--
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] Image Anchor Selection

2023-06-14 Thread Steve Edmonds




On 15/06/23 09:15, T. R. Valentine wrote:

On Wed, 14 Jun 2023 at 15:53, Steve Edmonds  wrote:


older documents. Anchoring to page is a valuable choice for me, what I
would really like is an option to choose the anchor point and for it to
remain unchanged by what ever algorithm moves the anchor point from one
location to another, frequently jumping from inside a table to some
other paragraph on the page.
May be something like "Lock Anchor".

Understandable. What I would really like is an option to make
anchor-to-page the **default** in LO Writer.

May be when inserting, being presented with the options for anchoring. 
The default seems to be to character but I rarely anchor that way.


--
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] Image Anchor Selection

2023-06-14 Thread Steve Edmonds

I have found anchoring of images and objects the most frustrating thing 
in LO, some changes to LO have meant having to re-anchor all images in 
older documents. Anchoring to page is a valuable choice for me, what I 
would really like is an option to choose the anchor point and for it to 
remain unchanged by what ever algorithm moves the anchor point from one 
location to another, frequently jumping from inside a table to some 
other paragraph on the page.

May be something like "Lock Anchor".
Steve

On 14/06/23 04:59, Dave Howorth wrote:

On Tue, 13 Jun 2023 12:58:07 +
"W. Robert J. Funnell, Prof."  wrote:


Mike -

That's not a bad idea, but it might be messy to implement. An easier
alternative would be to just change 'To page' to 'To page
(deprecated)' or 'To page (avoid using)'.

Easier yes but a lot less helpful. It doesn't help anybody understand
why the change was made nor how to find the 'deprecated' facility which
will continue to exist in fact.


- Robert

From: Mike Scott 
Sent: June 12, 2023 12:05
To: users@global.libreoffice.org 
Subject: Re: [libreoffice-users] Image Anchor Selection

A thought in passing - it would seem the OP's issue is that the UI has
changed, but he had no (ready) way of knowing in what way. In this
case a context menu item has been moved to the depths of a dialogue
box.

Might it be a good idea, when this is done, to leave the original menu
entry in place, but have it just show an information box saying where
the item can be found and maybe give a pointer to [a web page with]
some hints on the matter? And leave that in place for several
releases.







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

Re: [libreoffice-users] Office doesn't handle its own graphics?

2023-03-20 Thread Steve Edmonds




On 21/03/2023 00:36, Gavin Stokes wrote:

On Tue, Mar 14, 2023 at 11:49 PM Robert Großkopf 
wrote:


A draw document could contain many pages. On every page will be
shapes/images.


Thanks, Robert. I didn't know there could be multiple pages in a Draw
document. However, you can insert multi-page PDFs as images, so I wonder if
they could be handled similarly.

Anyway, I'll just have to go with SVGs and re-export every time. Oh wait...
there appears to be a bug in Writer that causes it to export Draw-generated
SVGs as blank when you render a document that contains them as a PDF.
Meanwhile, it renders embedded SVGs from Sketch just fine.

I guess Writer really has something against Draw!

I just did a quick test and a simple SVG exported from Draw, inserted 
into Writer, rendered fine. LO 7.4.3.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] Function acting on range

2023-03-18 Thread Steve Edmonds

I was meaning that if I have 10 sheets, I can refer to them by position 
1 to 10 rather than by name.
=SHEET($Sheet19.B28) returns 29. I was wondering if I could refer to 
this cell something like ='29'.B28


On 18/03/2023 22:20, ady wrote:
If by "sheets by position" you mean things like "the next one, 
whichever the next worksheet would be", you can. I don't know whether 
you actually need this feature – please allow me to doubt it – but 
there is such a thing in LibreOffice Calc.



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

Re: [libreoffice-users] Function acting on range

2023-03-17 Thread Steve Edmonds

On 17/03/2023 13:08, Michael D. Setzer II wrote:

On 16 Mar 2023 at 23:29, Regina Henschel wrote:

Subject:Re: [libreoffice-users] Function acting on
range
To: users@global.libreoffice.org
From:   Regina Henschel

Date sent:  Thu, 16 Mar 2023 23:29:10 +0100

Hi Michael,

Michael D. Setzer II schrieb am 16.03.2023 um 22:45:

On 16 Mar 2023 at 18:22, ady wrote:

From:ady 
Date sent:Thu, 16 Mar 2023 18:22:56 -0300
Subject:Re: [libreoffice-users] Function acting on
range
To:Users 

Hi Regina,

But you can use {=AVERAGE({ABS($Sheet1.B1:$Sheet1.B30)} for example.

Besides the typo, for that to work it would need to be all in the same
worksheet, which is contrary to the initial setup.

ISTM that using SUM() and COUNT() would be simpler, if the data is
already with the layout as described, in multiple sheets.

Don't see how just using SUM() and COUNT() would
work.

Sum() and Count() work an ranges which include several sheets. So if you
did not need Abs(), then Sum()/Count() would give the average.

Therefore the problem here is, that Steve needs the Abs() function, for
what ever reason.

Unfortunately Sumif() does neither work on ranges over several sheets.
So the solution
(Sumif(myRange;">0")-Sumif(myRange;"<0")/Count(myRange) will not work,
if myRange goes over several sheets.

Interesting. Don't know why sum() and count() have no
problem handling cells across sheets but sumif() doesn't?
Just did my test using cells on single sheet and it had no
problem, but then did try it with using b2 on sheet1 thru
sheet6, and get error. Do a lot of things with calc, but
not things like that.

In my test, seems one would have to individually do each
cell. In my case I did 6, but his would require 19??
Actually 29 sheets. I couldn't find a way to address sheets by position 
rather than name. The first sheet is 1, the last 19 and the ones in the 
middle have various names.

=AVERAGE(ABS(Sheet1.B2),ABS(Sheet2.B2),ABS(Sheet
3.B2),ABS(Sheet4.B2),ABS(Sheet5.B2),ABS(Sheet6.B2))

Don't have quick access to see if its SUMIF would
support ranges. Have used spreadsheets going back to
visicalc on Apple, Lotus 1 on PC then thru version of
Lotus, Quattro Pro, and then Open and Libre Calc.

Wonder why the Sumif doesn't use similar base as sum?

Thanks for info.

Inside one sheet there is no problem with abs or sumif using ranges.

Kind regards,
Regina

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

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

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

Re: [libreoffice-users] Function acting on range

2023-03-16 Thread Steve Edmonds

Thanks very much for the help. I will flag using the AVERAGE and ABS and 
can adequately gain a feel for the data I need with the STDEVP function.
I had recently been using some R style vector arithmetic and wondered if 
similar could be achieved using ranges in LO.

Steve

On 17/03/2023 11:29, Regina Henschel wrote:

Hi Michael,

Michael D. Setzer II schrieb am 16.03.2023 um 22:45:

On 16 Mar 2023 at 18:22, ady wrote:


From:ady 
Date sent:Thu, 16 Mar 2023 18:22:56 -0300
Subject:Re: [libreoffice-users] Function acting on
range
To:Users 



Hi Regina,


But you can use {=AVERAGE({ABS($Sheet1.B1:$Sheet1.B30)} for example.


Besides the typo, for that to work it would need to be all in the same
worksheet, which is contrary to the initial setup.

ISTM that using SUM() and COUNT() would be simpler, if the data is
already with the layout as described, in multiple sheets.



Don't see how just using SUM() and COUNT() would
work.


Sum() and Count() work an ranges which include several sheets. So if 
you did not need Abs(), then Sum()/Count() would give the average.


Therefore the problem here is, that Steve needs the Abs() function, 
for what ever reason.


Unfortunately Sumif() does neither work on ranges over several sheets. 
So the solution
(Sumif(myRange;">0")-Sumif(myRange;"<0")/Count(myRange) will not work, 
if myRange goes over several sheets.


Inside one sheet there is no problem with abs or sumif using ranges.

Kind regards,
Regina




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

Re: [libreoffice-users] Function acting on range

2023-03-16 Thread Steve Edmonds




On 16/03/2023 23:12, Regina Henschel wrote:

Hi Steve,

Steve Edmonds schrieb am 16.03.2023 um 01:13:
Hi, on the off chance I will be pleasantly surprised, can a function 
act on a range.


i.e can I do something like =AVERAGE(ABS($Sheet1.B28:$Sheet19.B28)) 
to average the absolute value of the numbers in the range.
The above seems to return only the last value of the range. I can 
achieve this with an intermediate column on every sheet.


Enter it as array-function. That is using "Ctrl-Shift-Enter" instead 
of "Enter" or mark the "Array" checkbox in the Function Wizard.


Kind regards,
Regina


Thanks.
Do you mean like {=AVERAGE(ABS($Sheet1.B30:$Sheet19.B30) )} as this 
gives a 504 error and =AVERAGE({ABS($Sheet1.B30:$Sheet19.B30)} ) and 
{=AVERAGE({ABS($Sheet1.B30:$Sheet19.B30)} )} both give a 539 error.


--
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] Function acting on range

2023-03-15 Thread Steve Edmonds

Hi, on the off chance I will be pleasantly surprised, can a function act 
on a range.


i.e can I do something like =AVERAGE(ABS($Sheet1.B28:$Sheet19.B28)) to 
average the absolute value of the numbers in the range.
The above seems to return only the last value of the range. I can 
achieve this with an intermediate column on every sheet.

Steve

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

Re: [libreoffice-users] Rotating labels to landscape

2023-02-17 Thread Steve Edmonds


Are you inserting data into fields or is it just text and may be an image.
If the latter you can keep the page portrait and just rotate the 
text/image 90 degrees. To rotate the text put it in a text box and 
rotate the box.

Steve

On 12/02/2023 15: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.

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


\\||/
Rod



--
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 formatting but in calc.

2023-02-07 Thread Steve Edmonds




On 08/02/2023 05:45, Johnny Rosenberg wrote:

Den tis 7 feb. 2023 kl 01:35 skrev Steve Edmonds 
:
I am observing what may be a bug in saving a formula in a cell where
additional spaces are repeatably inserted on editing the formula.
If someone could replicate this I will file a bug.

Create a sheet with cell contents as below.

A3 is =IF((F22=$B$21) AND (G22<>$B$21),10,20)


I didn't even know you can use AND like that. I always write like:
=IF(AND(F22=$B$21;G22<>$B$21);10;20)

I was programming before spreadsheets existed and blindly used the same 
simple construct as basic in the spreadsheet and that worked so kept 
using it.

&& didn't work but would be nice if it did.
Also what is nice is that (F22=$B$21) will evaluate to 0 or 1 when used 
in an equation. (F22=$B$21)*5 is the equivalent of if(F22=$B$21,5,0)

Steve

Kind regards

Johnny Rosenberg



You will notice one space before and after the AND;
Click into the cell and edit the formula changing =IF((F22... to
=IF((F21 and hit ENTER.
Click into the formula again, are there now 2 spaces before the and?

Every edit I get an additional space added before the AND.

If there is no space after the AND (=IF((F22=$B$21)
AND(G22<>$B$21),10,20)) this does not occur.

Steve



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




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

[libreoffice-users] Possible formatting but in calc.

2023-02-06 Thread Steve Edmonds

I am observing what may be a bug in saving a formula in a cell where 
additional spaces are repeatably inserted on editing the formula.

If someone could replicate this I will file a bug.

Create a sheet with cell contents as below.

A3 is =IF((F22=$B$21) AND (G22<>$B$21),10,20)

You will notice one space before and after the AND;
Click into the cell and edit the formula changing =IF((F22... to 
=IF((F21 and hit ENTER.

Click into the formula again, are there now 2 spaces before the and?

Every edit I get an additional space added before the AND.

If there is no space after the AND (=IF((F22=$B$21) 
AND(G22<>$B$21),10,20)) this does not occur.


Steve



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

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

2023-02-03 Thread Steve Edmonds

I am not sure if this will be of any help as I use SUSE with YAST and 
zypper, but it looks like dnf/yum may have similar functionality.
Using downloaded (not from a repository) RPMs that will undergo regular 
updates I create a local repository from a directory containing the RPMs.
My system treats 7.3 and 7.4 as 2 different packages, I would have 2 
different local repositories.
To go from 7.3 to 7.4 I would mark 7.3 to uninstall and 7.4 to install 
and mostly the dependency checking allows resolution of any issues.

To go from 7.3.1 to 7.3.2 say would be seen as an upgrade.

This means it is easy to swap back from say 7.4 to 7.3 if you strike a 
bug that is a show stopper for you while you wait for the bug 
resolution, as I have had on a few occasions.

Steve

On 04/02/2023 01:28, Michael D. Setzer II wrote:

On 3 Feb 2023 at 17:20, Lee Thomas Stephen wrote:

From:   Lee Thomas Stephen

Date sent:  Fri, 3 Feb 2023 17:20:15 +0530
Subject:Re: [libreoffice-users] RPM upgrade 7.4 to
7.5
To: msetze...@gmail.com
Copies to:  LibreOffice Users



I did

rpm -Uvh *.rpm

Now I have both 7.4 and 7.5.
The command installed a separate 7.5 instead of upgrading from 7.4.
Any solution for an upgrade?
As I face this issue on every major release.

dnf update will eventually update the libreoffice that is
in the Fedora/Redhat repos when they are updated.

As I understand it, you would need to download and
repeat process to update libreoffice versions.

I use a little script after downloading the lastest update
and help gz files.

newlib=$(ls -1 LibreOffice_$1*.gz |tail -n 1 | cut -f1,2 -d_)
mkdir $newlib
cd $newlib/
for a in ../$newlib*.gz ; do tar xvf $a ; done
for a in $(find . | grep "\.rpm") ; do mv $a .; done
rpm -Uvh *.rpm
tar -Jcvf ../$newlib.xz *.rpm
rm l*.rpm -f
rm LibreOffice_$1* -R -f
cd ..
rmdir $newlib

If you have installed the help, the upgrade gives an error
if the new help files are not installed at same time. If you
just install without help, you can just do the rpm update.
I like to create an archive of rpms to then copy to other
machines..

So make example is what I use, but you may want to do
something different.




Thanks

---
Lee

On Fri, Feb 3, 2023 at 3:53 PM Michael D. Setzer II 
wrote:


On 3 Feb 2023 at 12:20, Lee Thomas Stephen wrote:

From:   Lee Thomas Stephen

Date sent:  Fri, 3 Feb 2023 12:20:02 +0530
Subject:[libreoffice-users] RPM upgrade 7.4 to 7.5
To: LibreOffice Users



Hi,

I have LibreOffice 7.4.5 installed via RPM installation on RHEL 8.7
I downloaded the RPM installation of LibreOffice 7.5.0.
but I am unable to do
dnf upgrade *.rpm

Think rpm -Uvh *.rpm
Is what you want to use.
The Libreoffice from the site installs differently than the
one from the Fedora repos for me.

which libreoffice libreoffice7.4
/usr/bin/libreoffice
/usr/bin/libreoffice7.4

The office submenu then list both the repo version and
the libreoffice versions of programs.

Haven't tried the 7.5 yet.


The error is
-%<-
Package libobasis7.5-base not installed, cannot update it.
No match for argument: libobasis7.5-base-7.5.0.3-3.x86_64.rpm
Package libobasis7.5-calc not installed, cannot update it.
No match for argument: libobasis7.5-calc-7.5.0.3-3.x86_64.rpm
Package libobasis7.5-core not installed, cannot update it.
No match for argument: libobasis7.5-core-7.5.0.3-3.x86_64.rpm
Package libobasis7.5-draw not installed, cannot update it.
..
etc.
-%<-

So what is the correct path to upgrade from 7.4 to 7.5?

Thanks

---
Lee

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


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





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


++
  Michael D. Setzer II - Computer Science Instructor
(Retired)
  mailto:mi...@guam.net
  mailto:msetze...@gmail.com
  Guam - Where America's Day Begins
  G4L Disk Imaging Project maint

Re: [libreoffice-users] Problem with grouping in writer

2023-02-02 Thread Steve Edmonds


What version of LO and OS?
I just did this fine in 7.3.6.2
Just checking, did you click the arrow at the far left of the drawing 
tools first.

Steve

On 03/02/2023 16:03, John R. Sowden wrote:
Trying to "group lines and rectangles into 1 image, then copy it to 
another  location on the page.  . Per help I am supposed to press 
shift, then click on each item  on each object (line, etc.) then go to 
the next step.  I am unable to get the lines, etc. to add to the other 
items to create an i,age, like the inst say.


Help?

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

2023-01-08 Thread Steve Edmonds


OK, found the sheet.
Had to copy it from the machine I used the sheet on last month as can't 
access physically the machine ATM.
The sheet was working fine on that machine but produces the symptoms you 
mention on this laptop. I will see if I can find the cause.

Steve

On 4/01/23 8:51 am, Steve Edmonds wrote:
I understand what you are seeing, I had the same issue with a macro 
for a function, I called it money() for rounding financial tax 
calculations appropriately. At some point when I updated LO it just 
stopped calculating displaying as you describe and I had to go through 
the same rigmarole you are experiencing for it to recalculate.
Not sure if I resolved the issue or gave up, I will need to dig the 
sheet out.

Steve

On 3/01/23 11:13 am, Michael Tiernan wrote:

On 12/23/22 11:02 AM, Andrew Pitonyak wrote:

If you are looking to cause functions to recalculate,


Thanks for the reply.

Here's the thing. It's not that I want to force a recalculate, it's 
that I have to in order to get the macros to respond.


Here's an example: (What I expect when the spreadsheet finishes 
opening.)


/*Cell*//*
*/ /*Contents*//*
*/ /*Display*//*
*/
D1
192.168.17.231/24
192.168.17.231/24
D2
=ipwithoutmask(D1)
192.168.17.231
D3
=ipmask(D1)
255.255.255.0
D4
=ipmasklken(D3)
24

Now, when I actually do open the spreadsheet, it says:

/*Cell*//*
*/ /*Contents*//*
*/ /*Display*//*
*/
D1
192.168.17.231/24
192.168.17.231/24
D2
=ipwithoutmask(D1)
#NAME?
D3
=ipmask(D1)
#NAME?
D4
=ipmasklken(D3)
#NAME?

So, if I say it differently, it *seems* like the Macros aren't run 
when the spreadsheet is opened.


The macro library has a "Main" entry that is empty. If I choose 
"Tools" -> "Macros" -> "Run macro" and then select "Main" and execute 
it, there's no visible change.


BUT, if I go into the contents of "D2" and add a space at the end of 
the formula "=ipwithoutmask(D1)" to read "=ipwithoutmask(D1) " and 
hit return and the macro executes and displays the proper value.


HOWEVER, none of the other cells change so I have to go into each one 
and do the same sort of thing, add a space at the end of the line or 
between the macro and the parenthesis, each time, hit return and it 
works properly.


This is obviously not the correct way it should work.

Hence my query about "starting" macros when the document is opened.

So, that leads to, am *I* doing something wrong?

Thanks for everyone's time.






--
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: SPAM Re: [libreoffice-users] Macros in spreadsheets

2023-01-04 Thread Steve Edmonds

That happens to me with some list emails, easiest solution is to add a 
rule to prevent classing as spam.

Steve

On 5/01/23 5:36 am, Tim-L wrote:


Your mail list emails are now being marked as spam.  Why, I cannot 
find out.




On 1/3/23 14:51, Steve Edmonds wrote:
I understand what you are seeing, I had the same issue with a macro 
for a function, I called it money() for rounding financial tax 
calculations appropriately. At some point when I updated LO it just 
stopped calculating displaying as you describe and I had to go 
through the same rigmarole you are experiencing for it to recalculate.
Not sure if I resolved the issue or gave up, I will need to dig the 
sheet out.

Steve

On 3/01/23 11:13 am, Michael Tiernan wrote:

On 12/23/22 11:02 AM, Andrew Pitonyak wrote:

If you are looking to cause functions to recalculate,


Thanks for the reply.

Here's the thing. It's not that I want to force a recalculate, it's 
that I have to in order to get the macros to respond.


Here's an example: (What I expect when the spreadsheet finishes 
opening.)


/*Cell*//*
*/ /*Contents*//*
*/ /*Display*//*
*/
D1
192.168.17.231/24
192.168.17.231/24
D2
=ipwithoutmask(D1)
192.168.17.231
D3
=ipmask(D1)
255.255.255.0
D4
=ipmasklken(D3)
24

Now, when I actually do open the spreadsheet, it says:

/*Cell*//*
*/ /*Contents*//*
*/ /*Display*//*
*/
D1
192.168.17.231/24
192.168.17.231/24
D2
=ipwithoutmask(D1)
#NAME?
D3
=ipmask(D1)
#NAME?
D4
=ipmasklken(D3)
#NAME?

So, if I say it differently, it *seems* like the Macros aren't run 
when the spreadsheet is opened.


The macro library has a "Main" entry that is empty. If I choose 
"Tools" -> "Macros" -> "Run macro" and then select "Main" and 
execute it, there's no visible change.


BUT, if I go into the contents of "D2" and add a space at the end of 
the formula "=ipwithoutmask(D1)" to read "=ipwithoutmask(D1) " and 
hit return and the macro executes and displays the proper value.


HOWEVER, none of the other cells change so I have to go into each 
one and do the same sort of thing, add a space at the end of the 
line or between the macro and the parenthesis, each time, hit return 
and it works properly.


This is obviously not the correct way it should work.

Hence my query about "starting" macros when the document is opened.

So, that leads to, am *I* doing something wrong?

Thanks for everyone's time.









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

Re: [libreoffice-users] Macros in spreadsheets

2023-01-03 Thread Steve Edmonds

I understand what you are seeing, I had the same issue with a macro for 
a function, I called it money() for rounding financial tax calculations 
appropriately. At some point when I updated LO it just stopped 
calculating displaying as you describe and I had to go through the same 
rigmarole you are experiencing for it to recalculate.
Not sure if I resolved the issue or gave up, I will need to dig the 
sheet out.

Steve

On 3/01/23 11:13 am, Michael Tiernan wrote:

On 12/23/22 11:02 AM, Andrew Pitonyak wrote:

If you are looking to cause functions to recalculate,


Thanks for the reply.

Here's the thing. It's not that I want to force a recalculate, it's 
that I have to in order to get the macros to respond.


Here's an example: (What I expect when the spreadsheet finishes opening.)

/*Cell*//*
*/ /*Contents*//*
*/ /*Display*//*
*/
D1
192.168.17.231/24
192.168.17.231/24
D2
=ipwithoutmask(D1)
192.168.17.231
D3
=ipmask(D1)
255.255.255.0
D4
=ipmasklken(D3)
24

Now, when I actually do open the spreadsheet, it says:

/*Cell*//*
*/ /*Contents*//*
*/ /*Display*//*
*/
D1
192.168.17.231/24
192.168.17.231/24
D2
=ipwithoutmask(D1)
#NAME?
D3
=ipmask(D1)
#NAME?
D4
=ipmasklken(D3)
#NAME?

So, if I say it differently, it *seems* like the Macros aren't run 
when the spreadsheet is opened.


The macro library has a "Main" entry that is empty. If I choose 
"Tools" -> "Macros" -> "Run macro" and then select "Main" and execute 
it, there's no visible change.


BUT, if I go into the contents of "D2" and add a space at the end of 
the formula "=ipwithoutmask(D1)" to read "=ipwithoutmask(D1) " and hit 
return and the macro executes and displays the proper value.


HOWEVER, none of the other cells change so I have to go into each one 
and do the same sort of thing, add a space at the end of the line or 
between the macro and the parenthesis, each time, hit return and it 
works properly.


This is obviously not the correct way it should work.

Hence my query about "starting" macros when the document is opened.

So, that leads to, am *I* doing something wrong?

Thanks for everyone's time.




--
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] "Match case" greyed out

2022-10-30 Thread Steve Edmonds

On 31/10/2022 07:41, Steve Edmonds wrote:

On 31/10/2022 07:10, Steve Edmonds wrote:

On 31/10/2022 03:55, Johnny Rosenberg wrote:
Den sön 30 okt. 2022 kl 02:13 skrev Steve Edmonds 
:

On 30/10/2022 10:22, Johnny Rosenberg wrote:
> Den lör 29 okt. 2022 kl 22:48 skrev Steve Edmonds <
> steve.edmo...@ptglobal.com>:
>
>>
>> On 29/10/2022 12:12, Steve Edmonds wrote:
>>>
>>> On 29/10/22 10:39 am, Johnny Rosenberg wrote:
>>>> Den fre 28 okt. 2022 kl 22:20 skrev Steve Edmonds <
>>>> steve.edmo...@ptglobal.com>:
>>>>
>>>>> Further to this, if I customise the Edit menu and remove
the Find
>>>>> command, I cannot add it back in as it does not appear in
the list of
>>>>> commands. A reset will see Find back in the edit menu.
>>>>>
>>>> That's probably a bug. I don't know if anyone reported it,
but I guess
>>>> someone should.
>>> I will check to see if present also on Linux and file a bug.
I could
>>> not locate an existing bug for this.
>> On Linux, I do not seem to loose the ctl-F shortcut to the
find tool bar.
>>
> The problem is that when you intentionally REMOVE the shortcut
for Ctrl+f
> (Tools → Customization) you can't get it back, since Search is
nowhere to
> find. If you can find it, please tell us where, so we also can
find it. I
> run Linux (exclusively) and I can not find it.
>
On my Linux machine (assuming Tools>Customise is the same as
View>Toolbars>Customise)

It is.

I can remove the shortcut Ctrl+f or change it
to something else and then delete it but Ctrl+f still activates
the find
tool bar.

I just tested that and it doesn't work. Ctrl+f does nothing efter 
removing it and reset won't bring it back once I left the Customize 
dialogue. Fortunately I saved my settings before this test, so I 
could bring it back by reading it back in.

I'm on Ubuntu Studio 20.04 (Xfce), LibreOffice 7.3.6.2.

Did you set this with ”LibreOffice” or ”Writer” checked in the upper 
right corner on the customize dialogue? When ”Writer is checked”, 
Ctrl+f is empty, when ”LibreOffice” is selected, Ctrl+f is linked to 
Find (or Search or whatever it's called in the English version).

As though it is hard coded.

Doesn't seem to be on my system, at least.

It is worse than I thought.
As the OP was using Calc, I was testing with Calc set in upper right. 
On my OpenSUSE 15.4 using SUSE repository version of LO Calc 
(7.3.6.2) always goes to the Find dialogue with ctl-F unset or reset.
However now trying Writer (and LibreOffice in upper right) this is 
not the case. As you state above removing it and reset won't bring it 
back. During the process I set ctl-F = "About LibreOffice" and now 
this persists in writer after removing it or resetting even though 
Calc is fine. On the upside I have a handy shortcut if I ever want to 
check my version of LO whilst in Writer

And I find now that Reset doesn't reset the shortcut keys to the default.

Filed bug https://bugs.documentfoundation.org/show_bug.cgi?id=151832
and added to Meta https://bugs.documentfoundation.org/show_bug.cgi?id=98259

On my Mac it cannot be restored
without a reset.
steve

>
>
>
>>> Also the fact that cmd-F does not work and cannot be added
to keyboard
>>> shortcuts because there is no Find function.
    >>>> Before customizing, you can save your current settings, and
then
>>>> (hopefully) bring them back if something goes wrong. Maybe
worth to
>>>> consider next time. :)
>>>>
>>>>
>>>> Kind regards
>>>>
>>>> Johnny Rosenberg
>>>>
>>>>
>>>>> On 29/10/22 8:42 am, Steve Edmonds wrote:
>>>>>> Hi again.
>>>>>> I am now wondering if the find dialogue is deprecated in
7.3.6. I
>>>>>> cannot find it explained in the help.
>>>>>> When you run the mouse over the find field at the bottom
of the window
>>>>>> the pop up tip states "Find text in values, to search in
formulas use
>>>>>> the dialog" which may be leading me astray.
>>>>>>
>>>>>> You can use the find/replace dialogue with a number of
search options,
>>>>>> are the options you see not working in the find dialogue
also not
>>>>>> available in the find/replace dialogue.

Re: [libreoffice-users] "Match case" greyed out

2022-10-30 Thread Steve Edmonds

On 31/10/2022 07:10, Steve Edmonds wrote:

On 31/10/2022 03:55, Johnny Rosenberg wrote:
Den sön 30 okt. 2022 kl 02:13 skrev Steve Edmonds 
:

On 30/10/2022 10:22, Johnny Rosenberg wrote:
> Den lör 29 okt. 2022 kl 22:48 skrev Steve Edmonds <
> steve.edmo...@ptglobal.com>:
>
>>
>> On 29/10/2022 12:12, Steve Edmonds wrote:
>>>
>>> On 29/10/22 10:39 am, Johnny Rosenberg wrote:
>>>> Den fre 28 okt. 2022 kl 22:20 skrev Steve Edmonds <
>>>> steve.edmo...@ptglobal.com>:
>>>>
>>>>> Further to this, if I customise the Edit menu and remove
the Find
>>>>> command, I cannot add it back in as it does not appear in
the list of
>>>>> commands. A reset will see Find back in the edit menu.
>>>>>
>>>> That's probably a bug. I don't know if anyone reported it,
but I guess
>>>> someone should.
>>> I will check to see if present also on Linux and file a bug.
I could
>>> not locate an existing bug for this.
>> On Linux, I do not seem to loose the ctl-F shortcut to the
find tool bar.
>>
> The problem is that when you intentionally REMOVE the shortcut
for Ctrl+f
> (Tools → Customization) you can't get it back, since Search is
nowhere to
> find. If you can find it, please tell us where, so we also can
find it. I
> run Linux (exclusively) and I can not find it.
>
On my Linux machine (assuming Tools>Customise is the same as
View>Toolbars>Customise)

It is.

I can remove the shortcut Ctrl+f or change it
to something else and then delete it but Ctrl+f still activates
the find
tool bar.

I just tested that and it doesn't work. Ctrl+f does nothing efter 
removing it and reset won't bring it back once I left the Customize 
dialogue. Fortunately I saved my settings before this test, so I 
could bring it back by reading it back in.

I'm on Ubuntu Studio 20.04 (Xfce), LibreOffice 7.3.6.2.

Did you set this with ”LibreOffice” or ”Writer” checked in the upper 
right corner on the customize dialogue? When ”Writer is checked”, 
Ctrl+f is empty, when ”LibreOffice” is selected, Ctrl+f is linked to 
Find (or Search or whatever it's called in the English version).

As though it is hard coded.

Doesn't seem to be on my system, at least.

It is worse than I thought.
As the OP was using Calc, I was testing with Calc set in upper right. 
On my OpenSUSE 15.4 using SUSE repository version of LO Calc (7.3.6.2) 
always goes to the Find dialogue with ctl-F unset or reset.
However now trying Writer (and LibreOffice in upper right) this is not 
the case. As you state above removing it and reset won't bring it 
back. During the process I set ctl-F = "About LibreOffice" and now 
this persists in writer after removing it or resetting even though 
Calc is fine. On the upside I have a handy shortcut if I ever want to 
check my version of LO whilst in Writer

And I find now that Reset doesn't reset the shortcut keys to the default.

On my Mac it cannot be restored
without a reset.
steve

>
>
>
>>> Also the fact that cmd-F does not work and cannot be added to
keyboard
>>> shortcuts because there is no Find function.
>>>> Before customizing, you can save your current settings, and then
>>>> (hopefully) bring them back if something goes wrong. Maybe
worth to
>>>> consider next time. :)
>>>>
>>>>
>>>> Kind regards
>>>>
>>>> Johnny Rosenberg
>>>>
>>>>
>>>>> On 29/10/22 8:42 am, Steve Edmonds wrote:
>>>>>> Hi again.
>>>>>> I am now wondering if the find dialogue is deprecated in
7.3.6. I
>>>>>> cannot find it explained in the help.
>>>>>> When you run the mouse over the find field at the bottom
of the window
>>>>>> the pop up tip states "Find text in values, to search in
formulas use
>>>>>> the dialog" which may be leading me astray.
>>>>>>
>>>>>> You can use the find/replace dialogue with a number of
search options,
>>>>>> are the options you see not working in the find dialogue
also not
>>>>>> available in the find/replace dialogue.
>>>>>>
>>>>>> If I close the find tool bar at the bottom of the window,
Edit>Find
>>>>>> will open it again, no Fi

Re: [libreoffice-users] "Match case" greyed out

2022-10-30 Thread Steve Edmonds

On 31/10/2022 03:55, Johnny Rosenberg wrote:
Den sön 30 okt. 2022 kl 02:13 skrev Steve Edmonds 
:

On 30/10/2022 10:22, Johnny Rosenberg wrote:
> Den lör 29 okt. 2022 kl 22:48 skrev Steve Edmonds <
> steve.edmo...@ptglobal.com>:
>
>>
>> On 29/10/2022 12:12, Steve Edmonds wrote:
>>>
>>> On 29/10/22 10:39 am, Johnny Rosenberg wrote:
>>>> Den fre 28 okt. 2022 kl 22:20 skrev Steve Edmonds <
>>>> steve.edmo...@ptglobal.com>:
>>>>
>>>>> Further to this, if I customise the Edit menu and remove the
Find
>>>>> command, I cannot add it back in as it does not appear in
the list of
>>>>> commands. A reset will see Find back in the edit menu.
>>>>>
>>>> That's probably a bug. I don't know if anyone reported it,
but I guess
>>>> someone should.
>>> I will check to see if present also on Linux and file a bug. I
could
>>> not locate an existing bug for this.
>> On Linux, I do not seem to loose the ctl-F shortcut to the find
tool bar.
>>
> The problem is that when you intentionally REMOVE the shortcut
for Ctrl+f
> (Tools → Customization) you can't get it back, since Search is
nowhere to
> find. If you can find it, please tell us where, so we also can
find it. I
> run Linux (exclusively) and I can not find it.
>
On my Linux machine (assuming Tools>Customise is the same as
View>Toolbars>Customise)

It is.

I can remove the shortcut Ctrl+f or change it
to something else and then delete it but Ctrl+f still activates
the find
tool bar.

I just tested that and it doesn't work. Ctrl+f does nothing efter 
removing it and reset won't bring it back once I left the Customize 
dialogue. Fortunately I saved my settings before this test, so I could 
bring it back by reading it back in.

I'm on Ubuntu Studio 20.04 (Xfce), LibreOffice 7.3.6.2.

Did you set this with ”LibreOffice” or ”Writer” checked in the upper 
right corner on the customize dialogue? When ”Writer is checked”, 
Ctrl+f is empty, when ”LibreOffice” is selected, Ctrl+f is linked to 
Find (or Search or whatever it's called in the English version).

As though it is hard coded.

Doesn't seem to be on my system, at least.

It is worse than I thought.
As the OP was using Calc, I was testing with Calc set in upper right. On 
my OpenSUSE 15.4 using SUSE repository version of LO Calc (7.3.6.2) 
always goes to the Find dialogue with ctl-F unset or reset.
However now trying Writer (and LibreOffice in upper right) this is not 
the case. As you state above removing it and reset won't bring it back. 
During the process I set ctl-F = "About LibreOffice" and now this 
persists in writer after removing it or resetting even though Calc is 
fine. On the upside I have a handy shortcut if I ever want to check my 
version of LO whilst in Writer

On my Mac it cannot be restored
without a reset.
steve

>
>
>
>>> Also the fact that cmd-F does not work and cannot be added to
keyboard
>>> shortcuts because there is no Find function.
>>>> Before customizing, you can save your current settings, and then
>>>> (hopefully) bring them back if something goes wrong. Maybe
worth to
>>>> consider next time. :)
>>>>
>>>>
>>>> Kind regards
>>>>
>>>> Johnny Rosenberg
>>>>
>>>>
>>>>> On 29/10/22 8:42 am, Steve Edmonds wrote:
>>>>>> Hi again.
>>>>>> I am now wondering if the find dialogue is deprecated in
7.3.6. I
>>>>>> cannot find it explained in the help.
>>>>>> When you run the mouse over the find field at the bottom of
the window
>>>>>> the pop up tip states "Find text in values, to search in
formulas use
>>>>>> the dialog" which may be leading me astray.
>>>>>>
>>>>>> You can use the find/replace dialogue with a number of
search options,
>>>>>> are the options you see not working in the find dialogue
also not
>>>>>> available in the find/replace dialogue.
>>>>>>
>>>>>> If I close the find tool bar at the bottom of the window,
Edit>Find
>>>>>> will open it again, no Find dialogue.
>>>>>> Cmd F now opens another strange dialogue requesting search for
>>>>>> c

Re: [libreoffice-users] "Match case" greyed out

2022-10-29 Thread Steve Edmonds




On 30/10/2022 10:22, Johnny Rosenberg wrote:

Den lör 29 okt. 2022 kl 22:48 skrev Steve Edmonds <
steve.edmo...@ptglobal.com>:



On 29/10/2022 12:12, Steve Edmonds wrote:


On 29/10/22 10:39 am, Johnny Rosenberg wrote:

Den fre 28 okt. 2022 kl 22:20 skrev Steve Edmonds <
steve.edmo...@ptglobal.com>:


Further to this, if I customise the Edit menu and remove the Find
command, I cannot add it back in as it does not appear in the list of
commands. A reset will see Find back in the edit menu.


That's probably a bug. I don't know if anyone reported it, but I guess
someone should.

I will check to see if present also on Linux and file a bug. I could
not locate an existing bug for this.

On Linux, I do not seem to loose the ctl-F shortcut to the find tool bar.


The problem is that when you intentionally REMOVE the shortcut for Ctrl+f
(Tools → Customization) you can't get it back, since Search is nowhere to
find. If you can find it, please tell us where, so we also can find it. I
run Linux (exclusively) and I can not find it.

On my Linux machine (assuming Tools>Customise is the same as 
View>Toolbars>Customise) I can remove the shortcut Ctrl+f or change it 
to something else and then delete it but Ctrl+f still activates the find 
tool bar. As though it is hard coded. On my Mac it cannot be restored 
without a reset.

steve





Also the fact that cmd-F does not work and cannot be added to keyboard
shortcuts because there is no Find function.

Before customizing, you can save your current settings, and then
(hopefully) bring them back if something goes wrong. Maybe worth to
consider next time. :)


Kind regards

Johnny Rosenberg



On 29/10/22 8:42 am, Steve Edmonds wrote:

Hi again.
I am now wondering if the find dialogue is deprecated in 7.3.6. I
cannot find it explained in the help.
When you run the mouse over the find field at the bottom of the window
the pop up tip states "Find text in values, to search in formulas use
the dialog" which may be leading me astray.

You can use the find/replace dialogue with a number of search options,
are the options you see not working in the find dialogue also not
available in the find/replace dialogue.

If I close the find tool bar at the bottom of the window, Edit>Find
will open it again, no Find dialogue.
Cmd F now opens another strange dialogue requesting search for
command.

steve

On 27/10/22 10:49 pm, Thomas Blasejewicz wrote:

Good evening
I just came across something I do not understand (and so far could
not find being mentioned in the manuals etc.).
Using Windows 10, LibreOffice 7.1.8.1
I noticed in Calc that when I try to find something, in the find
dialog
* Match case = greyed out = not working
* Formatted display = OK
* Entire cells = greyed out = not working
* All sheets = OK

Now, why would these functions be disabled? I tried to find something
under tools, but so far without luck.
And I am quite sure I was able to search the data with Match case
checked.
I tried to reboot the computer. That did not change anything either.

1)Is there a reason for this behavior?
2)Is there a way to fix it?

Thank you
Thomas


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



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




--
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] "Match case" greyed out

2022-10-29 Thread Steve Edmonds




On 29/10/2022 12:12, Steve Edmonds wrote:



On 29/10/22 10:39 am, Johnny Rosenberg wrote:

Den fre 28 okt. 2022 kl 22:20 skrev Steve Edmonds <
steve.edmo...@ptglobal.com>:


Further to this, if I customise the Edit menu and remove the Find
command, I cannot add it back in as it does not appear in the list of
commands. A reset will see Find back in the edit menu.


That's probably a bug. I don't know if anyone reported it, but I guess
someone should.
I will check to see if present also on Linux and file a bug. I could 
not locate an existing bug for this.

On Linux, I do not seem to loose the ctl-F shortcut to the find tool bar.
Also the fact that cmd-F does not work and cannot be added to keyboard 
shortcuts because there is no Find function.


Before customizing, you can save your current settings, and then
(hopefully) bring them back if something goes wrong. Maybe worth to
consider next time. :)


Kind regards

Johnny Rosenberg



On 29/10/22 8:42 am, Steve Edmonds wrote:

Hi again.
I am now wondering if the find dialogue is deprecated in 7.3.6. I
cannot find it explained in the help.
When you run the mouse over the find field at the bottom of the window
the pop up tip states "Find text in values, to search in formulas use
the dialog" which may be leading me astray.

You can use the find/replace dialogue with a number of search options,
are the options you see not working in the find dialogue also not
available in the find/replace dialogue.

If I close the find tool bar at the bottom of the window, Edit>Find
will open it again, no Find dialogue.
Cmd F now opens another strange dialogue requesting search for 
command.


steve

On 27/10/22 10:49 pm, Thomas Blasejewicz wrote:

Good evening
I just came across something I do not understand (and so far could
not find being mentioned in the manuals etc.).
Using Windows 10, LibreOffice 7.1.8.1
I noticed in Calc that when I try to find something, in the find 
dialog

* Match case = greyed out = not working
* Formatted display = OK
* Entire cells = greyed out = not working
* All sheets = OK

Now, why would these functions be disabled? I tried to find something
under tools, but so far without luck.
And I am quite sure I was able to search the data with Match case
checked.
I tried to reboot the computer. That did not change anything either.

1)    Is there a reason for this behavior?
2)    Is there a way to fix it?

Thank you
Thomas



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

List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy






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

Re: [libreoffice-users] "Match case" greyed out

2022-10-28 Thread Steve Edmonds




On 29/10/22 10:39 am, Johnny Rosenberg wrote:

Den fre 28 okt. 2022 kl 22:20 skrev Steve Edmonds <
steve.edmo...@ptglobal.com>:


Further to this, if I customise the Edit menu and remove the Find
command, I cannot add it back in as it does not appear in the list of
commands. A reset will see Find back in the edit menu.


That's probably a bug. I don't know if anyone reported it, but I guess
someone should.
I will check to see if present also on Linux and file a bug. I could not 
locate an existing bug for this.
Also the fact that cmd-F does not work and cannot be added to keyboard 
shortcuts because there is no Find function.


Before customizing, you can save your current settings, and then
(hopefully) bring them back if something goes wrong. Maybe worth to
consider next time. :)


Kind regards

Johnny Rosenberg



On 29/10/22 8:42 am, Steve Edmonds wrote:

Hi again.
I am now wondering if the find dialogue is deprecated in 7.3.6. I
cannot find it explained in the help.
When you run the mouse over the find field at the bottom of the window
the pop up tip states "Find text in values, to search in formulas use
the dialog" which may be leading me astray.

You can use the find/replace dialogue with a number of search options,
are the options you see not working in the find dialogue also not
available in the find/replace dialogue.

If I close the find tool bar at the bottom of the window, Edit>Find
will open it again, no Find dialogue.
Cmd F now opens another strange dialogue requesting search for command.

steve

On 27/10/22 10:49 pm, Thomas Blasejewicz wrote:

Good evening
I just came across something I do not understand (and so far could
not find being mentioned in the manuals etc.).
Using Windows 10, LibreOffice 7.1.8.1
I noticed in Calc that when I try to find something, in the find dialog
* Match case = greyed out = not working
* Formatted display = OK
* Entire cells = greyed out = not working
* All sheets = OK

Now, why would these functions be disabled? I tried to find something
under tools, but so far without luck.
And I am quite sure I was able to search the data with Match case
checked.
I tried to reboot the computer. That did not change anything either.

1)Is there a reason for this behavior?
2)Is there a way to fix it?

Thank you
Thomas



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




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

Re: [libreoffice-users] "Match case" greyed out

2022-10-28 Thread Steve Edmonds

Further to this, if I customise the Edit menu and remove the Find 
command, I cannot add it back in as it does not appear in the list of 
commands. A reset will see Find back in the edit menu.


On 29/10/22 8:42 am, Steve Edmonds wrote:

Hi again.
I am now wondering if the find dialogue is deprecated in 7.3.6. I 
cannot find it explained in the help.
When you run the mouse over the find field at the bottom of the window 
the pop up tip states "Find text in values, to search in formulas use 
the dialog" which may be leading me astray.


You can use the find/replace dialogue with a number of search options, 
are the options you see not working in the find dialogue also not 
available in the find/replace dialogue.


If I close the find tool bar at the bottom of the window, Edit>Find 
will open it again, no Find dialogue.

Cmd F now opens another strange dialogue requesting search for command.

steve

On 27/10/22 10:49 pm, Thomas Blasejewicz wrote:

Good evening
I just came across something I do not understand (and so far could 
not find being mentioned in the manuals etc.).

Using Windows 10, LibreOffice 7.1.8.1
I noticed in Calc that when I try to find something, in the find dialog
* Match case = greyed out = not working
* Formatted display = OK
* Entire cells = greyed out = not working
* All sheets = OK

Now, why would these functions be disabled? I tried to find something 
under tools, but so far without luck.
And I am quite sure I was able to search the data with Match case 
checked.

I tried to reboot the computer. That did not change anything either.

1)    Is there a reason for this behavior?
2)    Is there a way to fix it?

Thank you
Thomas






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

Re: [libreoffice-users] "Match case" greyed out

2022-10-28 Thread Steve Edmonds


Hi again.
I am now wondering if the find dialogue is deprecated in 7.3.6. I cannot 
find it explained in the help.
When you run the mouse over the find field at the bottom of the window 
the pop up tip states "Find text in values, to search in formulas use 
the dialog" which may be leading me astray.


You can use the find/replace dialogue with a number of search options, 
are the options you see not working in the find dialogue also not 
available in the find/replace dialogue.


If I close the find tool bar at the bottom of the window, Edit>Find will 
open it again, no Find dialogue.

Cmd F now opens another strange dialogue requesting search for command.

steve

On 27/10/22 10:49 pm, Thomas Blasejewicz wrote:

Good evening
I just came across something I do not understand (and so far could not 
find being mentioned in the manuals etc.).

Using Windows 10, LibreOffice 7.1.8.1
I noticed in Calc that when I try to find something, in the find dialog
* Match case = greyed out = not working
* Formatted display = OK
* Entire cells = greyed out = not working
* All sheets = OK

Now, why would these functions be disabled? I tried to find something 
under tools, but so far without luck.
And I am quite sure I was able to search the data with Match case 
checked.

I tried to reboot the computer. That did not change anything either.

1)    Is there a reason for this behavior?
2)    Is there a way to fix it?

Thank you
Thomas




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

Re: [libreoffice-users] "Match case" greyed out

2022-10-28 Thread Steve Edmonds


Hi.
I just updated my mac to version 7.3.6 from the download page and for me 
the Find dialogue does not open.
The quick find at the bottom of the window does have the option for 
formatted text.

Steve

On 27/10/22 10:49 pm, Thomas Blasejewicz wrote:

Good evening
I just came across something I do not understand (and so far could not 
find being mentioned in the manuals etc.).

Using Windows 10, LibreOffice 7.1.8.1
I noticed in Calc that when I try to find something, in the find dialog
* Match case = greyed out = not working
* Formatted display = OK
* Entire cells = greyed out = not working
* All sheets = OK

Now, why would these functions be disabled? I tried to find something 
under tools, but so far without luck.
And I am quite sure I was able to search the data with Match case 
checked.

I tried to reboot the computer. That did not change anything either.

1)    Is there a reason for this behavior?
2)    Is there a way to fix it?

Thank you
Thomas




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

Re: AW: [libreoffice-users] State of docx support.

2022-10-21 Thread Steve Edmonds


Hi Susanne.
This is an enrolment document for services from a local doctor.
To me it seems a crazy way to create the document, but seems valid for docx.
Sending direct as attachments are stripped by the list server.

Cheers, Steve

On 22/10/2022 01:07, susanne.mohn...@kiel-pries.de wrote:

Hi Steve,

normally docx opened in a few seconds in LO.

Try LO7.4. - there the support for DOCX is much better than in LO 7.3

Can you share the docx?

Greetings
Susanne

-Ursprüngliche Nachricht-
Von: Steve Edmonds 
Gesendet: Freitag, 21. Oktober 2022 00:03
An: LibreOffice User's Help Forum 
Betreff: [libreoffice-users] State of docx support.

Hi.
I have received a 2 page document (.docx) that takes about a minute to open in 
LO 7.3.6 and has some of the items somewhat misplaced (problems with anchoring).
It opens and prints fine in an online viewer which also produces a PDF which 
thankfully I can edit in Draw. Is this still quite common opening docx in 
Writer?
Steve


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



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

[libreoffice-users] State of docx support.

2022-10-20 Thread Steve Edmonds


Hi.
I have received a 2 page document (.docx) that takes about a minute to 
open in LO 7.3.6 and has some of the items somewhat misplaced (problems 
with anchoring).
It opens and prints fine in an online viewer which also produces a PDF 
which thankfully I can edit in Draw. Is this still quite common opening 
docx in Writer?

Steve


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

Re: [libreoffice-users] [more] Vlookup, and other Help

2022-10-10 Thread Steve Edmonds


That's OK

On 11/10/2022 12:40, Wade Smart wrote:

Well, that is odd.
Im uploading again ...

What about this link?
https://drive.google.com/file/d/1-9vnC9UAoffLdXcVDTTN6oIJ8UJO041w/view?usp=sharing



--
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] [more] Vlookup, and other Help

2022-10-10 Thread Steve Edmonds

At that link I get no download option and a message that the file is in 
your trash.

Steve

On 11/10/2022 12:27, Wade Smart wrote:

https://drive.google.com/file/d/1Q4Skv003T-puY-2CBr-MMQHUVC-qBhfw/view?usp=sharing

I thought I was making headway but just got myself into more of a problem.

The link above is a sample of what Im working with.
In this spread sheet I have hundreds of sections of this that are
added to and updated.

If you click on cell BG4 you'll see the IF hell function that I
continually update (and fix).
This is created by someone else and the IF statement doesnt account
for all the things
that are currently going on but - in general - Section One is B4 to
I4. The entire colored
space from B3 to I13 is the whole section. Each row is calculated by
putting in 1 thru 4 under
each item name, though at the moment, and the reason Im looking to do
this [upgrade] is that
3 and 4 and the coming 5 are not being calculated.

Row 4, B4 to I4 either a 1 or 2 is put in. J4 is the number of items.
Cell BE4 totals all items from each section.

Cell BG4 - currently the massive and incorrect IF statement - adds up
each cell and calculates
a number. In this example, F4 is BL SM and is a 1 so BG is 38. Each
row can have a 1 thru 4
(upcoming 5) in each of the available cells.


Looking at Row 7, Cell BG7 is the start of something I thought would
work but... I got stuck.
And, to be really honest, I got stuck writing this email for help
because - I got lost in trying to
explain this HAHA

Looking at the function in BG7, check if its a number first and then
look up the value of F3 item
1 in Sheet two which is 38. Cell BG8 does the same but shows the
quickly growing IF statement
for getting data for 2 cells.

Question: does someone know of an easier way to do this without
ongoing IF statements?

Wade






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

2022-08-31 Thread Steve Edmonds


What version of LO and what operating system do you have.

On 01/09/2022 03:14, Bids BR HVAC wrote:

Why is my LibreOffice Calc doing this?
The dropdown bars are all blacked out.
The number column is all janky. The numbers are stacked on top of each
other and gets worse when I scroll down.
When I open Calc there is a big section of the page that turns pink, but
not in any specific spot. It is totally random and goes away once I scroll.
I would take a screenshot to show what I mean, but I cannot read the
dropdowns to get me to that point due to them being blacked out.
WHAT AM I TO DO?




--
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] VLOOKUP Syntax to find MAX on a particular date

2022-08-10 Thread Steve Edmonds


Hi Hylton

On 10/08/2022 19:28, Hylton Conacher (ZR1HPC) wrote:

Hi Steve, et al,

On 2022/08/09 23:05, Steve Edmonds wrote:



...
Further to Johnny's question, how is the CSV delimited. Do you just 
have commas between values or are some values also quoted in " ".

There are no " "'s, all comma separated.

When I import a simple CSV using Sheet>Insert sheet from file I can 
set the simple date column as type date at import and using the 
MAXIFS solution proposed by Michael [ in my test 
=MAXIFS($C$2:$C$18,$B$2:$B$18,">="&G2,$B2:$B$18,"<"&(G2+1)) ] works 
well in a test.


Steve, As a courtesy I have sent you a month's worth of data in a csv 
file downloaded from my Ambient Weather station cloud account. Try it, 
as by no means is it a simple one especially when all you want is the 
rainfall on each of the days of the month. into Base
My understanding is that VLOOKUP only returns 1 value, rather than a 
vector from which to determine a date.


I believe what I need to accomplish cannot be done with VLOOKUP and 
that a combination of INDEX(MATCH()) is a better solution especially 
given that the RAW Data file import is going to grow approximately 1MB 
per month, despite being just .csv type.


Moving on from this means that the whole file should preferably be 
manipulated in Base.
Great idea. I currently do a similar thing loading the data csv file 
direct into MySQL every day with a Perl script and then display my 
queries and analysis in web pages for our employees using PHP. For me 
this is much simpler and more flexible and than Calc or Base, especially 
in a multi-user environment


Sorry for wasting everyone's time, Base questions coming soon 0:)

Hylton




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

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

2022-08-09 Thread Steve Edmonds

On 10/08/2022 02:55, Johnny Rosenberg wrote:

Den tis 9 aug. 2022 kl 15:50 skrev Hylton Conacher (ZR1HPC) <
hyl...@conacher.co.za>:

On 2022/08/09 14:53, Johnny Rosenberg wrote:

Den tis 9 aug. 2022 kl 12:26 skrev Hylton Conacher (ZR1HPC)
mailto:hyl...@conacher.co.za>>:

 Hi Johnny,

 On 2022/08/08 22:19, Johnny Rosenberg wrote:
  > Den mån 8 aug. 2022 kl 21:47 skrev Hylton Conacher (ZR1HPC)
  > mailto:hyl...@conacher.co.za>
 >>:
  >
  > Hi,
  >
  > Using LO Calc 7.3.2.2 and I have a 28 column table RAW Data
 table in
  > excess of 65k rows. A three column sample below:
  > DateSimple Date
   Outdoor Temp
  > 2022-01-01T00:05:00+02:00   2022-01-01 00:05:00 17.5
  > 2022-01-01T00:00:00+02:00   2022-01-01 00:00:00 17.4
  >
  >
  > Are those dates numbers formatted as dates or just text?

 The Date column is formatted as number and the simplified Date is
 formatted as text.

 Is VLOOKUP fussy about the format of the cells it must search? I
 thought
 it is just matching a string of characters?

It's not fussy about the format, but rather about the actual value in
the cells, because if it's formatted as a date, it's really just a
number (0.0 = 1899-12-30 00:00:00 and so on

The tab called Raw Data is actually a .csv import of an external file on
which I have no ability to determine how the columns are formatted.

How do you import your file?
What would be an example of a complete line in that CSV file?
Further to Johnny's question, how is the CSV delimited. Do you just have 
commas between values or are some values also quoted in " ".
When I import a simple CSV using Sheet>Insert sheet from file I can set 
the simple date column as type date at import and using the MAXIFS 
solution proposed by Michael [ in my test 
=MAXIFS($C$2:$C$18,$B$2:$B$18,">="&G2,$B2:$B$18,"<"&(G2+1)) ] works well 
in a test.
My understanding is that VLOOKUP only returns 1 value, rather than a 
vector from which to determine a date.

Steve

Kind regards

Johnny Rosenberg

As time progresses so I will download another .csv file and overwrite
the existing one with an updated file.

The bits that contain any formula will remain unchanged, apart from
having their ranges extended due to the additional rows added.

But I wonder about the other column that is formatted as text. What do
you mean by that?

I clicked on one of the cells in the Simple Date column and selected
'Format->Cell' and it returned that is how it was formatted.

Tnx
Hylton

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

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

Re: [libreoffice-users] Tab Bug?

2022-08-09 Thread Steve Edmonds


I suppose you have lots of rows and columns.
I don't think it is a bug in writer not to overwrite letters in a 
"layer" but you may achieve the visual effect you are wanting by making 
each column a text box, each wide enough for the full number, right 
aligned, overlaying to the left, text boxes spaced 0.5".

steve

On 10/08/2022 07:05, Dave Liesse wrote:

Looks like I accidentally sent my response to one respondent instead of to the 
list.  Here's what I said:

--

Using v7.3.4.2, so pretty well up to date.  Language is English (USA) and 
commas/decimals are set correctly.

Tab stops are .5 inches apart, so the numbers definitely overflow (seven digits 
plus commas, 11 point type).  However, in my expectations (a) right tabs should 
work the same as left tabs, regardless of length, and (b) in a word processing 
document I don't expect numbers to be treated any differently from plain text 
-- except in the case of a decimal tab.  I'm using only whole numbers, though.

I need the columns to overlap because of the nature of the report.  I don't 
have space to have three 1.25-inch columns at the right edge of the page and 
the corresponding left tabs on the left side (this is a financial report with 
subaccounts).

Similar problem in the spreadsheet, though it's more expected there.  I need the 
columns to be .5" wide, not wide enough to hold the whole number.  Text would 
overflow into the cell on the right (if it's empty), and I hoped -- but didn't 
really expect -- numbers to do the same to the left.

The problem is that I need numbers to line up properly in right-justified 
columns, without resorting to a fixed-space font (so the leading spaces are the 
same width) and using left tabs.

Dave


On Mon, Aug 8, 2022, at 7:00 PM, Steve Edmonds wrote:

Does not occur for me in 7.3.4.2
What text language shows at the bottom of the window frame. (mine is
English(UK)
What decimal separator is shown in Tools>Options>Language settings
Steve

On 09/08/2022 12:18, Dave Liesse wrote:

Hi, all.  It's been a long time since I've run into a problem of any 
significance, so posting here before I look up how to report a bug (partly to 
see if this really is one).

In a Writer document, I have three Right tab stops set, to show staggered 
columns of numbers.  When I type a large number, though, with commas separating 
the thousands, the tab stop starts acting as a Decimal stop instead of Right.  
For example, if I type 1,234,567 it acts as though the tab stop is a Decimal 
stop and the comma between the 4 and the 5 is a decimal point.  Might this be a 
bug?

As a secondary note: I don't think this one is a bug, but it's certainly 
unexpected behavior.  Because I was in a hurry to get a report out to a client 
I tried the same numbers in a spreadsheet, again expecting the columns would be 
overlapping.  Numeric values, though, won't overflow the cell the way text 
does, even when the cell is specifically right-justified.  Again, I was in a 
hurry so I just entered all the numbers as text, but then had to do my own 
calculations to show totals (no biggie, since I would have had to do that 
anyway in the Writer document, but annoying in a spreadsheet).

The question is really about the first item -- the second one is just a minor 
gripe.  Do y'all think this is a bug, or is there some rational reason the 
program should behave this way?

Dave



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




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

Re: [libreoffice-users] Tab Bug?

2022-08-08 Thread Steve Edmonds


Does not occur for me in 7.3.4.2
What text language shows at the bottom of the window frame. (mine is 
English(UK)

What decimal separator is shown in Tools>Options>Language settings
Steve

On 09/08/2022 12:18, Dave Liesse wrote:

Hi, all.  It's been a long time since I've run into a problem of any 
significance, so posting here before I look up how to report a bug (partly to 
see if this really is one).

In a Writer document, I have three Right tab stops set, to show staggered 
columns of numbers.  When I type a large number, though, with commas separating 
the thousands, the tab stop starts acting as a Decimal stop instead of Right.  
For example, if I type 1,234,567 it acts as though the tab stop is a Decimal 
stop and the comma between the 4 and the 5 is a decimal point.  Might this be a 
bug?

As a secondary note: I don't think this one is a bug, but it's certainly 
unexpected behavior.  Because I was in a hurry to get a report out to a client 
I tried the same numbers in a spreadsheet, again expecting the columns would be 
overlapping.  Numeric values, though, won't overflow the cell the way text 
does, even when the cell is specifically right-justified.  Again, I was in a 
hurry so I just entered all the numbers as text, but then had to do my own 
calculations to show totals (no biggie, since I would have had to do that 
anyway in the Writer document, but annoying in a spreadsheet).

The question is really about the first item -- the second one is just a minor 
gripe.  Do y'all think this is a bug, or is there some rational reason the 
program should behave this way?

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

Re: [libreoffice-users] Badly formatted document

2022-07-04 Thread Steve Edmonds


Is it possible it is an old document from an earlier version of LO.
A while back the way LO anchored images (and frames) was changed, images 
in tables were particularly affected throwing out text positioning also 
and I had to go through all my manuals and change my image anchoring to 
"as character".


On 05/07/2022 04:59, Ian Bertram wrote:

I have been sent a graphic heavy document in ODT format. However it looks as if 
it has been badly converted from a pdf file. The layout is scrambled, headers 
don’t align properly and there are a host of other issues. It is also in 
columns. Is there a simple way to strip out everything bar the words? I have 
tried saving it as a txt file, but this loses a lot of the paragraph numbering 
and introduces other layout issues. Saving in rtf format is even worse.




The best I have managed so far has been by converting all the text to a single 
style and removing the columns. All the graphics however overlap text and it is 
often very difficult to find the anchor point.




Sent fromMailfor Windows








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

2022-06-25 Thread Steve Edmonds

From the help COUNTA(Number 1 [; Number 2 [; … [; Number 255]]]) 
where*Number 1*, *Number 2*, ..., *Number 255* are numbers, references 
to cells or to cell ranges of numbers.


 * The function counts numbers, dates, error values(Err:502), logical
   values (like TRUE ) or a text representation of numbers (like "7")
   passed either as arguments or a reference to the cells or as an
   array however, empty cells in the reference are not counted.

In your case ISBLANK=0 is seen as Number 2 which is a logical value and 
so is counted as 1.


Steve

On 26/06/2022 10:45, Michael D. Setzer II wrote:

With 3 no blank cells in range
=COUNTBLANK($A$2:$A$1000)
Returns 996
These all return 3
=COUNTA($A$2:$A$1000)
=COUNTIF($A$2:$A$1000,">""")
=COUNTIFS($A$2:$A$1000,">""")

Believe =COUNTA(A$2:A$1, ISBLANK=0) is getting
0 from range, but the counts the isblank=0 as an item?


On 25 Jun 2022 at 21:41, Harvey Nimmo wrote:

Subject:[libreoffice-users] Calc function COUNTA
From:   Harvey Nimmo
To: libreoffice-users

Date sent:  Sat, 25 Jun 2022 21:41:23 +0200


I wanted to count the number of non-blank items in a list of items
using COUNTA.

Cell A1 has the formula =COUNTA(A$2:A$1, ISBLANK=0) above an
otherwise empty column.  It returns the value 1!

Is that supposed to mean something? Has anyone notice this?
It's obviously not a big problem, because a workaround is obvious.
But do I have to mistrust the results of the COUNTA function?

Cheers
Harvey


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


++
  Michael D. Setzer II - Computer Science Instructor
(Retired)
  mailto:mi...@guam.net 
  mailto:msetze...@gmail.com

  Guam - Where America's Day Begins
  G4L Disk Imaging Project maintainer
  http://sourceforge.net/projects/g4l/
++






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

Re: [libreoffice-users] ROUND function consistency

2022-06-06 Thread Steve Edmonds

I agree this is not a bug and also find the different functions are not 
consistent in their approach.
Some investigation and analysis shows that using bankers rounding 
results in less accumulated rounding error or bias when processing 
monetary values than the ROUND() function in Calc. I have also found 
that different jurisdictions may define their own rounding approach.


For instance the Australian Tax Office states that when calculating 
sales tax, portions of a cent 0.5 and below should be rounded down, 
above 0.5 rounded up. This is opposite to that performed by the ROUND() 
function but possibly has the logic of accumulating the rounding error 
in favour of the tax payer rather than the tax department and this is 
the approach I have adopted in my macro.


On 06/06/2022 07:01, Andrew Pitonyak wrote:


Sorry, this is NOT a bug. This is exactly the result I expect if I was 
using VBA in MSO. Read on to find out why.


I say this without looking at the code, but, you specifically told LO 
to use the VBA version of rounding, which is NOT normal rounding. VBA 
rounding uses bankers rounding.


https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/round-function

With "Bankers Rounding", when numbers are equidistant from the two 
nearest integers, they are rounded to the nearest even integer; 
therefore, 0.5 rounds down to 0; 1.5 rounds up to 2.


So, it looks like you are getting the correct answer because you 
turned on VBA support so the round function should act like the VBA 
round function. If you really were writing a macro using Microsoft 
Office (MSO), you would probably have used Math.Round() (I think that 
is what it is called) to use the rounding that you were expecting.



On Saturday, June 04, 2022 22:44 EDT, Steve Edmonds 
 wrote:

I have just put a basic macro together so it will calculate income tax
due from our local tax rates.
I needed to round the tax to the nearest cent so taking the easy route I
added Option VBASupport 1 to use the available VB round function.

I then noticed that the VB round function with say round(12.125,2)
rounds down to 12.12 and the LO inbuilt spread sheet function ROUND with
ROUND(12.125,2) rounds up to 12.13.

Is rounding in this situation arbitrary or is there some some convention
for consistency.

Steve


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? 
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy






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

Re: [libreoffice-users] ROUND function consistency

2022-06-05 Thread Steve Edmonds


I just performed a bit of a test.
Cells across.
A1| =RANDBETWEEN(0,10)/100  # simulate dollar and cent amounts 
between 0.00 and $1000.00

B1| =A1*0.15                    # simulate a tax of 15% on the amounts in A
C1| =ROUND(B1,2)                # round the tax amount to 2 places 
(whole cents) using the Calc ROUND function
D1| =VBRND(B1,2)                # round the tax to 2 places using a 
macro function that uses the VBA compatible round function (bankers 
rounding)

E1| =INT(B1*100+0.5)/100        # round the tax the old school way.

Function VBRND(c,d)
VBRND = round(c,d)
End Function

I then copied this row down another 999 rows and performed some 
summation at the bottom of the 1000 results. I regenerated the random 
values in A ten times and recorded the summations below.


(sum RNDBETWEEN) * 0.15 	sum (RNDBETWEEN * 0.15) 	Sum ROUND() 	ABS error 
ROUND()
	sum VBRND() 	ABS error VBRND()	sum int(val*100+0.5)/100 	ABS Error old 
school
75056.829 	75056.829 	75057.07 	0.241908 	75056.74 	0.089000 
75057.07 	0.241908
75388.419 	75388.419 	75388.59 	0.1712095 	75388.4 	0.019000 
75388.59 	0.1712095
74833.6095 	74833.6095 	74833.83 	0.22049995809 	74833.44 	0.169500 
74833.83 	0.22049995809
73028.487 	73028.487 	73028.76 	0.2731048 	73028.42 	0.067000 
73028.76 	0.2731048
73042.698 	73042.698 	73042.95 	0.2513131 	73042.69 	0.008000 
73042.95 	0.2513131
74173.5075 	74173.5075 	74173.8 	0.29249995925 	74173.46 	0.047500 
74173.8 	0.29249995925
75420.3825 	75420.3825 	75420.64 	0.25749992433 	75420.4 	0.017500 
75420.64 	0.25749992433
74621.5965 	74621.5965 	74621.85 	0.2535000617 	74621.55 	0.046500 
74621.85 	0.2535000617
75481.0995 	75481.0995 	75481.41 	0.31050006868 	75481.12 	0.020500 
75481.41 	0.31050006868
73694.1585 	73694.1585 	73694.39 	0.23149994412 	73694.03 	0.128500 
73694.39 	0.23149994412



	Av. Err. 	0.2502697 	Av. Err. 	0.061300 	Av. Err. 
0.2502697



Std. Dev.   0.038875Std. Dev.   0.053381Std. 
Dev.   0.038875




I found that the average magnitude of the error was least with the 
bankers rounding although this ad a little more spread. Bankers rounding 
also had less bias.


Steve

On 05/06/2022 21:55, Michael D. Setzer II wrote:

One windows excell page mentions that it uses the
banking rounding method, which I believe is the round to
nearest even. So, using that method 12.125 would round
to 12.12, while 12.135 would round to 12.14..
With this method if next digit is 1,2,3,4 the number
rounds down. If it is 6,7,8,9 it rounds up. If 0 it does
nothing, but if it is 5, it has to check if the key pervious
digit is an even or old number. If it is even, then it rounds
down, if odd it rounds up.

The regular LibreOffice round uses the standard round
function.

Usually, the standard round is used, but know that some
government regulations require the banking/roundeven
or roundodd method.

Was surprized that excell's would default to banking?
Note sure why they don't provide one for each method, or
have an option to set.



On 5 Jun 2022 at 11:37, Johnny Rosenberg wrote:

From:   Johnny Rosenberg

Date sent:  Sun, 5 Jun 2022 11:37:04 +0200
Subject:Re: [libreoffice-users] ROUND function
consistency
To: LibreOffice Användare



Looks like a bug to me. 12.125 returns 12.12, but 12.1251 returns 12.13.
Both should return the same.
I guess this bug should be reported.
Meanwhile, you can make your own function that you can use. Here are two
different suggestions.

1: This one use the Calc built-in ROUND() cell function. Place it in "My
macros & dialogs". VBA compatibility mode is not needed.

Public Function faRound(x As Double, d As Integer)
Dim Calc
Calc=createUnoService("com.sun.star.sheet.FunctionAccess")
faRound=Calc.callFunction("ROUND", Array(x, d))
End Function

2: This one use the method we learned at school:
Public Function fRound(x As Double, d As Integer)
fRound=Int(10^d*x+.5)/10^d
End Function

Test:
Print afRound(12.125, 2)
Result: 12.13

Print fRound(12.125, 2)
Result: 12.13

Print fRound(12.125, 1)
Result: 12.1

... and so on.

Kind regards

Johnny Rosenberg

Den sön 5 juni 2022 kl 04:46 skrev Steve Edmonds 
:
I have just put a basic macro together so it will calculate income tax
due from our local tax rates.
I needed to round the tax to the nearest cent so taking the easy route I
added Option VBASupport 1 to use the available VB round function.

I then noticed that the VB round function with say round(12.125,2)
rounds down to 12.12 and the LO inbuilt spread sheet function ROUND with
ROUND(12.125,2) rounds up to 12.13.

Is rounding in this situation arbitrary or is there some some convention
for consistency.

Steve


--
To unsubscribe e-mail to:users+unsubscr...@global.libreoffice.org
Pr

[libreoffice-users] ROUND function consistency

2022-06-04 Thread Steve Edmonds

I have just put a basic macro together so it will calculate income tax 
due from our local tax rates.
I needed to round the tax to the nearest cent so taking the easy route I 
added Option VBASupport 1 to use the available VB round function.


I then noticed that the VB round function with say round(12.125,2) 
rounds down to 12.12 and the LO inbuilt spread sheet function ROUND with 
ROUND(12.125,2) rounds up to 12.13.


Is rounding in this situation arbitrary or is there some some convention 
for consistency.


Steve


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

Re: [libreoffice-users] problem with file name with some dot on name

2022-05-03 Thread Steve Edmonds

I found this a long time ago with LO, I am not sure if it ever was fixed 
or if this is a regression.


On 04/05/2022 09:49, Nilton Jose Rizzo wrote:

Hi all,


    I found a problem using my LibreOffice 7.3.2.2 on FreeBSD 14-current.

    If the file name has more then one dot (.) the file dialog to save 
as or export as PDF or other way to change a file name, only show all 
characters until first dot ocurrence.


    One example is:

        File.Name.Other.Name.odt  it will show as File.

    The file extension (.odt or .pdf) not added on the end string




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

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

2022-04-27 Thread Steve Edmonds

What happens when you maximise and then click on the Restore for the 
resizeable window. Does it not respond or disappear altogether. I had 
the latter once.


On 28/04/2022 13:24, Rogier F. van Vlissingen wrote:

On Linux Mint 20.3

LO Spreadsheet does not allow me to adjust the screen partially. I can
either do full screen or minimize completely. I have no clue what keys I
might have accidentally touched. Still works fine in Writer, but no longer
in Calc.

Any ideas?




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

Re: [libreoffice-users] Clearing formatting.

2022-04-07 Thread Steve Edmonds



On 08/04/2022 08:40, Michael D. Setzer II wrote:

Column A has number
Column B sees if value can be used in formula (=a+1)
Column C checks isnumber result
Column D checks is text result
Column E checks Format result
Column F checks Type result
Column G =col(a) but format set to $
123124TRUE FALSEF0v$123.00C2-
'123124FALSETRUEF0l123C2-
`123124TRUEFALSEF0v$123.00C2-
“123#VALUE!FALSETRUEF0l“123C2-
^123#VALUE!FALSETRUEF0l^123C2-
Interesting that a 'number is not a number but can be used in formula? 
But a numeric format is not applied since it is a label type?


Yes, that got me interested.
--
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] Clearing formatting.

2022-04-07 Thread Steve Edmonds

The data is from part of a table on a public page but created in 
response to entering a street address.
There are no issues when I paste the data if I select "detect special 
numbers" and there are no issues processing the numbers preceded with a 
'  in a calculation.


I started wondering why LO doesn't see '123 as a format it can change or 
is it an over riding format that LO won't change and when I have a 
format like '123 how do I get it back to a number. If I type '123 into a 
cell, Format>Cells.. tells me it is a number, I can use it in a formula 
but can't sum it.


If you format a cell as text (right click or Format>Cells..) and type in 
$123.00 you have some text as expected. If you delete the $ you have 
123.00. If you now Format>Cells.. and select Number>General you would 
expect this to become a number format, but LO inserts the ' so it 
becomes '123.00 and changes the cell format to number but forcing the 
contents to remain as text.


From this point my question arose as to how to remove the ' so the 
contents of the cell became a number, and which Brian solved for me.


Steve

On 07/04/2022 13:18, Michael D. Setzer II wrote:

Note: That the "`" does work. In my testing I must have
enter ' instead of ` and the is why the "`" didn't work
since it was char(39) instead of char(96)..

Just wondering if the data is from a public page or some
kind of private page?? I have a spreadsheet that uses the
external data link to a web site to get the latest covid
stats for the US states, D.C. and territories. Than have
macro that processes it into rest of sheet.

Would be interesting to see how the spreadsheet
processes in the ` with the number. When I type in a
number with a ` at the front, it shows that value as a text
field and is left justified..



On 6 Apr 2022 at 10:58, Michael D. Setzer II wrote:

From:   "Michael D. Setzer II"

To: Steve Edmonds
,
users@global.libreoffice.org
Date sent:  Wed, 06 Apr 2022 10:58:56 +1000
Subject:Re: [libreoffice-users] Clearing formatting.
Send reply to:  msetze...@gmail.com
Priority:   normal


=On 6 Apr 2022 at 10:13, Steve Edmonds wrote:


Date sent:60;Wed, 6 Apr 2022 10:13:51 +1200
To: 0;users@global.libreoffice.org
From:  Steve Edmonds

Subject: ;[libreoffice-users] Clearing formatting.



Hi, just wondering if there is an easy way to clear formatting of the
style '2892 where the apostrophe is used.
When I paste data from a web page LO inserts the apostrophe by default.
I realise there are options on pasting to have numbers pasted as text,
but my query is in regards converting '2892 to the number 2892.



Not sure this would work.
Assuming you are using text formatting dialog option.
You could click on the other option in addition to
whatever filtering options you are using. Then put the
apostrophe in the position after the other.
You will end up with a column with the blanks where the
apostrophy was. Would then just delete that column.
That does assume that all numbers in column have
apostrophy and that other cells don't have apostrophy's?
Another option that might work for you.
Past data as currently done.
In another column to right put formula
No leading " an assuming D1 is cell with '2982 format
numbers. Tried to match with "`" but it didn't work?? Had
to use code and ascii value for `'
\u201c=IF(CODE(LEFT(D1,1))=39,VALUE(MID(D1,2,20)),d1)
If all numbers have ` you could just use.
No leading "
\u201c=VALUE(MID(D1,2,20))


Then copy the formula going down.
Then highlight. Ctrl-C, and the Shift-Ctrl-V over original
data, rather than doing one cell at a time.


Perhaps one of those would work with your data.
Good Luck. Have a nice day.





I cannot Format Cells... format as number or clear direct formatting or
find and replace the '. I can Ctl-x, Ctl-Shft-v and paste and the ' is
cleared.

Steve

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




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




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-l

Re: [libreoffice-users] Clearing formatting.

2022-04-05 Thread Steve Edmonds



On 06/04/2022 15:03, Brian Barker wrote:

At 10:13 06/04/2022 +1200, Steve Edmonds wrote:
...just wondering if there is an easy way to clear formatting of the 
style '2892 where the apostrophe is used. When I paste data from a 
web page LO inserts the apostrophe by default. I realise there are 
options on pasting to have numbers pasted as text, but my query is in 
regards converting '2892 to the number 2892.


Are we talking spreadsheets? I don't think you mean formatting at all. 
At least, I suspect those apostrophes do not appear in the spreadsheet 
cells but instead only in the Input Line when you select a relevant 
cell. The apostrophe is just an indication - a warning - that what 
looks like a number in the cell is actually text. (Another indication 
may be that the values are left- rather than right-aligned by default.)



I cannot Format Cells... format as number or clear direct formatting ...


Well, you can do all of those things, but none of them will change the 
values you have in the cells, which is what you need to do - to 
convert text to the numerical value of that text, to convert 
two-eight-nine-two to two thousand, eight hundred and ninety-two.



... or find and replace the '.


You certainly cannot do that, as there is no apostrophe in the cell 
value to be found!


Here's an easy way:
o Select the column of values.
o Go to Data | Text to Columns... .
o OK.

I trust this helps.


Thanks Brian, the above worked.
Steve

Brian Barker





--
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] Clearing formatting.

2022-04-05 Thread Steve Edmonds

Hi, just wondering if there is an easy way to clear formatting of the 
style '2892 where the apostrophe is used.
When I paste data from a web page LO inserts the apostrophe by default. 
I realise there are options on pasting to have numbers pasted as text, 
but my query is in regards converting '2892 to the number 2892.


I cannot Format Cells... format as number or clear direct formatting or 
find and replace the '. I can Ctl-x, Ctl-Shft-v and paste and the ' is 
cleared.


Steve

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

Re: [libreoffice-users] Toolbar name in Libre Draw

2022-03-06 Thread Steve Edmonds

When the toolbar has too many icons for the width of the window there 
are 2 chevrons to the right you click to access the other icons.

Steve

On 07/03/2022 13:44, charles meyer wrote:

I can Customize the toolbar I have check marked (namely Standard) and add
each icon one by one but that toolbar will run out of real estate after
adding just a few icons.



I didn't have to Customize my Standard Toolbar in Writer - all the icons
(features) I wanted were already on the toolbar.



I have Standard toolbar on Writer but there are already places there for
Font Style, size and a ton of other icons.


Charles.

From: W. Robert J. Funnell, Prof. 
Date: Sun, Mar 6, 2022 at 5:32 PM
Subject: Re: [libreoffice-users] Toolbar name in Libre Draw
To: users@global.libreoffice.org 
Cc: charles meyer 


If you right-click on one of those icons and select Customize Toolbar, you
should see a large dialogue window. The Target field should indicate the
name of the toolbar that you're customizing, presumably Standard if that's
the only one with a checkmark in View > Toolbars. The dialogue window
allows you to completely change the contents of any toolbar.

- Robert




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

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

2022-03-06 Thread Steve Edmonds

Hi Charles. Have you got acrobat reader. There are instructions here 
without using LO.

https://allthingsencaustic.com/print-image-multiple-pages/
Steve

On 07/03/2022 10:49, charles meyer wrote:

Hi,

I'd like to create a 4 sheet of a PNG in Libre Writer.

In Writer, I followed these isntrctuons...
https://ask.libreoffice.org/t/divive-page-into-4-parts-librewriter/36389/5
Format> Page SetUp>Columns and chose 2

Then, using the mouse I grabbed the center box in the PNG and dragged that
down halfway on the screen but that just compresses the graphic like a
circus mirror.

I then chose Print and in there I can choose Pages per sheet (default to
set at 1) so I typed in 4 where that 1 was displayed and clicked Print to
PDF which saves that PNG in the top left corner with 3 others corners blank.

Is there another step needed  to "duplicate" or "multiply" that PNG from
the top left corner so it's in all 3 other other areas (now blank) on the
single sheet?

Thank you.




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

Re: [libreoffice-users] opening a csv file in a calc sheet

2022-02-25 Thread Steve Edmonds

And you can also right click in the sheet list at the bottom and insert 
a sheet from file.

Steve

On 26/02/2022 11:31, Philip Jackson wrote:
I sometimes have to work on data which arrives to me in csv text 
files. I would like to have each csv file's data in a separate sheet 
within a single calc file. No matter how I try to open the csv files, 
each one opens in a fresh calc spreadsheet and I have to manually copy 
/ paste the data into a new sheet in my main calc spreadsheet.


Is there a way to open a csv file and have the data imported directly 
inside a new sheet of an existing calc file ?


Philip



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

Re: [libreoffice-users] opening a csv file in a calc sheet

2022-02-25 Thread Steve Edmonds


Hi Philip.
In the menu 'Sheet' there is an insert sheet from file. This will insert 
the CSV as a new sheet.

Steve

On 26/02/2022 11:31, Philip Jackson wrote:
I sometimes have to work on data which arrives to me in csv text 
files. I would like to have each csv file's data in a separate sheet 
within a single calc file. No matter how I try to open the csv files, 
each one opens in a fresh calc spreadsheet and I have to manually copy 
/ paste the data into a new sheet in my main calc spreadsheet.


Is there a way to open a csv file and have the data imported directly 
inside a new sheet of an existing calc file ?


Philip



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

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

2022-02-23 Thread Steve Edmonds

What I have done before is to click Forward for that email which then 
enables me to edit the format of the newsletter (delete rows I don't 
want, etc.) and then send it to myself and copy/paste the simplified table.


Another thing I have done is to copy and paste into Calc and adjust the 
structure there and then copy into Writer.


And then sometimes I just take a screen clip and insert that as an image.

The choice comes down to the structure in the email and what I am trying 
to do with it in Writer.

steve

On 24/02/22 2:40 am, Ian Bertram wrote:

Try Converting the table to text. It usually works for me.

On Wed, 23 Feb 2022, 02:15 charles meyer,  wrote:


Do you ever receive emails of mini-newsletters where you want to save some
of the content in the email but if you copy/paste it into Libre Writer it’s
all in a table?



Looks good but now you wish to delete 1/3 of the content except you have to
delete rows, etc.



So time consuming.



I’ve tried all 4 ways to Paste into Libre Writer (plain text loses all the
bullet  points)



Is there any shortcut to removing content from a table without losing all
the formatting (e.g. bullet points, graphics?



Thank you.

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




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

Re: [libreoffice-users] mail merge email dialog box not opening

2022-02-12 Thread Steve Edmonds


Hi, I think you need mail merge for what you want to do.
There is a step by step here for LO5 that may help 
https://www.maths.cam.ac.uk/computing/files/email/LibreOffice5mailmerge.pdf


steve

On 13/02/2022 07:44, Brian Carey wrote:

Hi,

I'm hoping someone can help with this frustrating problem. I have 
tried in both Linux (Arch) and Windows 11.


I have set up the mail server connection and tested it. I have set up 
the email client. I have created a spreadsheet which includes email 
addresses, connected to it in writer and created a document with fields.


The problem is that when I select File/Send/Email Document... I do not 
get a dialog box with any options, it just opens a new mail with an 
attachment.


I would like to send the text of the document as an email not an 
attachment. Is this possible?


Thanks in advance,

Brian





--
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] My Question About Security

2022-01-27 Thread Steve Edmonds


As well as the previous answers

How to Protect LibreOffice Documents with Passwords
https://websiteforstudents.com/protect-libreoffice-documents-passwords/

steve

On 27/01/2022 21:08, NE NE wrote:

Hi, My name is Hatice from Turkey.

First of all, thank you for making free software available to people. And my 
question to you is:

"When we use the programs included in your software, for example; When we write a 
document, no one but us can access this document, right? I mean our files should be 
protected on our computer. your program should not have online-like functionality."

Can you please inform me about that issue.

Have a nice day and I wish you good work...




--
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] Question on INDIRECT()

2021-10-23 Thread Steve Edmonds


Hi Rob, did you ever get this answered.
You could use something like the below for the cells with a '+' in them.
Assuming below is row 4, vertical bars are cell borders.
|25+15|=VALUE(LEFT(A4,FIND("+",A4)-1))+VALUE(RIGHT(A4,LEN(A4)-FIND("+",A4)))|

If you need it to be generic for with/without the + then you could use 
an IF to check, shown below for row 5.

=IF(ISNUMBER(A5),A5,VALUE(LEFT(A5,FIND("+",A5)-1))+VALUE(RIGHT(A5,LEN(A5)-FIND("+",A5

Steve

On 18/10/2021 12:13, Rob Jasper wrote:

Hi list-users,

I have the following question:

I have in column A value either a number, or string in the format  +, 
in col B I want to calculate what’s in Col A
e.g.:

   10   10
12+72   84
   33   33
66+72   138

So, I tired the formula =INDIRECT(“=“&A1) but I only get REF!
What am I doing wrong here, and how can I achieve what I 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] How to print a section of a SS

2021-10-18 Thread Steve Edmonds


Hi John.
What version of Libreoffice are you on.
When you say you want to print a section of a sheet, is that a single 
section on just one sheet or sections of multiple sheets.


For me on a single sheet, sometimes the print range has some history 
from previous activity.

I go Format>Print Ranges>Clear to start.
Then I highlight the range to print with the mouse and go Format>Print 
Ranges>Define.


Then I go to File>Print Preview to see how many pages that selected 
range will print on, and if necessary adjust the top -/+ slider or page 
format to suit my needs.

Steve

On 18/10/2021 16:12, John R. Sowden wrote:
In an "office" program, I made the foolish assumption that people 
would understand that SS means Spread Sheet.  I apologize to those who 
did not grasp that.


The version of Thunderbird is 13.0 (32 bit).  Again I assumed that the 
instructions for a common function, that of printing a section of a SS 
(see reference above) would not change from version to version.  
Again, I apologize to those who were confused about the stability of 
user interfaces.


Humbly,
John


On 10/16/21 8:07 AM, Dan Lewis wrote:


On 10/15/21 8:25 PM, 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?,

John


What do you mean by SS? Which component of LibreOffice are you using? 
What version of LibreOffice are you using?


Dan








--
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-18 Thread Steve Edmonds


Your welcome John.
I was doing exactly what you were doing to start with.
Steve

On 19/10/2021 16:51, John R. Sowden wrote:
Thank you Alan and Steve.  I was not printing to a PDF, but that could 
have been a later nightmare.  Where my mindset was wrong was that I 
thought that the mousing a section WAS the define.  So I clicked on 
define, then moused, then had nothing.  I just tried your method Steve 
and it worked.  My vendor in Canada will receive my limited 
spreadsheet shortly!


Thank you,
John



On 10/18/21 5:51 PM, Alan B wrote:
I hasn't been mentioned if the OP is printing to PDF, and my bad for 
never
reporting the bug, but using LibreOffice File>Export as PDF or the 
Export
Directly as PDF icon causes EVERYTHING on all tabs to print to the 
PDF no
matter what print range might be specified, no matter if the print 
ranges

are deleted then selected anew. EVERYTHING gets dumped into a PDF.

Need to be certain the OP isn't using the PDF feature. If they are, 
that is

the source of the problem.

On Mon, Oct 18, 2021 at 8:38 PM Steve Edmonds 


wrote:


Hi John.
What version of Libreoffice are you on.
When you say you want to print a section of a sheet, is that a single
section on just one sheet or sections of multiple sheets.

For me on a single sheet, sometimes the print range has some history
from previous activity.
I go Format>Print Ranges>Clear to start.
Then I highlight the range to print with the mouse and go Format>Print
Ranges>Define.

Then I go to File>Print Preview to see how many pages that selected
range will print on, and if necessary adjust the top -/+ slider or page
format to suit my needs.
Steve

On 18/10/2021 16:12, John R. Sowden wrote:

In an "office" program, I made the foolish assumption that people
would understand that SS means Spread Sheet.  I apologize to those who
did not grasp that.

The version of Thunderbird is 13.0 (32 bit).  Again I assumed that the
instructions for a common function, that of printing a section of a SS
(see reference above) would not change from version to version.
Again, I apologize to those who were confused about the stability of
user interfaces.

Humbly,
John


On 10/16/21 8:07 AM, Dan Lewis wrote:

On 10/15/21 8:25 PM, 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?,

John

What do you mean by SS? Which component of LibreOffice are you using?
What version of LibreOffice are you using?

Dan






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

List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy









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

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

2021-10-14 Thread Steve Edmonds


I see this question repeated frequently going back to 2011.
From Robert Großkopf earlier this year;

is there any entry in
Tools → Options → LibreOffcie → User Data → First Name / Last Name?

The cursor will set to the position the user endet to work with thge
document. If there is no user defined it will always be set at the start
of the document.

Regards

Robert

On 15/10/2021 13:35, H wrote:

I am running LO 5.3.6.1, the latest version available for CentOS 7. I have an 
"annoyance" where the cursor position when documents were last saved is not 
restored. Although it seems to work in Calc, it does not work in Writer nor in Impress.

Is there a setting I have missed given the version I use?





--
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] Libre Office - new

2021-09-28 Thread Steve Edmonds


Hi Charles.
When Libreoffice is open click Help>About Libreoffice to see the version 
running.

Steve

On 29/09/2021 05:41, charles meyer wrote:

Hi All,

I'm trying out the Color Picker tool in Libre Draw.

There seems to be differences between my installed Draw 7.0 -vs- 7.2

I downloaded the new Libre Office from here ...
https://www.libreoffice.org/donate/dl/win-x86_64/7.2.1/en-US/LibreOffice_7.2.1_Win_x64.msi

I found it on my hard drive and clicked install. It displayed it was
installed but it never prompted  me if I wanted a desktop con.

I find the .exe file on my hard drive but can't find 7.2 as installed.

I looked in W10 listed at newly added software and alphabetically and find
LO 7.0 buy not 7.2

I didn't  uninstall 7.0, just wanted to add 7.2

Perplexing.

If it's installed as it displayed then how do I find it?

Would you please cc or bcc me with your reply as I get the digest version
late.

Thank you!

Charles..




--
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] extracting cell values

2021-09-25 Thread Steve Edmonds


Hi Miss  K.
The purpose of your request is not clear.
For the situation where I want to de-reference a value I use copy and 
then paste-special selecting only numbers.
If you want 167 in A1 and 16.7 in A2 so that is stays 16.7 even if A1 
changes then possibly in B1 put =A1/10 then copy B1 and in A2 
paste-special selecting only numbers to paste.
I arrange the type of calculation above so that I can copy/paste-special 
rows or columns at a time.

Steve

On 26/09/2021 05:02, mxk wrote:

Users Ahoy:

Is there a way to get LO (v5.2.7.2) calc to extract the numerical 
value from a cell, and use that instead of the cell reference in 
further calculations?


Frinstance, if I have 167 in cell A1, and want 16.7 in A2, how can I 
program it, (if at all)?


If I put =A1/10 into A2, A2 will contain A1/10, not 16.7,even though 
it will display as 16.7.


I want to get away from cell references and use the contained values. 
Can I?


I thought that =VALUE(A1)/10 might work, but the result continues to 
use the cell reference, not the contained value.


Miss K





--
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: Default file name for Export Directly as PDF is now blank.

2021-08-30 Thread Steve Edmonds


I think I have this worked out.
If the PDF exists already the Name field is blank.
If the PDF doesn't exist the Name field is filled with the name of the file.

The older files that were working before saving (as .odt) were .sxw.
It would save time hunting down the PDF file to overwrite and avoid a 
mistake of overwriting a wrong file if the Name field was filled by default.


Steve

On 31/08/2021 09:59, Steve Edmonds wrote:

Hi.
For a while now I have noticed when I Export Directly as PDF from 
writer (7.1.5.2) the Name field for the file in the file dialogue is 
blank when once it defaulted to the odt file name but with a pdf 
extension.


I have just been updating some older documents and with these, as long 
as I have not saved them, Export Directly as PDF has the Name field 
pre-filled with the file name. As soon as I save the odt file the Name 
field is no longer pre-filled.


I thought may be this was some setting in LO options but it seems 
document specific.


Should the Name field in file dialogue to Export Directly as PDF be 
prefilled with the file name or is this discontinued, if it should be 
how do I get this to happen.


TIA steve



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

1 2 3 4 5 6 7 8 9 10 >

1 - 100 of 1048 matches

Mail list logo