Re: [libreoffice-users] Calc- don't show the decimal point

[James E Lang]

Hi Spencer,

My comment paragraphs begin with "[" and each, possibly extended, comment ends 
with "-- jl]".

-- 
Jim

-Original Message-
From: Spencer Graves <spencer.gra...@prodsyse.com>
To: users@global.libreoffice.org
Sent: Tue, 19 Jan 2016 8:37
Subject: Re: [libreoffice-users] Calc- don't show the decimal point

You need Format > Cells > Numbers: Format code = 

With this, 0.1 appears as "" and 0.6 as "0001".

[He wants 0.1 to appear as "1000" and 0.6 as "6000".

[The first response he received is the most simple. Calc has no method to 
directly format numbers the way he wants them.

[He stated that he wants the trigonometric function values unchanged (as I 
understood him: directly usable in calculations without a finagle factor) but 
DISPLAYED without the decimal point character. Hiding the true value column and 
displaying with format "" a column with values ten thousand times the true 
value is by far his best solution as I see it. -- jl]

For more on this, see 
"https://help.libreoffice.org/Common/Number_Format_Codes;

[This does not address his issue which is to suppress the decimal point before 
the fractional part of the number. -- jl]

   Spencer Graves


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Brian Barker]

At 15:15 19/01/2016 -0500, Alek Solzhenitsyn wrote:

On 01/19/2016 11:36 AM, Spencer Graves wrote:

You need Format > Cells > Numbers: Format code = 
With this, 0.1 appears as "" and 0.6 as "0001".


That isn't what I want- the wrong answer.


No, it *is* what you want. Once you have multiplied by 1, your 
values will (presumably) have no fractional parts, so the rounding 
described as above, though accurate, will not be relevant. *Original* 
figures of 0.1000 and 0.6000 will appear, when multiplied, as 1000 
and 6000; it's only original figures of 0.1 and 0.6 (if they 
existed) that would appear, rounded, as  and 0001.


Brian Barker 



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Brian Barker]

At 23:20 19/01/2016 +, Tom Davies wrote:

I think the first cunning answer, to multiply by 1000, ...


Oh, the first answer was more cunning than that: it was to multiply 
by 1 (which works), not 1000 (which doesn't).


Brian Barker  



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Alek]

On 01/19/2016 11:36 AM, Spencer Graves wrote:
>
>
> On 1/19/2016 10:20 AM, Brian Barker wrote:
>> At 10:14 19/01/2016 -0500, Alek Solzhenitsyn wrote:
>>> Brian, I'm not smart.
>>
>> I'm not sure if you are being serious, but it's not a question of
>> being smart or not - so I don't accept that you are not. It's very
>> easy to miss ideas that may happen to occur to others.
>>
>> Brian Barker
>>
>
> You need Format > Cells > Numbers: Format code = 
>
>
> With this, 0.1 appears as "" and 0.6 as "0001".

That isn't what I want- the wrong answer.

>
>
> For more on this, see
> "https://help.libreoffice.org/Common/Number_Format_Codes;, which I
> found searching for "libreoffice calc display fractions without
> decimal point".
>
>
> I agree with Brian:  The foremost experts in any field may not be able
> to solve problems that "lesser" minds handle easily.  That's why a
> second opinion in medicine (or anything else) can be useful.
>
>
>   Spencer Graves
>
>



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Tom Davies]

Hi :)
I think the  first cunning answer, to multiply by 1000, then needs
Spencer's formatting in order to deal with the problem Brian
identified in his last paragraph, ie that of 123 needing to be shown
as 0123 to prevent it being mis-read or confusing.

I think that Brian was suggesting combining the "multiply by 1000"
into whatever formula creates the 4-decimal-place values in the first
place.  Doing so might help by avoiding the need for a 2nd calculation
that might then need to be hidden.

The formatting Spencer drew attention to was originally suggested by
Brian but kinda got ignored in this thread because the earlier part of
his answer had been somewhat flummoxing.

Anyway, i hope you have a "good enough" result by using some of the
answers in this thread!
Good luck and regards from
Tom :)



On 19 January 2016 at 20:15, Alek  wrote:
>
>
> On 01/19/2016 11:36 AM, Spencer Graves wrote:
>>
>>
>> On 1/19/2016 10:20 AM, Brian Barker wrote:
>>> At 10:14 19/01/2016 -0500, Alek Solzhenitsyn wrote:
 Brian, I'm not smart.
>>>
>>> I'm not sure if you are being serious, but it's not a question of
>>> being smart or not - so I don't accept that you are not. It's very
>>> easy to miss ideas that may happen to occur to others.
>>>
>>> Brian Barker
>>>
>>
>> You need Format > Cells > Numbers: Format code = 
>>
>>
>> With this, 0.1 appears as "" and 0.6 as "0001".
>
> That isn't what I want- the wrong answer.
>
>>
>>
>> For more on this, see
>> "https://help.libreoffice.org/Common/Number_Format_Codes;, which I
>> found searching for "libreoffice calc display fractions without
>> decimal point".
>>
>>
>> I agree with Brian:  The foremost experts in any field may not be able
>> to solve problems that "lesser" minds handle easily.  That's why a
>> second opinion in medicine (or anything else) can be useful.
>>
>>
>>   Spencer Graves
>>
>>
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? 
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Spencer Graves]

On 1/19/2016 7:55 AM, Alek wrote:

A calc sheet I've made has thousands of 4 place decimal numbers that
never go over .  (it's a cosine trig. figure)

The decimal place takes up space on the sheet(s) and isn't needed as the
sheet will be printed out as a PDF.

Can someone please tell me how to get rid of the decimal point and so
that the resulting number doesn't change?



  Multiply by 1 then display as integer?


  You can do this in an extra display column beside the column with 
the number you want to display, then Format > Column > Hide the column 
with the number you want to display.  This is not as emotionally 
satisfying as doing it with a special format code, but I don't know the 
latter, and this will work.  Hope this helps. Spencer Graves


Alek





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Brian Barker]

At 08:09 19/01/2016 -0600, Spencer Graves wrote:

On 1/19/2016 7:55 AM, Alek Solzhenitsyn wrote:
A calc sheet I've made has thousands of 4 place decimal numbers 
that never go over .  (it's a cosine trig. figure). The decimal 
place takes up space on the sheet(s) and isn't needed as the sheet 
will be printed out as a PDF. Can someone please tell me how to get 
rid of the decimal point and so that the resulting number doesn't change?


Multiply by 1 then display as integer?

You can do this in an extra display column beside the column with 
the number you want to display, then Format > Column > Hide the 
column with the number you want to display. This is not as 
emotionally satisfying as doing it with a special format code, but I 
don't know the latter, and this will work.


Even simpler, why not construct your spreadsheet so that it handles 
the numbers you really want instead of those that you don't? Change 
your formulae - surely a simple task? - to calculate with up-to- 
four-digit integers instead of the fractional ones you have. You will 
find the number 1 helpful. You can easily *think* 0.1234 when you 
read "1234" in a cell.


You will want to format the cells as "" so that what you think of 
as 0.0123 will appear as "0123" and not "123".


I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Alek]

On 01/19/2016 09:09 AM, Spencer Graves wrote:
>
>
> On 1/19/2016 7:55 AM, Alek wrote:
>> A calc sheet I've made has thousands of 4 place decimal numbers that
>> never go over .  (it's a cosine trig. figure)
>>
>> The decimal place takes up space on the sheet(s) and isn't needed as the
>> sheet will be printed out as a PDF.
>>
>> Can someone please tell me how to get rid of the decimal point and so
>> that the resulting number doesn't change?
>
>
>   Multiply by 1 then display as integer?
>
That's perfect.

Thanks,

Alek


>
>   You can do this in an extra display column beside the column
> with the number you want to display, then Format > Column > Hide the
> column with the number you want to display.  This is not as
> emotionally satisfying as doing it with a special format code, but I
> don't know the latter, and this will work.  Hope this helps. Spencer
> Graves
>>
>> Alek
>>
>>
>
>



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Alek]

On 01/19/2016 09:41 AM, Brian Barker wrote:
> At 08:09 19/01/2016 -0600, Spencer Graves wrote:
>> On 1/19/2016 7:55 AM, Alek Solzhenitsyn wrote:
>>> A calc sheet I've made has thousands of 4 place decimal numbers that
>>> never go over .  (it's a cosine trig. figure). The decimal place
>>> takes up space on the sheet(s) and isn't needed as the sheet will be
>>> printed out as a PDF. Can someone please tell me how to get rid of
>>> the decimal point and so that the resulting number doesn't change?
>>
>> Multiply by 1 then display as integer?
>>
>> You can do this in an extra display column beside the column with the
>> number you want to display, then Format > Column > Hide the column
>> with the number you want to display. This is not as emotionally
>> satisfying as doing it with a special format code, but I don't know
>> the latter, and this will work.
>
> Even simpler, why not construct your spreadsheet so that it handles
> the numbers you really want instead of those that you don't? Change
> your formulae - surely a simple task? - to calculate with up-to-
> four-digit integers instead of the fractional ones you have. You will
> find the number 1 helpful. You can easily *think* 0.1234 when you
> read "1234" in a cell.
>
> You will want to format the cells as "" so that what you think of
> as 0.0123 will appear as "0123" and not "123".
>
> I trust this helps.
>
> Brian Barker

Brian, I'm not smart.



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Brian Barker]

At 10:14 19/01/2016 -0500, Alek Solzhenitsyn wrote:

Brian, I'm not smart.


I'm not sure if you are being serious, but it's not a question of 
being smart or not - so I don't accept that you are not. It's very 
easy to miss ideas that may happen to occur to others.


Brian Barker  



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Spencer Graves]

On 1/19/2016 10:20 AM, Brian Barker wrote:

At 10:14 19/01/2016 -0500, Alek Solzhenitsyn wrote:

Brian, I'm not smart.


I'm not sure if you are being serious, but it's not a question of 
being smart or not - so I don't accept that you are not. It's very 
easy to miss ideas that may happen to occur to others.


Brian Barker



You need Format > Cells > Numbers: Format code = 


With this, 0.1 appears as "" and 0.6 as "0001".


For more on this, see 
"https://help.libreoffice.org/Common/Number_Format_Codes;, which I found 
searching for "libreoffice calc display fractions without decimal point".



I agree with Brian:  The foremost experts in any field may not be able 
to solve problems that "lesser" minds handle easily.  That's why a 
second opinion in medicine (or anything else) can be useful.



  Spencer Graves


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted