| Summary: | FILTER: Function ISOWEEKNUM in MS Excel returns an error in a spreadsheet saved to .ODS and re-opened. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | John Smith <clicksafe> |
| Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | CC: | jmadero.dev |
| Version: | 4.1.1.2 release | ||
| Hardware: | Other | ||
| OS: | Windows (All) | ||
| See Also: | https://bugs.freedesktop.org/show_bug.cgi?id=50950 | ||
| Whiteboard: | BSA | ||
| i915 platform: | i915 features: | ||
| Attachments: | An ODT document, illustrating with screenshots, the steps described above. | ||
Bug report 50488 and bug report 50950 also have comments relating to this function and are probably relevant. Hi John Smith - please attach the original xlsx sheet (or a new one) so that we can actually save it as an ODT and then see the problem. Note that many of our users (and QA) don't own or use Microsoft Office so recreating xlsx sheets on MS 2013 can be rough. Marking as NEEDINFO - once you attach the original (or a new XLSX) sheet please set to UNCONFIRMED and I'll try to confirm the problem. |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 87702 [details] An ODT document, illustrating with screenshots, the steps described above. Problem description: Importing an Excel spreadsheet containing the ISOWEEKNUM function, saving it to ODS format, then re-opening it causes an error. Steps to reproduce: 1. Import the Excel 2013 spreadsheet from the location given in the attached document, selecting to view it in Calc. 2. The spreadsheet displays as i the first graphic of the attachment. 3. Save the spreadsheet as an ODS format spreadsheet.Close the open document. 4. Re-open it in Calc. Current behavior: The error as shown in the second graphic in the attachment is displayed Expected behavior: That an import filter would permit a correct display. Operating System: Windows XP Version: 4.1.1.2 release