[sc-issues] [Issue 101639] VLOOKUP incorrectly cache s external references' sheets when the referen ce is changed.

2009-09-21 Thread cornix
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101639 --- Additional comments from cor...@openoffice.org Mon Sep 21 13:08:37 + 2009 --- If you have more than one VLOOKUP with the same range (this it is important),

[sc-issues] [Issue 105130] OO0 3.1 Calc: wrong resul t in formula referencing cells in other file.

2009-09-19 Thread cornix
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105130 --- Additional comments from cor...@openoffice.org Sat Sep 19 16:20:42 + 2009 --- @jbfaure: Yes, it is the same problem described in issue 101639. If you have

[sc-issues] [Issue 105130] OO0 3.1 Calc: wrong resul t in formula referencing cells in other file.

2009-09-17 Thread cornix
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105130 --- Additional comments from cor...@openoffice.org Thu Sep 17 07:08:32 + 2009 --- The formula looks in an another sheet to find a value associated to a

[sc-issues] [Issue 105130] OO0 3.1 Calc: wrong resul t in formula referencing cells in other file.

2009-09-17 Thread cornix
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105130 --- Additional comments from cor...@openoffice.org Thu Sep 17 07:14:19 + 2009 --- I confirm that changing something in the formula with the same value can have

[sc-issues] [Issue 105130] OO0 3.1 Calc: wrong resul t in formula referencing cells in other file.

2009-09-16 Thread cornix
Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|cornix --- Additional comments from cor...@openoffice.org Wed Sep 16 17:07:45 + 2009 --- This problem raises in the 3.1 version. My speadsheet (aa.ods) has formulas (in colum B

[sc-issues] [Issue 105130] OO0 3.1 Calc: wrong resul t in formula referencing cells in other file.

2009-09-16 Thread cornix
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105130 --- Additional comments from cor...@openoffice.org Wed Sep 16 17:09:57 + 2009 --- Created an attachment (id=64800) zip file containing the two referenced