Product: Spreadsheet
Type: new
Title: INDIRECT now supports the '!' sheet separator
Posted by: [EMAIL PROTECTED]
Affected: sc
TaskId: i30172
<http://www.openoffice.org/issues/show_bug.cgi?id=30172>
Effective from: cws odff05
CWS:
<http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/odff05>
CWS status: new
*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [ ]
UI relevant [ ]
*Description*
-------------
For MS-Excel interoperability the INDIRECT function now supports the '!'
exclamation mark as sheet name separator when interpreting cell address
strings, additionally to the '.' dot separator Calc uses.
This change aligns with the behavior of other spreadsheet applications and
the definition given in the OASIS ODFF/OpenFormula specification available at
http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula
Send feedback to [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
