Bug 419181
| Summary: | Testcase for OpenOffice.org Calc/Excel | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | Răzvan Sandu <rsandu2004> | ||||
| Component: | openoffice.org | Assignee: | Caolan McNamara <caolanm> | ||||
| Status: | CLOSED UPSTREAM | QA Contact: | Fedora Extras Quality Assurance <extras-qa> | ||||
| Severity: | medium | Docs Contact: | |||||
| Priority: | low | ||||||
| Version: | rawhide | CC: | jnavrati | ||||
| Target Milestone: | --- | ||||||
| Target Release: | --- | ||||||
| Hardware: | All | ||||||
| OS: | All | ||||||
| URL: | http://www.ambience.sk/open-office-text-number-format-conversion | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2008-01-14 17:16:10 UTC | Type: | --- | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Attachments: |
|
||||||
|
Description
Răzvan Sandu
2007-12-11 03:32:57 UTC
Created attachment 283591 [details]
Microsoft Excel file to test.
Hello again, As far as I can figure it out, if one tries to export this Excel file as .ods (either via the Sun plugin for Microsoft Office or by directly opening the file in Calc), numbers get converted to text: an apostrophe is added in front of each digit in columns E and F. Of course, further calculations cannot be performed. I don't know if the above is the only issue that gets an incorrect mathematical calculation. In the mean time, I found no way to (automatically) remove the apostophes or to format the cells in columns E and F as numbers. Can you please provide a way to do this or point to the relevant documentation ? Such an issue is a *serious showstopper* for a less-skilled IT person, let's say an accountant. Regards, Răzvan I think the correct behaviour of Calc should be to issue a warning when some formula tries to perform calculations with numerals that are treated as text. In Excel 2003's help I've identified a quick procedure for converting a range of cells that are treated as text back to numerals (by multiplying them with 1, using Paste Special from the Edit menu). Regards, Răzvan Hello, This seems to be a solution, but the problem remains *very* annoying: http://www.ambience.sk/open-office-text-number-format-conversion Besides the steps given at the link above, it requires selecting the affected cells and doing a Format -> Default Formatting; if one doesn't do that, the regular expression replacement won't work. Regards, Răzvan Indeed (long delay for me to find a copy of excel), excel itself warns about this with little warnings symbols, but it does work. What's strange to me is that it works with text formatted cells of more than one character, but not with text formatted cells of one character. Let's check with upstream, there's more expertise there wrt. calc issues and it affects all versions, not just the fedora one. http://www.openoffice.org/issues/show_bug.cgi?id=85242 |