To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=105130
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords|needmoreinfo, oooqa |oooqa
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Fri Sep 18
09:04:23 +0000 2009 -------
I checked with "Ooo 3.1.1 WIN XP DE-multilingual version German UI activated
[OOO310m19 (Build 9420)]" and can confirm that the formulas in some cases take
data from the wrong sheets.
Steps to reproduce:
0. open "aa.ods", "bb2009.ods"
In "aa.ods" in 'B5' you will see "73", what is correct. Pls. compare
with 'bb2009.ods#Cornelio 08.I8'
In "aa.ods" in 'B14' you will see "73", what is NOT correct. Pls. compare
with 'bb2009.ods#ISA 08.I8'
1. modify 'bb2009.ods#Cornelio 08.I8' from "73" to "2"
2. Save bb2009.ods
3. in "aa.ods" use menu "Edit -> Links -> Refresh" to read current values from
'bb2009.ods'
as expected, 'B5' will change from "73" to "2"
unexpectedly. B14 also changes from "73" to "2", although the formula
references to sheet 'ISA 08', where no modifications have been one
That shows that formula works with data from wrong sheet. That's very very
dangerous for users who trust th the results of their spreadsheet.
I did not find out why that formula links to data in wrong sheet, I only see
that only formulas with reference to matrices starting in second column are
affected.
@cornix:
Do you have any idea concerning this "only formulas with reference to matrices
starting in second column are affected" effect?
---------------------------------------------------------------------
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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
