Re: [libreoffice-users] Unwanted Text Boxes all over the document - 60258 - John Iliffe

2025-05-27 Thread Steve Edmonds
eryone who replied to this request. Steve Edmonds was kind enough to take a look at the full document and he found out how to remove the extra text boxes.  He suggested that I could highlight any of the affected paragraphs and then edit the border style to set the border to no border.  Interest

Re: [libreoffice-users] Writer file increase in size

2025-04-18 Thread Steve Edmonds
On 18/04/25 3:01 am, Philip Jackson wrote: On 17/04/2025 16:18, Philip Jackson wrote: I just reworked an old document written in Writer five years' ago. My intention was to replace all the images with new ones. There are 69 png images in the doc and all are black and white line drawings sa

Re: [libreoffice-users] Cannot make formula work

2025-04-18 Thread Steve Edmonds
I just tried this and pasting a formula into the cell formatted as text still resulted in a working formula. Thomas, in the cell that does not work correctly, check (in the formula entry bar) that the first character is not an apostrophe. I.e. =COUNTIF(H2:H2321,"会社員") and not '=COUNTIF(H2:H2321,"

Re: [libreoffice-users] Writer file increase in size

2025-04-18 Thread Steve Edmonds
Hi Philip. What happens if you "Save As" to create a new document. Is that also 8.1MB. For some reason this is sounding familiar from some years ago. Steve On 18/04/25 2:18 am, Philip Jackson wrote: I just reworked an old document written in Writer five years' ago. My intention was to replac

Re: [libreoffice-users] Cannot make formula work

2025-04-15 Thread Steve Edmonds
Hi Brian. In your quoted text the first countif has periods and the second one has commas. Did you do that or does it hint at some character (uni)code differences even though they look the same. On 16/04/25 5:42 pm, Thomas Blasejewicz wrote: On 2025/04/16 13:43, Brian Barker wrote: At 11:50

Re: [libreoffice-users] Please help

2025-04-15 Thread Steve Edmonds
Hi Jessica. Ctl + F should bring up a find search field at the bottom left of your window. Steve On 16/04/25 8:34 am, Jessica Taylor wrote: I am a brain injured survivor and though I write books technical things are problems Someone updated my laptop and had Libreoffice replacing Word. I nee

Re: [libreoffice-users] Missing spell-check marks in LO 25.2

2025-03-14 Thread Steve Edmonds
Also check that for the language showing at the bottom of the writer window, there is a spell check dictionary installed with the same language. I have to install a dictionary every time. On 15/03/25 8:18 am, MR ZenWiz wrote: On Fri, Mar 14, 2025 at 12:17 AM Gabriele Bertolucci wrote: Did yo

Re: [libreoffice-users] Moving single cell in Calc

2025-03-03 Thread Steve Edmonds
On 03/03/2025 06:56, Wiebe van der Worp wrote: On 3/2/25 16:44, Gabriele Bertolucci wrote: First you have to select the cell: click on it, then click again and keep clicked, ... If you think about it, I agree 100% with OP, it is a clumsy way to go. An alternative: === Click on cell result

Re: [libreoffice-users] Documents come up blank after update

2025-02-27 Thread Steve Edmonds
-863-3361 (phone) th...@computerconnectionltd.com On 23-Feb-2025 5:00 a.m., Steve Edmonds wrote: If you try to select some text that is not showing and copy it can you paste it to another application. I vaguely recollect a long time ago my font colour switching to white so the text was there but I couldn't see it, not

Re: [libreoffice-users] unable to create digital signature/self-signed certificate

2025-02-26 Thread Steve Edmonds
Hi On 27/02/25 3:23 am, Brad Rogers wrote: On Wed, 26 Feb 2025 08:16:22 -0500 Christopher Sesi wrote: Hello Christopher, I would like to be able to digitally sign libre office documents but I am unable to do so. I read that in order to add a digital signature/certificate, I should go to tools

Re: [libreoffice-users] Documents come up blank after update

2025-02-23 Thread Steve Edmonds
If you try to select some text that is not showing and copy it can you paste it to another application. I vaguely recollect a long time ago my font colour switching to white so the text was there but I couldn't see it, not even sure this was in LO either. Steve On 23/02/25 10:07 am, Thane K.

Re: [libreoffice-users] Copy - Pasting graphics into Writer

2025-02-12 Thread Steve Edmonds
On 13/02/2025 02:45, Philip Jackson wrote: On 12/02/2025 01:03, Steve Edmonds wrote: Unfortunately, if you add a page break on the line after the photo the photo moves to the next page, and if you add a return on the line after the photo the photo moves down 1 line, you have to move it back

Re: [libreoffice-users] Copy - Pasting graphics into Writer

2025-02-11 Thread Steve Edmonds
On 11/02/2025 23:18, aguador wrote: In my quick and dirty experiment, moving to the end of the file (dedicated key or Fn-Down on many laptops) moved the cursor after the photo from which you can add another image, text, a page break or whatever. Unfortunately, if you add a page break on the line

Re: [libreoffice-users] Copy - Pasting graphics into Writer

2025-02-10 Thread Steve Edmonds
Hi Charles, I usually add the next page with ctl-enter before pasting the image. Have you tried the menu item Insert>Page break. And yes, the image anchoring is a bit weird so best to do before pasting the image. Steve On 11/02/2025 14:59, charles meyer wrote: Hi All, I visits sies and grab

Re: [libreoffice-users] Line Spacing - "Feature" or "Bug"?

2025-01-30 Thread Steve Edmonds
What are your actual steps as I can't reproduce this. How/when do you insert the □. When you say "adding the character undoes the paragraph formatting" does this mean that if you insert the box into a line spaced at 1.5 it instantly reverts to spacing 1. Are you pasting special, unformatted, or

Re: [libreoffice-users] How to change space between paragraphs?

2025-01-28 Thread Steve Edmonds
On 29/01/2025 02:56, Philip Jackson wrote: On 28/01/2025 01:12, Barrie Rowland-hornblow wrote: I'm currently trying to change the pt size between paragraphs across my entire document, I've currently got 8pt and am trying to change it to 6pt is there a way to update the size on the entire docum

Re: [libreoffice-users] Libreoffice --convert-to question

2024-12-16 Thread Steve Edmonds
On 14/12/24 5:36 pm, Fred James wrote: Fred James wrote: OS: Mageia8 Linux LO: 7.4.5.1 The following (CLI) command ... libreoffice --convert-to txt:"Text - txt - csv (StarCalc)" budget_2024.ods ... produces a CSV text file, but apparently only of the first spreadsheet in the file. If I can o

Re: [libreoffice-users] Libreoffice --convert-to question

2024-12-14 Thread Steve Edmonds
On 14/12/2024 17:36, Fred James wrote: Fred James wrote: OS: Mageia8 Linux LO: 7.4.5.1 The following (CLI) command ... libreoffice --convert-to txt:"Text - txt - csv (StarCalc)" budget_2024.ods ... produces a CSV text file, but apparently only of the first spreadsheet in the file. If I ca

Re: [libreoffice-users] Make internal document links work in exported PDF

2024-10-18 Thread Steve Edmonds
Hi. I should also mention that when you create the PDF you create it from within Libreoffice (File>Export As..), not from the windows print to PDF or what ever it is called as an employee of ours always seemed to want to do. Steve On 16/10/2024 20:00, Robert Großkopf wrote: Hi Thomas, down

Re: [libreoffice-users] Document formatting (display) errors on Mac.

2024-10-13 Thread Steve Edmonds
talled on > all your platforms? You could be experiencing some font substitution which > renders the document with a similar but different font. > > Regards, > Rémy. > Le lundi 14 octobre 2024 à 10:06 +1300, Steve Edmonds a écrit : > > Hi. > I have struck an issue tryin

[libreoffice-users] Document formatting (display) errors on Mac.

2024-10-13 Thread Steve Edmonds
Hi. I have struck an issue trying to edit a document on my Mac where the document on screen formatting is quite different from the way it is displayed on Linux or Win10. I had a search of bugzilla for similar symptoms but couldn't locate anything. I am not sure if this is an issue with the Mac

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 th

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

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

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...@global.l

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: http://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. http://sid.libreoffice.org/get-help/nabble/ Steve -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfound

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

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 L

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: http://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
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 un

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

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

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

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

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

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 treat

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

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

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

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 d

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

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

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

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? http://drive.google.com/file/d/1-9vnC9UAoffLdXcVDTTN6oIJ8UJO041w/view?usp=sharing -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://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: http://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 li

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

Re: [libreoffice-users] Tab Bug?

2022-08-09 Thread Steve Edmonds
#x27;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

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 an

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

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

  1   2   3   4   5   6   7   8   9   10   >