To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104378
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
CC|'' |'rainerbielefeld'
--------------------------------------------------------------------------------
Keywords| |needhelp, oooqa
--------------------------------------------------------------------------------
------- Additional comments from rainerbielef...@openoffice.org Fri Aug 21
06:34:25 +0000 2009 -------
I checked "Terms.xlsx" with "Ooo 3.1.0 WIN XP multilingual version German UI
activated [OOO310m11 (Build 9399)]" and can confirm the reported effect. My OOo
showed 2 decimals in A6, to decimals is setting for most of my CALC documents
(and may be OOo CALC default?)
Excel Viewer 12.0.6334.500 MSO 12.0.6333.5000 shows 9 decimals.
It seems that OOo uses the settings that have been inserted in Menu 'Tools ->
Options -> OOo Calc -> Calculate -> Decimal places' the last time, may be
because there is no other information in "Terms.xlsx"?
Steps to reproduce:
0. Dwonload and unpack "TestKit.zip"
1. Open "master3.ods"
2. In menu 'Tools -> Options -> OOo Calc -> Calculate -> Decimal places'
modify entry from 3 to 4
3. Save document
4. Click "Link" to open "Terms1.xlsx"
A6 will be shown with 4 decimals
11. Open "master7.ods"
12. In menu 'Tools -> Options -> OOo Calc -> Calculate -> Decimal places'
modify entry from 7 to 6
13. Save document
14. Click "Link" to open "Terms6.xlsx"
A6 will be shown with 6 decimals
My knowledge is too poor to decide whether "Terms.xlsx" contains useful
information concerning desired decimal places for cell A6, which should be used
by OOo, or whether the current way OOo decides number of decimal places is the
only way that can be handled (OOo can't know anything concerning an unknown
user's EXCEL settings).
Yo can see this using my "TestKit.zip", what contains 2 OOo documents with links
to "Terms1.xlsx" and "Terms1.xlsx", what are identical copies of "Terms.xlsx".
If No. of decimal places is important, user should have used cell formattings?!
@sgreenhow:
Please contribute information concerning your Platformand OS!
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
