Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Division of a time variable not working | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | brendel <brendel> | ||||
Component: | open-import | Assignee: | spreadsheet <spreadsheet> | ||||
Status: | CLOSED DUPLICATE | QA Contact: | issues@sc <issues> | ||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | issues | ||||
Version: | OOo 1.1.4 | ||||||
Target Milestone: | --- | ||||||
Hardware: | PC | ||||||
OS: | Windows XP | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
brendel
2005-01-12 17:03:58 UTC
Created attachment 21418 [details]
example EXCEL file for division of a time cell
Hi, this is not a bug of OOo. The 'Timevalue' you used is a text and Calc doesn't calculate with textvalues. If you format the cell B1 in your example as time and remove the quotation marks from the 'then' and 'else' statement of the 'if' function, it works as expected. So no bug because Calc is more strict in following rules of calculation. Frank closed invalid I agree with you, this is not a bug of Calc, however this is a bug in the import of an EXCEL file. SO its the job of Import to do the changes you suggest below, taking away the quotation marks when the targed cell is formated as time. The kind of problem I presented is often found in administrative EXCEL spreadsheet (for example in an time spreadsheet of the European Union Administration). If these kind of operations can not be imported this will pose a major problem for administrations to change to OO Hi, closing again as the import could not know that this kind of text should be converted to real time values. Please have a look at Issue 5658 . For now I close this as duplicate. Frank *** This issue has been marked as a duplicate of 5658 *** closed double Import could deduce from the cell format the format of the text. In the case here the cell is formated as time, so in my opinion it makes more sense to format the text in the if statement as time and thus to delete the quotation marks than to format it as text.... Oliver |