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

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

2024-04-09 Thread Steve Edmonds
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

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

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:

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

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

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/2023 19

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

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,

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

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

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

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

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

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

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:

[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

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

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

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

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:

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

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

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

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,

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

[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

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

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

[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

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

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

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

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

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

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

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

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

[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

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?

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

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

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

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

Re: [libreoffice-users] ROUND function consistency

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

Re: [libreoffice-users] ROUND function consistency

2022-06-05 Thread Steve Edmonds
25, 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 ta

[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

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

Re: [libreoffice-users] Clearing formatting.

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

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

[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

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

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

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

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

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

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

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

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

2021-10-18 Thread Steve Edmonds
ets 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 sin

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

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

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

[libreoffice-users] Re: Default file name for Export Directly as PDF is now blank.

2021-08-30 Thread Steve Edmonds
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

[libreoffice-users] Default file name for Export Directly as PDF is now blank.

2021-08-30 Thread Steve Edmonds
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

Re: [libreoffice-users] Clipboard not working from keyboard

2021-08-14 Thread Steve Edmonds
On 13/08/2021 11:04, John Jason Jordan wrote: On Fri, 13 Aug 2021 08:23:57 +1200 Steve Edmonds dijo: Ctrl-Ins should copy, Shift-Ins should paste. Shift-del is like Ctl-x OK, that does work. However, it is a clumsy process because it requires both hands; the keys are on opposite corners

Re: [libreoffice-users] Clipboard not working from keyboard

2021-08-12 Thread Steve Edmonds
Ctrl-Ins should copy, Shift-Ins should paste. Shift-del is like Ctl-x Do you have Clipper active? On 13/08/2021 07:36, John Jason Jordan wrote: On Fri, 13 Aug 2021 07:05:54 +1200 Steve Edmonds dijo: Hi. Do they work in other applications like your mailer, what about Ctl-Ins and Sft-Ins

Re: [libreoffice-users] Clipboard not working from keyboard

2021-08-12 Thread Steve Edmonds
Hi. Do they work in other applications like your mailer, what about Ctl-Ins and Sft-Ins for copy and paste. steve On 13/08/2021 06:19, John Jason Jordan wrote: I currently have LO 7.1.4.2 on Xubuntu 2.04.2. The keyboard shortcuts for the clipboard do not work - Ctrl-c, Ctrl-x, Ctrl-v. To use

[libreoffice-users] Writer has reformatted tables with images after update.

2021-07-25 Thread Steve Edmonds
Hi I don't know if this issue is a bug or a new way of doing things in Writer. If it is a bug I believe it is related to https://bugs.documentfoundation.org/show_bug.cgi?id=140408 I have many documents created over the last few years and regularly edited with tables containing hundreds of

Re: [libreoffice-users] Writer Callout Style settings

2021-07-23 Thread Steve Edmonds
Thanks John and Regina for the help. I have found an efficient way to inset multiple formatted callouts. Insert and format the first one then copy/paste and edit the text for subsequent callouts. Steve On 24/07/2021 12:30, Regina Henschel wrote: Hi Steve, Steve Edmonds schrieb am 18.07.2021

Re: [libreoffice-users] Writer Callout Style settings

2021-07-23 Thread Steve Edmonds
rties are in inches. There is also a funny quirk where callouts become invisible (but still there) when the anchor is not in an appropriate place. Steve On 24/07/2021 08:18, John Kaufmann wrote: On 2021-07-18 17:05, Steve Edmonds wrote: Is it possible to set Writer callout text paragraph style (o

[libreoffice-users] Writer Callout Style settings

2021-07-18 Thread Steve Edmonds
Hi. Is it possible to set Writer callout text paragraph style (or default settings, if so where please. This is to avoid having to change the font and left hand offset in every line callout one at a time. Thanks, Steve -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

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

2021-05-18 Thread Steve Edmonds
and change the font.  It doesn't seem to do anything? On Wed, 2021-05-19 at 09:29 +1200, Steve Edmonds wrote: I just did a quick test, if you modify the style(s) you used and change the font there it will change your presentation. On 19/05/2021 05:38, Daffy Duck wrote: I guess my question

  1   2   3   4   5   6   7   8   9   10   >