Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | When reading an .xls file 'hour' function returns always 0 | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | dmrq <dmrq> | ||||
Component: | ui | Assignee: | spreadsheet <spreadsheet> | ||||
Status: | CLOSED DUPLICATE | QA Contact: | issues@sc <issues> | ||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | issues | ||||
Version: | OOo 1.1.1 | ||||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | All | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
dmrq
2004-05-13 07:13:14 UTC
Please attach a sample xls file using the URL above: "Create a new attachment". Created attachment 15243 [details]
sample spreadsheet with Hour function failing
I've just attached a sample file. Note that, since my locale is ES, function is written 'HORA'. That's not a problem. If you open the spreadsheet with excel, the hour function works properly, even though the argument cells are text and not time-values yes, this is a classic difference between Calc and Excel where Calc does not treat text as values. This is well documented in issue 5658. The workaround to ensure compatability would be to remove the leading apostrophe (') from each cell in column C or change the formula in B e.g. B4 to =HOUR(VALUE(C4)). 'VALOR' in Spanish. I will close this as a duplicate of issue 5658 *** This issue has been marked as a duplicate of 5658 *** closed |