Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Time values entered in a formula are converted by OOoCalc to decimal numbers. | ||
---|---|---|---|
Product: | Calc | Reporter: | docpi <docpi> |
Component: | editing | Assignee: | AOO issues mailing list <issues> |
Status: | CONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | flibby05, issues |
Version: | OOo 1.1.4 | Keywords: | oooqa |
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Linux, all | ||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
docpi
2005-02-13 00:49:49 UTC
Hi, this is not a bug. The decimals displayed are used to calculate the sum. The number 1 represents 24 hours. All spreadsheets calculate with these numbers. Entering your formula into Excel will result in an Errormessage as Excel can't calculate with these values, they do not know that this is a time. So converting these inputs to decimals is even better as Excel and necessary. Closing wontfix. Frank closed wontfix [factual reply and suggestion/request for upgrading from CLOSED-WONTFIX to at least FEATURE REQUEST] Is that so? Why then is a single time value which is not embedded into a formula correctly preserved as a time value within the cell? And you can still work with it properly, even across references. The decimal conversion and deliberate rounding of values within entered formulae where it is not absolutely necessary is highly unacceptable for a product which will be used in a productive office environment (and sometimes even inappropriately in mission critical environments. But blame human behavior for that, not OOo.) This is an opportunity for OOo to excel (pun intended) in reliability and accuracy where others badly fail. At least introduce a filter or additional abstract layer which preserves the originally entered formula for reference and editing, like the user provided and intended it, perhaps in a separate and prioritized data structure and only evaluate it to decimal value upon display or user evaluation request or export of the sheet into non-OOo formats. This would allow for innovation while not breaking the apparently so highly important adherence to bad habits of (still) inferior applications. In the case at hand that lead to the filing of this problem (it is not an issue, but that is a discussion to be held somewhere else), my original intention was to evaluate the time spent for one action item within a larger assignment. There is one column reserved for time in a matrix of action items. The result of the addition of separate amounts of time within this cell need to be human reviewable, so I (and my contractors) can see and edit how much time I spent in how many distinct sessions working on a specific action item. The conversion to decimals makes a quick, yet exact review impossible for the human eye. Where the fundamental purpose of the application is to serve the user, it here fails. And we are all for usability, are we not? The ability to freely and intutively work with an application is a great incentive in using it. This is an excellent and easy opportunity to make it happen. [highly necessary rant and LAR] There is a reason why I use OpenOffice.org and not Excel. The attitude involved in the premature closing of this "issue" is not going to make OOo better than Excel and is thus unacceptable. The consequence of following a bad role model is that of ending up in the same dead end. There will be no reason to switch over to OOo if the products become indistinguishable. People need reasons to bother, not reasons for feeling pampered. By pampering to bad habits and simply wrong and inappropriate application behavior , you would attract the wrong people who would only pull OOo down. You do not want those. You should not bow and bend to them. Not for what OOo stands for. Hi Niklas, please give us a short comment on this one and reflag and assign if necessary. Frank set to NEW, oooqa can do nothing about this So we'll keep it as an enhancement issue. Reassigning to owner "requirements". OpenOffice.org Issue Tracker - Feedback Request. The Issue you raised is currently assigned to 'Requirements' pending review, but has not been updated within the last 3 years. Please consider re-testing with one of the latest versions of OOo, as the problem(s) may have already been addressed. Either use the recent stable version: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ Please report back the outcome so this Issue may be Closed or Progressed as necessary - otherwise it may be Resolved as Invalid in the future. You may also wish to search for (and note) any duplicates of this Issue that may have advanced further by checking the Issue Tracker: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html |