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

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

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

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

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

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

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

2024-08-22 Thread Steve Edmonds
use 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.documentfo

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

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 cha

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

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

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

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

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

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

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

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:

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 Cen

[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

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

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

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 attac

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

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

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.

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

2023-07-31 Thread Steve Edmonds
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

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

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

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 whe

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 c

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 automatic

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

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 th

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

2023-07-23 Thread Steve Edmonds
. 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

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

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

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.

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

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 field

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

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

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

Re: [libreoffice-users] Image Anchor Selection

2023-06-14 Thread Steve Edmonds
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 + &q

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

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

Re: [libreoffice-users] Function acting on range

2023-03-17 Thread Steve Edmonds
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()

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

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

[libreoffice-users] Function acting on range

2023-03-15 Thread Steve Edmonds
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

[libreoffice-users] Video on Impress (Linux OS 7.0.4.2) causes CPU to race

2023-03-07 Thread Steve Rinsler
this occurring. Appreciate advice, suggestions. Thanks. 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

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

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

[libreoffice-users] Possible formatting but in calc.

2023-02-06 Thread Steve Edmonds
D (=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/Net

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

2023-02-03 Thread Steve Edmonds
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

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

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,

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

Re: [libreoffice-users] Macros in spreadsheets

2023-01-03 Thread Steve Edmonds
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

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 St

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

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

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

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

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 wi

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

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

2022-10-28 Thread Steve Edmonds
ialogue. 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, LibreOff

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

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

[libreoffice-users] State of docx support.

2022-10-20 Thread Steve Edmonds
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

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

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

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

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 &

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

2022-08-09 Thread Steve Edmonds
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 .c

Re: [libreoffice-users] Tab Bug?

2022-08-09 Thread Steve Edmonds
eft, 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/decimal

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 i

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 charac

Re: [libreoffice-users] Calc function COUNTA

2022-06-25 Thread Steve Edmonds
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.

Re: [libreoffice-users] ROUND function consistency

2022-06-06 Thread Steve Edmonds
ort 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, Ste

Re: [libreoffice-users] ROUND function consistency

2022-06-05 Thread Steve Edmonds
. 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

[libreoffice-users] ROUND function consistency

2022-06-04 Thread Steve Edmonds
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

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

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.

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 FALSE

Re: [libreoffice-users] Clearing formatting.

2022-04-07 Thread Steve Edmonds
t 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

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 ther

[libreoffice-users] Clearing formatting.

2022-04-05 Thread Steve Edmonds
rting '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

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

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 isntrc

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 s

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

Re: [libreoffice-users] Extracting content out of table format received in an email

2022-02-23 Thread Steve Edmonds
t 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 tex

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 pr

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

Re: [libreoffice-users] LibreOffice and Windows 11

2021-11-02 Thread Steve Hachey - Systems Coordinator
Hi Virgil, i have not tried libre on windows 11 yet (i've been tinkering with win11 on my laptop) but as a PC tech supporting 105 PCs at work, I can say that i have reviewed windows 11 fairly well now and there is no rush to upgrade yet. windows 10 is fully supported with updates till oct 25,

Re: [libreoffice-users] Question on INDIRECT()

2021-10-23 Thread Steve Edmonds
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 quest

Re: [libreoffice-users] How to print a section of a SS

2021-10-18 Thread Steve Edmonds
int 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 O

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

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

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 downlo

  1   2   3   4   5   6   7   8   9   10   >