To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=48496
User dr changed the following:
What |Old value |New value
================================================================================
Assigned to|spreadsheet |dr
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon May 2 09:39:52 -0700
2005 -------
Problem: DATEN!$D$6:DATEN!$R$154 is stored as dynamic range consisting of two
cell addresses, and not as static range address. This confuses Calc, see issue
4904.
I will take this issue to add a workaround in the Excel filter.
To make this work in Excel and current Calc, you can change the address from
DATEN!$D$6:DATEN!$R$154 to DATEN!$D$6:$R$154 (remove the second sheet name) in
Excel.
Removing the $ before DATEN in Calc has only the effect that the formula is
re-interpreted, thus Calc detects a constant range address. The same would
happen, if you change something else in the formula, even something meaningless,
e.g. F2+SPACE+ENTER. The $ sign is to make the sheet address absolute, similar
to $D$6 vs D6. This is a Calc-only feature and does not exist in Excel.
---------------------------------------------------------------------
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]
