[libreoffice-users] LO 3.5.1 Java weirdness on OSX

Hi all. I've noticed some strange behaviour with LO 3.5 LO 3.5.1.2 that I installed this morning. I was using Base and since I had some difficulties and slow processing I followed a discussion on how to get Java memory increased and also select different Java versions. Before this, I didn't

[libreoffice-users] LO 3.5.1 Java weirdness on OSX

This email didn't show up in the digest or in archive so I'm sending it again. If it did appear and I can't find it, I apologize in advance. --- Hi all. I've noticed some strange behaviour with LO 3.5 LO 3.5.1.2 that I installed this morning. I was using Base and since I had some difficulties

[libreoffice-users] Re: LO 3.5.1 Java weirdness on OSX

Thank you, Alex. On 26.03.2012 5:16 , Alexander Thurgood wrote: Le 22/03/12 15:48, bunk3m a écrit : Hi, LO doesn't find any Java version except for one. I don't think it can anymore automatically (but I'm prepared to be proven wrong ;-)), at least not on Mac, the handling of the Java

[libreoffice-users] Re: Base stand alone

On Thu, 24 Mar 2011 13:10:39 +0100, Andreas Sägerville...@t-online.deam 24.03.2011 12:44, Renato Pontefice wrote:Hi,I'm very very new to Libreoffice (about 5 minutes:-))I have to create a DB. Of course I will use Base, but:- I'm wondering if it could be published as a stand alone. I

[libreoffice-users] Positive result story to share

Normally the list is about problems and solutions. So I wanted to share something with everyone that is positive. My son has a school supplied laptop that only has MS Office (XP). It is locked down so tight that we can't install anything onto it. He prepared his Powerpoint presentation (in

[libreoffice-users] LO 3.4.0 language pack for EN-US?

I was going to download v3.4.0 but the site shows null for the language pack (en-us). I checked the Other ways to download but couldn't find it. Where is it? Thanks. Bunkem -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to

[libreoffice-users] date acceptance patterns not sticking

Libreoffice is driving me nuts. I am in Canada. UI is set to English US; Locale settings to English Canada and Default Currency is CAD. I have my Mac set dates to dd.mm.. (OSX 10.9.x) For some reason Libreoffice (4.3.1.2) will only accept dates in the -MM-DD format. I'm happy that

[libreoffice-users] Update Java and LO to 4.4.1002 and now LO won't start

Hello.I updated my Java to Java 8u40 and deleted the old Java 7 from /Library/Java/and updated LO to the recent 4.4.1002 for Mac 64 bit.  I am using OSX 10.9.5I tried to start LO and it won't complete the start saying that I need to install Java 6 from Apple.  When I click on Not

[libreoffice-users] LO 4.4 is supposed to import Pagemaker files? How?

I was all excited by the recent announcement that LO can open a number of older Mac file formats and Pagemaker files. I am running the Mac 64 bit version of LO 4.4. (OSX 10.9.5) So I wanted to finally convert a number of older Pagemaker 6.5 files to something useable. I searched the docs

Re: [libreoffice-users] Re: LO 4.4 is supposed to import Pagemaker files? How?

On 14.05.2015 13:37 , Andreas Säger wrote: Am 14.05.2015 um 19:18 schrieb Brad Rogers: Unless I've misunderstood what bunk3m wrote, that resulted in a General I/O error. Ooops. Then LibreOffice can not open that file because the file is not a pagemaker file, a corrupted pagemaker file

Re: Re: [libreoffice-users] Can't open LibreOffice on Mac

Larry, Usually you can also "right-click" on the Libreoffice Application and select "Open" from the menu. It will ask you if you really want to do that. If you select "Yes", Libreoffice should open. B. On 06.11.2015 14:04, Italo Vignoli wrote: On 06/11/15 19:41, Larry Gusaas wrote:

[libreoffice-users] Calc multiplication & division formulas acting strangely (Mac 5.2.3)

Today I created a spreadsheet in 5.2.3 (Mac) and each time I try to do a multiplication with a decimal, Calc gives me a #NAME?. In cell A1R1 =4*1.5 gives #NAME? In each spreadsheet that I've opened I get the same problem. When I do 4*150%, Calc changes the formula to =4*1.5 and gives 6. Then

Re: [libreoffice-users] Calc multiplication & division formulas acting strangely (Mac 5.2.3)

On 2016-11-06 8:43 PM, "Brian Barker" wrote: At 20:06 06/11/2016 -0500, Bonly Noname wrote: Today I created a spreadsheet in 5.2.3 (Mac) and each time I try to do a multiplication with a decimal, Calc gives me a #NAME?. In cell A1R1 =4*1.5 gives #NAME? In each

Re: [libreoffice-users] Calc multiplication & division formulas acting strangely (Mac 5.2.3)

Thanks again Brian. Appreciate that you take time to comment and help! Some additional comments inline below. On 7 November 2016 at 23:53, Brian Barker wrote: > At 14:20 07/11/2016 -0500, Bonly Noname wrote: > >> On 2016-11-06 8:43 PM, "Brian Barker"

[libreoffice-users] Formula calculation differences between LO 5.3 and Excel

When I open most Excel documents I get a message (as per attached screenshot) that says "This document was last saved by Excel. Some formula cells may produce different results when recalculated. Do you want to recalculate all formula cells now?" Where do I find out what these calculation

[libreoffice-users] Re: Subject: Digest of users@global.libreoffice.org issue 2704 (52154-52162)

Thanks again and regards, B. On 29.07.2017 06:00, rb.hensc...@t-online.de wrote: Hi, bunk3m schrieb: Thank you Jorge. I have checked this. The Mac settings are OK. It works with Excel fine and Apple Numbers. Mac settings are to show decimal as "." I have some LO Calc sheets that

[libreoffice-users] Re: Subject: Digest of users@global.libreoffice.org issue 2704 (52154-52162)

again! Hurrah! If you know what changes cause LO to require a restart to affect the change, I would appreciate knowing. Then if this happens again I'll know what to do. Thank you Jorge, Regina and Brian! Cheers! B. On 29.07.2017 15:57, bunk3m wrote: Hello Regina and Jorge, Thank you

[libreoffice-users] Calc - Invalid name error - help request

I'm having a struggle with Calc. I trying to migrate over from Excel but have a problem. When I type [=1+1.5] into a cell, I get "Invalid Name" error. If I save the file as an xlsx and open in Excel it calculates OK and give 2.5. If I then open the xlsx in LO, it still says "Invalid Name".

Re: [libreoffice-users] Calc - Invalid name error - help request

ry to find how is it define it in you Mac. Probably is as " , " and you have to change to " . " as you use it in Canada. Regards, Jorge Rodríguez El 28/07/2017 a las 14:50, bunk3m escribió: I'm having a struggle with Calc. I trying to migrate over from Excel but have a

Re: [libreoffice-users] Re: Letter page format size prints portrait pages as landscape on OS X

Alex, Apologies if this has already been answered as I only get the daily digest. In Canada our standard is letter (8.5" x 11"), legal (8.5" x 14"), tabloid (11" x 17"). Because we use the metric system, PCs usually default to cm. This is totally useless since our paper standards are in

Re: Re: [libreoffice-users] MacOS 64 bit 5.4.1 torrent issue

with checksums. You can check the torrent (and direct download) against these for validity. Steve On 01/09/17 06:23, bunk3m wrote: Hi all, I downloaded the new release this morning via torrent.  When I started the LO, LittleSnitch indicated that it tried to connect to centrum.cz and bbx-fe-hp

[libreoffice-users] MacOS 64 bit 5.4.1 torrent issue

Hi all, I downloaded the new release this morning via torrent. When I started the LO, LittleSnitch indicated that it tried to connect to centrum.cz and bbx-fe-hp-pool.centrum.cz. I checked out the sites and I can't figure out why LO would need to connect there. I thought it strange so I

[libreoffice-users] Re: External Hard Drives - to save my LO and other content

Steve, You may find following two articles interesting regarding drive failures. I find the Backblaze info useful but to provide balance, a contrasting view in second link. https://www.backblaze.com/blog/hard-drive-failure-rates-q1-2017/

Re: [libreoffice-users] Calc 5.x Mac - syntax to link cells in two spreadsheets?

eated by Win & Linux versions of LO and OO,there is no transformation and the linking works. If I use Mac LO and select in the cell, highlight and copy the link formula, and paste the formula into another cell, Mac LO transposes the formula and ERROR. I think we've found a bug. B.

[libreoffice-users] Calc 5.x Mac - syntax to link cells in two spreadsheets?

linking spreadsheets in Excel for so long and it works. I'd appreciate any Mac specific guidance. Bunk3m. PS on Digest mode. Please cc me directly in addition to answering to the list. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/ge

Re: [libreoffice-users] Calc 5.x Mac - syntax to link cells in two spreadsheets?

in a cell in the first sheet, i.e =2* then click in the source cell in the second sheet, then click enter and it seems to work. steve On 30/10/17 07:42, bunk3m wrote: Hello all, I've been struggling with this one for a week now.  Google hasn't been my friend so far so thought I'd ask the user g

Re: [libreoffice-users] Calc 5.x Mac - syntax to link cells in two spreadsheets?

ct on the Mac where LO changes all the upper case letters to lower case, changes some of the characters ie. #, $ and ! are removed is it. steve On 31/10/17 11:36, bunk3m wrote: OK I've had some time to test this with the same spreadsheets on various versions of LO on Mac, LO on VM running Win &

Re: [libreoffice-users] Calc 5.x Mac - syntax to link cells in two spreadsheets?

ula syntax -> Excel A1." So may be check Menu/Tools/Options/LibreOffice/Formula/Formula options/Formula syntax Steve On 30/10/17 09:54, bunk3m wrote: Thank you for testing this, Steve. I tried what you suggested near the beginning of my testing and tried it again just now.  When I

Re: [libreoffice-users] Calc 5.x Mac - syntax to link cells in two spreadsheets?

using OO. This is beginning to look like a bug in LO 5.3 & 5.4. I will try OO 4.x and see if there it work also. And I will see if I have LO on a Linux VM image to see if the spreadsheet will work using Linux. B. On 30.10.2017 14:04, bunk3m wrote: Hi Steve, Thanks for your continued help

[libreoffice-users] Writer paragraph numbered list issue

Hi! Today I've had 2 frustrations with LO Writer (6.0.4 & 6.2a). To keep this shorter and easier to follow, I'm posting two topics This email has the second of those frustrations. I have a legal document that was originally a MS Word doc. I don't want to rebuild the complete document to

[libreoffice-users] Writer page numbering issue + numbered list issue

Hi! Today I've had 2 frustrations with LO Writer (6.0.4 & 6.2a). To keep this shorter and easier to follow, I'm posting two topics This email has one of those frustrations. I have a legal document that was originally a MS Word doc. I don't want to rebuild the complete document to fix page

Re: Re: [libreoffice-users] Writer paragraph numbered list issue

Thank you Robert. Unfortunately neither of these two options work. On 05.06.2018 01:57, Robert Großkopf wrote: Hi bunk3m, The document goes from paragraph 1 to 11 and then should have 11.1 to 11.9 but I end up with paragraph 1 to 20. Go to paragraph, which shows '12' Right Mouseclick

Re: [libreoffice-users] Re: Changing key board shortcuts in Mac LO Calc

On 25.01.2018 05:05, Alexander Thurgood wrote: Le 24/01/2018 à 18:51, bunk3m a écrit : Hi, Can someone let me know where I can find this in the documents or give me some help so I fix this? My unedcuated guess is that it has been hardcoded by some "well intentioned" UI-developer

[libreoffice-users] Changing key board shortcuts in Mac LO Calc

Hi. In LO 5.x the Calc keyboard shortcut to change between open documents followed the Mac UI standards. That means that when you use the keyboard shortcut [ ~ + CMD ] (tilde + command or Apple key) you switch between open documents. In LO 6.x Calc the [~+CMD] shortcut now shows the cell

Re: [libreoffice-users] Re: Changing key board shortcuts in Mac LO Calc

+~ In the end, I can learn something new but I really would like it to be consistent across LO. Right now Impress & Writer use CMD+~ but with Calc I can only switch between open windows by using the menu. That really screws up the workflow. I have logged a bug. B. On 26.01.2018 19:31, bu

[libreoffice-users] Missing bullet points in Notes view on Impress 6.x - How do I get them back?

Hi all. I have a presentation in Impress on LO 6.0 on the Mac. I'd like to print the "Notes" as part of my report but I am at a loss as to how I get the bullets to show up in the Notes view image. I suspect something in my template may have caused this but I can't figure it out and can't

Re: [libreoffice-users] Missing bullet points in Notes view on Impress 6.x - How do I get them back?

On 06.02.2018 00:48, Brian Barker wrote: At 10:38 05/02/2018 -0500, Bonly Noname wrote: I have a presentation in Impress on LO 6.0 on the Mac. I'd like to print the "Notes" as part of my report but I am at a loss as to how I get the bullets to show up in the Notes view image. I suspect

[libreoffice-users] Scripting LO

Hello. I see that there are a number of ways to script LO within the program itself, but is it possible to automate LO open file and save as odt, ods, odp? Something like Applescript used to be able to manipulate programs? For example, I have many old files in various formats like .doc,

Re: [libreoffice-users] Scripting LO

/ Best wishes, Drew On Sun, Dec 23, 2018 at 11:29 AM bunk3m <mailto:bun...@gmail.com>> wrote: Hello. I see that there are a number of ways to script LO  within the program itself, but is it possible to automate LO open file and save as odt, ods, odp?  Something like Ap

[libreoffice-users] Re: Does something like this exist for LO?

On 05.02.2019 14:05, Luuk wrote: On 5-2-2019 02:55, bunk3m wrote: On 04.02.2019 06:30, Luuk wrote: On 2-2-2019 21:53, bunk3m wrote: I have been wondering how to export my Google Map Timeline so I can capture my mileage driven without having to get the kml file for each individual day

[libreoffice-users] Does something like this exist for LO?

I have been wondering how to export my Google Map Timeline so I can capture my mileage driven without having to get the kml file for each individual day. Today I found this add-in for Excel (Don't have Excel anymore :-( ) that runs a VBA script to do exactly what I'm looking for.

Re: [libreoffice-users] Does something like this exist for LO?

On 04.02.2019 06:30, Luuk wrote: On 2-2-2019 21:53, bunk3m wrote: I have been wondering how to export my Google Map Timeline so I can capture my mileage driven without having to get the kml file for each individual day. Today I found this add-in for Excel (Don't have Excel anymore

[libreoffice-users] Calc link problem on Mac

I'm looking for some help in debugging an issue that I've had since LO 5.4 on Mac. (I've been using LO since it forked.) I'm now running LO 6.3alpha When I attempt to link a cell in one spreadsheet to another, the linking action using "=spreadsheet/cell location" transposes the link

[libreoffice-users] Base created from xlsx file - move to proper DB

Hello all. I thought I had gotten the data from a flat file (xlsx) into Base. I was trying to import and create a new database. My work requires my data to be in the company OneDrive. When I try to open the connected flat file, I get errors that the file location or parameters are not OK.

[libreoffice-users] Re: Base created from xlsx file - move to proper DB

On 18.03.2020 20:57, bunk3m wrote: Hello all. I thought I had gotten the data from a flat file (xlsx) into Base.  I was trying to import and create a new database. My work requires my data to be in the company OneDrive.  When I try to open the connected flat file, I get errors that the file

[libreoffice-users] Re: Base created from xlsx file - move to proper DB

is being used? On Thu, 19 Mar 2020 at 05:52, Alexander Thurgood wrote: > Le 19/03/2020 à 01:57, bunk3m a écrit : > > As Drew has said, you can use your existing flat file in several ways : > > 1) Go via the empty ODB file method to drag the linked XLSX sheet from > your first ODB

[libreoffice-users] Re: Base created from xlsx file - move to proper DB

Thank you Alex, Paulo and Drew. I didn't realize there were so many "bugs" still to work out. I'll stick with HSQLDB for now. I trust there will eventually be a way to migrate to the new DB in the future? On Thu, 19 Mar 2020 at 10:10, Alexander Thurgood wrote: > Le 19/03/2020 à

Re: [libreoffice-users] From Draw to Impress?

Thank you Regina. That list is so long, I never looked much below the second section so never got there. Once open in "ODF Drawing (Impress) (*.odg)", I see I can save the document as Presentation odp. Cool! Thanks! B. On 12.09.2020 17:24, Regina Henschel wrote:

[libreoffice-users] From Draw to Impress?

Hello all. I am really pleased with the PDF open & edit in Draw but was wondering how to get content from Draw into Impress without having to copy and paste. I couldn't find the my original presentation but had a pdf version of the presentation. So I opened it in Draw. That allowed me to

Re: Re: [libreoffice-users] [Calc] Keyboard shortcut to delete current row when focus on one of its cells?

Sorry for the late response, I'm on digest mode. While this isn't a one keyboard shortcut, you can do the following: I use the following to achieve the delete current row when in a cell. When in the cell, press shift+spacebar (highlight row) and then the ctrl+- (to delete row) B. On

Re: [libreoffice-users] Calc airithmetic snafu

Or perhaps leave the actual number in the first column and just use a cell format for the "km". i.e. 1) Leave 2.4 in the cell 2) ctrl+1 (cmd+1 mac) to open format cell 3) then in the Format Code type " km" behind the number format. And now your 2.4 will show "2.4 km" in the cell. And you can

[libreoffice-users] Rotated text on Line object?

Hello all, I need some help figuring out how to format text on a line. I'm using LO 7.6 Draw on Mac. Background: I have a chart with many text boxes that have text centred inside. The boxes have an outline. To show "flow" from one box to the next I have joined the boxes with lines with

[libreoffice-users] Bump -> Rotated text on Line object?

Hello all, As my message appears to have become lost, I am asking again. I need some help figuring out how to format text on a line. Is it possible to have text horizontal while the line drawn is at an angle? If yes, how? More details below. Using LO 7.6 Draw on Mac. Background: I have a

Re: [libreoffice-users] Customizing styles and keeping them in templates in Writer?

OK. I think I did. Please let me know if it didn't work properly. I hate gmail for trying to modify anything typical in an email. It's a piece of shit web software. :-) On Fri, 24 Nov 2023 at 15:08, bunk3m wrote: > Thank you Eric. > > I have a number of templates. For example,

[libreoffice-users] Customizing styles and keeping them in templates in Writer?

Hello, I'm using LO 7.6.2.1 on Win11 and Mac. I can't get the styles to work and stick in templates. I've used styles and templates in MS Word for 30 years before switching to LO in the past 5 years. I've read the help, Writer User Guide and Designing with LO 2nd Ed. and apparently have missed

Re: [libreoffice-users] Customizing styles and keeping them in templates in Writer?

x: Files/Templates/Manage Templates. Probably similar on Windows. > > On 11/24/23 14:22, bunk3m wrote: > > Hello, > > > > I'm using LO 7.6.2.1 on Win11 and Mac. > > > > I can't get the styles to work and stick in templates. I've used styles > > and templ