Re: [libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

2021-05-11 Thread Michael D. Setzer II
On 11 May 2021 at 13:24, Philip Jackson wrote:

Subject:Re: [libreoffice-users] Calc: Formatting cell 
with decimal point but
no decimal digits
To: users@global.libreoffice.org
From:   Philip Jackson 
Date sent:  Tue, 11 May 2021 13:24:26 +0200

> On 11/05/2021 03:22, Joel Roth wrote:
> >> Using LibreOffice 7.0.5.2 on macOS High Sierra (10.13.6), setting the
> >> number format to "#,##0\." (without the quotes, of course) works for me.
> >> ("#,##0.." also works, but that's too bizarre.;-)
> >
> > On my version (6.1.5) both of these formats display the cell
> > contents with a trailing decimal point, but with this
> > formatting, inputting 123.45 results in cell content 12345.
> 
> This thread caught my eye and I can't imagine the use case for displaying the 
> digital point as the OP wishes - but I gave his model a try as I did also 
> with the two expressions proposed by Chuck. I am using Calc 6.4.7.2 in Ubuntu 
> 20.04.2  The results were surprising.
> 
> I entered 123.59 in some cells in 3 columns formatted as: -
> 
> 1) Numbers #,##0"."
> 
> 2) Numbers #,##0\.
> 
> 3) Numbers  #,##0..
> 
> All three columns then displayed my entries as "124."   ie, rounded up and 
> with a final "."
> 
> But, when I entered 123.59 into other empty cells in those 3 pre-formatted 
> columns, my new entries were displayed as "12,359." in each case.
> 
> So applying the format to an already entered number gives a final "." - I 
> don't know whether the rounding up is acceptable or not. But I imagine the OP 
> wants to enter his number into cells that already have his format applied.
> 
> Curiously, when I selected my 3 columns and attempted to return to 
> 'normality' by formatting the cells to Numbers > General, nothing happened. I 
> had to change to some other format than Number (eg date) and then back to 
> numbers-general to get a result.
> 
> When Numbers-General was eventually restored, the "124."  entries were 
> returned to their original states of "123.59" but those entries applied to 
> the pre-formatted columns and which then displayed as "12,359." became 
> "12359" under the restored numbers-general regime.
> 
> Philip
> 

When I saw the original message my though was that the 
person made a typo and had actually used #,##0"," 
instead of #,##0"."

But waited for someone to come up with another 
reason?? Would just be one key off.


> 
> 
> -- 
> 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: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
> 


++
 Michael D. Setzer II - Computer Science Instructor 
(Retired) 
 mailto:mi...@guam.net
 mailto:msetze...@gmail.com
 Guam - Where America's Day Begins
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
++




-- 
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy



Re: [libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

2021-05-11 Thread Philip Jackson

On 11/05/2021 03:22, Joel Roth wrote:

Using LibreOffice 7.0.5.2 on macOS High Sierra (10.13.6), setting the
number format to "#,##0\." (without the quotes, of course) works for me.
("#,##0.." also works, but that's too bizarre.;-)


On my version (6.1.5) both of these formats display the cell
contents with a trailing decimal point, but with this
formatting, inputting 123.45 results in cell content 12345.


This thread caught my eye and I can't imagine the use case for displaying the 
digital point as the OP wishes - but I gave his model a try as I did also with 
the two expressions proposed by Chuck. I am using Calc 6.4.7.2 in Ubuntu 
20.04.2  The results were surprising.

I entered 123.59 in some cells in 3 columns formatted as: -

1) Numbers #,##0"."

2) Numbers #,##0\.

3) Numbers  #,##0..

All three columns then displayed my entries as "124."   ie, rounded up and with a final 
"."

But, when I entered 123.59 into other empty cells in those 3 pre-formatted columns, my 
new entries were displayed as "12,359." in each case.

So applying the format to an already entered number gives a final "." - I don't 
know whether the rounding up is acceptable or not. But I imagine the OP wants to enter 
his number into cells that already have his format applied.

Curiously, when I selected my 3 columns and attempted to return to 'normality' by 
formatting the cells to Numbers > General, nothing happened. I had to change to 
some other format than Number (eg date) and then back to numbers-general to get a 
result.

When Numbers-General was eventually restored, the "124."  entries were returned to their original states of 
"123.59" but those entries applied to the pre-formatted columns and which then displayed as 
"12,359." became "12359" under the restored numbers-general regime.

Philip



--
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy



Re: [libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

2021-05-10 Thread Joel Roth
On Mon, May 10, 2021 at 05:18:46PM -0700, Chuck Spalding wrote:
> Using LibreOffice 7.0.5.2 on macOS High Sierra (10.13.6), setting the
> number format to "#,##0\." (without the quotes, of course) works for me.
> ("#,##0.." also works, but that's too bizarre. ;-)
 
On my version (6.1.5) both of these formats display the cell
contents with a trailing decimal point, but with this
formatting, inputting 123.45 results in cell content 12345.


> Chuck
> 
> On Mon, May 10, 2021 at 12:37 PM Joel Roth  wrote:
> 
> > On Mon, May 10, 2021 at 12:05:04AM -0600, Joe Conner wrote:
> > > In calc, you could format the cell as currency.
> >
> > Thanks, I tried this, but wasn't able to display a terminal
> > decimal point.
> >
> > > On 5/9/21 3:36 PM, Joel Roth wrote:
> > > > Hi list,
> > > >
> > > > I'd like to input 123.45 and format it with a decimal point
> > > > but no decimal digits, in this example "123." . Previously I
> > > > used the formatting code #,##0"." but now it causes an input
> > > > of 123.45 to be received as 12,345, losing the decimal.
> > > >
> > > > Any ideas?
> > > >
> > > > Thanks in advance.
> >
> [snip]

-- 
Joel Roth

-- 
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy



Re: [libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

2021-05-10 Thread Chuck Spalding
Using LibreOffice 7.0.5.2 on macOS High Sierra (10.13.6), setting the
number format to "#,##0\." (without the quotes, of course) works for me.
("#,##0.." also works, but that's too bizarre. ;-)

Chuck

On Mon, May 10, 2021 at 12:37 PM Joel Roth  wrote:

> On Mon, May 10, 2021 at 12:05:04AM -0600, Joe Conner wrote:
> > In calc, you could format the cell as currency.
>
> Thanks, I tried this, but wasn't able to display a terminal
> decimal point.
>
> > On 5/9/21 3:36 PM, Joel Roth wrote:
> > > Hi list,
> > >
> > > I'd like to input 123.45 and format it with a decimal point
> > > but no decimal digits, in this example "123." . Previously I
> > > used the formatting code #,##0"." but now it causes an input
> > > of 123.45 to be received as 12,345, losing the decimal.
> > >
> > > Any ideas?
> > >
> > > Thanks in advance.
>
[snip]

-- 
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: [libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

2021-05-10 Thread Joel Roth
On Mon, May 10, 2021 at 12:05:04AM -0600, Joe Conner wrote:
> In calc, you could format the cell as currency.

Thanks, I tried this, but wasn't able to display a terminal
decimal point. 

> On 5/9/21 3:36 PM, Joel Roth wrote:
> > Hi list,
> > 
> > I'd like to input 123.45 and format it with a decimal point
> > but no decimal digits, in this example "123." . Previously I
> > used the formatting code #,##0"." but now it causes an input
> > of 123.45 to be received as 12,345, losing the decimal.
> > 
> > Any ideas?
> > 
> > Thanks in advance.
> > 
> > 
> 
> -- 
> 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: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
Joel Roth

-- 
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy



[libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

2021-05-10 Thread Mike Flannigan


Type
locale
in a terminal.  What locale are you?
I am 'en_US'.

This works for me:
Type 123.45 in a cell
Highlight the cell
Format - Cells - 'Numbers' tab -
Make 'Decimal places:' under Options zero (0).


Mike



On 5/10/21 1:04 AM, users+h...@global.libreoffice.org wrote:

Hi list,

I'd like to input 123.45 and format it with a decimal point
but no decimal digits, in this example "123." . Previously I
used the formatting code #,##0"." but now it causes an input
of 123.45 to be received as 12,345, losing the decimal.

Any ideas?

Thanks in advance.



--
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: [libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

2021-05-09 Thread Joe Conner

In calc, you could format the cell as currency.

On 5/9/21 3:36 PM, Joel Roth wrote:

Hi list,

I'd like to input 123.45 and format it with a decimal point
but no decimal digits, in this example "123." . Previously I
used the formatting code #,##0"." but now it causes an input
of 123.45 to be received as 12,345, losing the decimal.

Any ideas?

Thanks in advance.




--
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


[libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

2021-05-09 Thread Joel Roth


Hi list,

I'd like to input 123.45 and format it with a decimal point
but no decimal digits, in this example "123." . Previously I
used the formatting code #,##0"." but now it causes an input
of 123.45 to be received as 12,345, losing the decimal. 

Any ideas? 

Thanks in advance.


-- 
Joel Roth

-- 
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy