Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column

2018-09-12 Thread Michael D. Setzer II
On 12 Sep 2018 at 20:32, Art wrote: Subject:Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column To: users@global.libreoffice.org From: Art Date sent: Wed, 12 Sep 2018 20:32:00 -0400

Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column

2018-09-12 Thread Art
On 09/12/2018 12:45 PM, jomali wrote: > You seem to have a fundamental misunderstanding of how spreadsheets work. > When you enter a number into a numeric cell, the software converts it into > an internal format, which it then displays in the format you specify for > the cell. It does not remember

[libreoffice-users] android calendar dates

2018-09-12 Thread James
I backed up the calendar on my android phone. It is CSV and I want to import it into Calc. It has these numbers which I think are the dates. Does anyone know how to convert then to Calc dates? 1459397923718 1427831701482 1459397923718 1491348608631 1526254831608 -- To unsubscribe e-mail to:

Re: [libreoffice-users] systray quickstarter icon

2018-09-12 Thread Philip Jackson
On 12/09/18 20:30, Ricardo Berlasso wrote: > El mié., 12 sept. 2018 a las 18:48, Philip Jackson (< > philip.jack...@nordnet.fr>) escribió: > >> I've just moved from UbuntuStudio 1604 to 1804 which has taken me from >> LO 5.1.6.2 to 6.0.3.2 >> >> I can't find the option to use the systray

Re: [libreoffice-users] systray quickstarter icon

2018-09-12 Thread Ricardo Berlasso
El mié., 12 sept. 2018 a las 18:48, Philip Jackson (< philip.jack...@nordnet.fr>) escribió: > I've just moved from UbuntuStudio 1604 to 1804 which has taken me from > LO 5.1.6.2 to 6.0.3.2 > > I can't find the option to use the systray quickstarter icon in this > version. It used to be under the

[libreoffice-users] Solved: Export as PDF Error

2018-09-12 Thread dCipher
Hi I was using the StoreAsURL() but should have been using the StoreToRL() function. It all works fine now. Simon -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Export as PDF Error

2018-09-12 Thread dCipher
Hi I am able to save documents in "doc" or "odf" format using automation from Microsoft Visual FoxPro but when I add the "writer_pdf_Export" filter I get an error. OLE IDispatch exception code 1001 from [automation bridge] : com.sun.star.task.ErrorCodeIOException: SfxBaseModel::impl_store

[libreoffice-users] systray quickstarter icon

2018-09-12 Thread Philip Jackson
I've just moved from UbuntuStudio 1604 to 1804 which has taken me from LO 5.1.6.2 to 6.0.3.2 I can't find the option to use the systray quickstarter icon in this version. It used to be under the Tools > Options > LO > Memory but the whole memory section of the options seems to have gone. Is this

Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column

2018-09-12 Thread jomali
You seem to have a fundamental misunderstanding of how spreadsheets work. When you enter a number into a numeric cell, the software converts it into an internal format, which it then displays in the format you specify for the cell. It does not remember the form in which you entered it. Thus,

[libreoffice-users] Re: How to access ConvertToURL from automation?

2018-09-12 Thread dCipher
Hi I read through the link you provided but did not find anything about the ConvertToURL function. Simon -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column

2018-09-12 Thread Brian Barker
At 00:36 12/09/2018 -0400, Art Noname wrote: I have a column of numbers I want to enter into a calc column. That may be your first mistake: these may not be numbers. Read on. One of the numbers is 127.700 (for instance). So, I copy the number and paste it into the desired column. But, when I

Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column

2018-09-12 Thread Dave Howorth
On Wed, 12 Sep 2018 02:44:26 -0400 Art wrote: > It seems that the software is ignoring zeros to the right of the > decimal point. I'm listing frequencies in Megahertz, so the zeros to > the right of the decimal point are significant. I wish I could post > my spreadsheet somewhere, I do know

Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column

2018-09-12 Thread Michael D. Setzer II
For the formatted display to work, the cells have to be formated to show the decimal places to the degree you want. I have the column set to show just 2 decimal places. So 5 of the cells show 1.08 though the raw numbers are actually slightly different. So, if you set the columns to use the

Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column

2018-09-12 Thread Art
On 09/12/2018 01:09 AM, Michael D. Setzer II wrote: > On 12 Sep 2018 at 0:36, Art wrote: > > To: users@global.libreoffice.org > From: Art > Subject: [libreoffice-users] can't prevent Calc from > modifying the number I type into a column > Date sent: