To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=95256
User dr changed the following:
What |Old value |New value
================================================================================
Assigned to|dr |er
--------------------------------------------------------------------------------
Status|STARTED |NEW
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Thu Oct 23 09:10:29 +0000
2008 -------
This cannot be fixed :-(
The Excel file uses a relative offset in the mentioned shared formulas. Instead
of directly pointing to the cell E5, the formula contains the distance of
formula position and referred cell. By doing this, Excel uses the fact that
these relative references wrap at the sheet borders. In our example, the formula
does not point to "164 columns left" (negative offset -164) but points to "92
columns right" (positive offset 92). If that formula is located in cell FM5
(column FM has 0-based index 168), Excel calculates the target column 168+92=260
and wraps that at last column (255), which results in column index 4 meaning
column E. Calc did and does the same, but now, with changed column count, no
wrapping occurs anymore.
The same happened in the past, when loading a BIFF5 file (Excel 5 or Excel 95,
16384 rows) in Excel 97 or later, and the file contains shared formulas or
defined names pointing a few rows below. Seems, they have been aware of such
problems while extending Excel 2007 to more rows/columns and thus added a
"compatibility mode" with 65536 rows/256 columns. This mode is enabled when
loading old files in Excel 2007 to prevent these problems.
A risky and non-trivial filter-only fix is to resolve shared formulas for every
cell and do the wrapping manually. But this would result in more memory
consumption when loading big Excel files, and increased import time.
Additionally, this is only possible for shared formulas, if you use defined
names, the problem is still present. Example: In Excel 2003, cell A1, define the
name "test" pointing to "Sheet1!B1" (relative reference). This creates a name
pointing to 1 column to the right. If this name is used in cell A1, it points to
cell B1. If this name is used in cell IV1, it points to cell A1 (one column to
right + wrap at sheet border). After importing to Calc 3, it will point to cell
IW1. There is no way to fix this in the filter, without breaking any of the
formulas.
The "real" fix would be to add a compatibility mode that restricts the sheet
size to 256 columns.
---------------------------------------------------------------------
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]
