Just think if you found a genuine bug and had to file a bug report: "The
bug is demonstrated in the attached Calc file. To reproduce the bug,
download the file then stick a length of white adhesive tape on your
monitor ..."
The bug title? "Calc failure when adhesive tape obscures partial column"
of course...
Jonathan Knight wrote:
What a brilliant idea! You know for a lot less trouble, I could just
stick a piece of tape down the montior to cover up those cents!!!!! :-)
----- Original Message ----
From: kevin johnston <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent: Saturday, December 1, 2007 12:08:02 AM
Subject: Re: [users] Calc: Format/Formula help
The fundamental restriction is that a cell in a spreadsheet can contain
a value or it can contain a formula. A single cell cannot contain both a
value and a formula using that value to construct a *different* value
for display.
But I have an idea. I don't claim it's pretty, and I won't be offended
if you recoil in disgust. But it accomplishes *strictly* what you
requested: Specifically, column A contains the exact dollars and cents
value, without displaying the cents.
Let's assume for the moment that numeric values are right-justified.
(This is the default for numeric values.) Let's *also* assume that you
*always* enter a decimal and two cents digits, even for round dollar values.
You could enter all your numbers in column A, and cover the right hand
margin of column A with a white rectangle that just happens to be the
exact width of a decimal and two digits.
Now in column B you can use your MOD formula to display the hidden cents
digits.
If you ever tell anyone this was my suggestion, I will deny it. Mail
headers are *so* easy to forge. Next time, think carefully what you ask
for. :)
Jonathan Knight wrote:
That's what I was trying to avoid. Was hoping there is a formatting solution
for the whole dollars.
I don't want to move the value to another cell since it's a standard
form we use.
Anyway, thanks for the input!
----- Original Message ----
From: Joe Conner <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent: Friday, November 30, 2007 2:04:03 PM
Subject: Re: [users] Calc: Format/Formula help
Jonathan Knight wrote:
<<SNIP>>
That part works great! Only problem is I still see the cents in Column A. I
tried to change the
format to zero decimal places, but it rounds the value! Not what I
want. Anyone have any ideas for formatting Column A to just show the
whole dollar amount entered?
<<SNIP>>
The obvious first solution is to move to using columns B and C for the
whole number and fraction with the raw value in column A.
Then in column B you can have =(A1 - C1). and in column C you can have
=IF(ISBLANK(A1);"";100*MOD(A1;1)).
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]