• # Extraordinaire !!

    Posté par . En réponse au journal ODF et Microsoft Office 2007 SP2 (suite et surement pas fin). Évalué à 7.

    Rob Weir explique que les adresses des cellules dans une formule commencent par [ et finissent par ]

    "So, going back to my test spreadsheets from all of the various ODF applications, how do these applications encode formulas with cell addresses:

    * Symphony 1.3: =[.E12]+[.C13]-[.D13]
    * Microsoft/CleverAge 3.0: =[.E12]+[.C13]-[.D13]
    * KSpread 1.6.3: =[.E12]+[.C13]-[.D13]
    * Google Spreadsheets: =[.E12]+[.C13]-[.D13]
    * OpenOffice 3.01: =[.E12]+[.C13]-[.D13]
    * Sun Plugin 3.0: [.E12]+[.C13]-[.D13]
    * Excel 2007 SP2: =E12+C13-D13

    I'll leave it as an exercise to the reader to determine which one of these seven is wrong and does not conform to the ODF 1.1 standard."