At 20:32 12/09/2018 -0400, Art Noname wrote:
It's a shame that I can't enter numbers with paste, or paste special.
You can. Use Paste Special... if necessary only if your data source
is itself a spreadsheet and the values risk arriving with a numerical
format associated.
The raw data is in
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
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
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,
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
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
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: W
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
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: Wed, 12 Sep 2018 00:36:02 -0400
> I h
I have a column of numbers I want to enter into a calc column.
One of the numbers is 127.700 (for instance).
So, I copy the number and paste it into the desired column. But, when I
go back and check the contents of the column, it reads 127.7 instead!!!
And, if I search the spreadsheet for
10 matches
Mail list logo