[sc-features] new/cws odff05 : INDIRECT now supports the '!' sheet separator

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[sc-features] new/cws odff05 : INDIRECT now supports the '!' sheet separator

eike.rathke


       Product: Spreadsheet
          Type: new
         Title: INDIRECT now supports the '!' sheet separator
     Posted by: [hidden email]
      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 [hidden email]



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]