https://bz.apache.org/ooo/show_bug.cgi?id=119374
orcmid <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #5 from orcmid <[email protected]> --- (In reply to damjan from comment #4) > (In reply to damjan from comment #3) > > AOO behaves exactly like Excel here: negatives times are invalid, and > > anything over 24 day wraps around. So ODFF and Excel are incompatible when > > it comes to the time function. What to do? > > I meant anything over 24 hours = 1 day wraps around. I think the problem is with the term "fraction of the day" in the OpenFormula specification, which means the value would be non-negative and less than (or maybenot more than) 1.0. Let's look closer into this. The issue is pretty old and we might need to see what has happened with ODF in the meantime as well. -- You are receiving this mail because: You are the assignee for the issue.
