You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/04/07 21:38:17 UTC
[Issue 124620] New: Doing math useing value of NOW()
https://issues.apache.org/ooo/show_bug.cgi?id=124620
Issue ID: 124620
Issue Type: DEFECT
Summary: Doing math useing value of NOW()
Product: Calc
Version: 4.0.1
Hardware: PC
OS: Windows XP
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: programming
Assignee: issues@openoffice.apache.org
Reporter: rhays@galvestonbay.net
You can multiply (*) and divide (/) the output of NOW() but you cannot add (+)
or subtract(-) to or from it.
Robert Hays
rhays@galvestonbay.net
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124620] Doing math useing value of NOW()
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124620
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |elish@apache.org
Latest|--- |4.1-dev
Confirmation on| |
Ever confirmed|0 |1
OS|Windows XP |All
Severity|normal |minor
--- Comment #1 from Edwin Sharp <el...@apache.org> ---
multiply uses datevalue
divide uses datevalue
add adds to days
subtract removes days
AOO410m14(Build:9760) - Rev. 1585331
2014-04-07_04:11:07 - Rev. 1585379
Debian
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124620] Doing math useing value of NOW()
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124620
--- Comment #5 from Edwin Sharp <el...@apache.org> ---
Is your desired calculation successful with an older version of OpenOffice or a
different spreadsheet program ?
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124620] Doing math useing value of NOW()
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124620
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needmoreinfo
Status|RESOLVED |REOPENED
Resolution|NOT_AN_ISSUE |---
--- Comment #7 from Edwin Sharp <el...@apache.org> ---
reopened
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124620] Doing math useing value of NOW()
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124620
--- Comment #3 from Edwin Sharp <el...@apache.org> ---
Bug 1: No error message for what you call "never be a senseful date".
Bug 2: No documented help for what you call "right defined behaviour".
IMHO all four operations should result in error message.
Now()+integer -> increase day ?
Now()+decimal -> increase time ?
"Assumption is the mother of all fuckups" :)
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124620] Doing math useing value of NOW()
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124620
--- Comment #9 from Robert Hays <rh...@galvestonbay.net> ---
(In reply to Edwin Sharp from comment #7)
> reopened
The more I ponder on this issue the more I realize that what I was trying to do
is just not practical, mainly because of fractions and there is no format for
Hours. There is a format for DAYS & TIME but not for Hours, minutes or
seconds.
Your suggestion: did the trick with the added benefit of the date.
Let in cell B1 you X# hours.
So you have simply to calculate:
=NOW()+B1/24 - because 1 day = 24 hours
Format the cell with "DD/MM/YYYY HH:MM:SS".
Thanks ever so much for the help, maybe some day someone will add a format for
HOURS just for the hell of it.
Robert (Bob)
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124620] Doing math useing value of NOW()
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124620
--- Comment #2 from mroe <mr...@gmx.net> ---
> multiply uses datevalue
> divide uses datevalue
The result of multiply or divide a date would never be a senseful date.
> add adds to days
> subtract removes days
Yes, if you add/subtract integers > 0.
Adding/subtracting Values 0 < x < 1 change the time.
(If you doing this in one formula like =NOW()+2 you have to format the cell
with a date format.)
This is the right defined behaviour. Where is the DEFECT?
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124620] Doing math useing value of NOW()
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124620
--- Comment #8 from Robert Hays <rh...@galvestonbay.net> ---
(In reply to Edwin Sharp from comment #7)
> reopened
The more I ponder on this issue the more I realize that what I was trying to do
is just not practical, mainly because of fractions and there is no format for
Hours. There is a format for DAYS & TIME but not for Hours, minutes or
seconds.
Your suggestion: did the trick with the added benefit of the date.
Let in cell B1 you X# hours.
So you have simply to calculate:
=NOW()+B1/24 - because 1 day = 24 hours
Format the cell with "DD/MM/YYYY HH:MM:SS".
Thanks ever so much for the help, maybe some day someone will add a format for
HOURS just for the hell of it.
Robert (Bob)
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124620] Doing math useing value of NOW()
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124620
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |RESOLVED
Resolution|--- |NOT_AN_ISSUE
--- Comment #12 from Edwin Sharp <el...@apache.org> ---
I think error messages and better help are appropriate, but you are the boss :)
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124620] Doing math useing value of NOW()
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124620
mroe <mr...@gmx.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |RESOLVED
Resolution|--- |NOT_AN_ISSUE
--- Comment #6 from mroe <mr...@gmx.net> ---
(In reply to Robert Hays from comment #4)
> Just one of the ways I was trying to use it is:
> I have a crop planted that is 45% ready to harvest, this would calcu. out to
> X# of hours left, by adding this x# of hours to NOW() I would have the exact
> time of day I would need to go harvest it, but this is not to be ,,,,, so
> sad.
> Sorry to have bothered you guys with this.
You have to look how a spreadsheet is working.
Let in cell B1 you X# hours.
So you have simply to calculate:
=NOW()+B1/24 - because 1 day = 24 hours
Format the cell with "DD/MM/YYYY HH:MM:SS".
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124620] Doing math useing value of NOW()
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124620
--- Comment #10 from Edwin Sharp <el...@apache.org> ---
With all due respect, I just don't understand you.
In comment 0 you talk about multiply and divide.
In comment 4 you talk about hours addition.
In comment 8 you talk about hours format.
Next time, please discuss at:
https://forum.openoffice.org/en/forum/index.php
Please report issues here after reading:
https://wiki.openoffice.org/wiki/QA/HowToFileIssue
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124620] Doing math useing value of NOW()
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124620
--- Comment #4 from Robert Hays <rh...@galvestonbay.net> ---
Your response to this issue is extreamly disappointing, to me it is a fault and
always will be. When one cannot get the spread sheet to do ALL the math he
needs doing then he just might as well do it with pencil & paper in the first
place.
Just one of the ways I was trying to use it is:
I have a crop planted that is 45% ready to harvest, this would calcu. out to X#
of hours left, by adding this x# of hours to NOW() I would have the exact time
of day I would need to go harvest it, but this is not to be ,,,,, so sad.
Sorry to have bothered you guys with this.
Robert
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124620] Doing math useing value of NOW()
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124620
--- Comment #11 from Robert Hays <rh...@galvestonbay.net> ---
Well crap, at 83 yr.'s I should be entitled to a little bit of confusion. <G>
As far as I am concerned the issue is resolved, over and done with.
Thanks
Bob
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.