OASIS Open Document Format for Office Applications (OpenDocument) TC

 View Only
  • 1.  Comparison for terms for parameter of LOOKUP functions

    Posted 07-28-2025 11:53
      |   view attached

    Hi all the attached document contains a comparison of the terms.



    ------------------------------
    Regina Henschel
    The Document Foundation
    Dortmund
    ------------------------------

    Attachment(s)



  • 2.  RE: Comparison for terms for parameter of LOOKUP functions

    Posted 08-12-2025 21:49
      |   view attached

    Hi All

    LOOKUP functions terminology compared.

    Cheers

    Olivier



    ------------------------------
    Olivier Hallot
    The Document Foundation
    ------------------------------

    Attachment(s)

    pdf
    LOOKUP_GRID.pdf   34 KB 1 version


  • 3.  RE: Comparison for terms for parameter of LOOKUP functions

    Posted 08-13-2025 07:56

    Hi Olivier

     

    Thanks for a really useful piece of work, which makes it much easier to compare the parameter names chosen by each implementation. Any chance we could have an editable (.ods) version? This would enable us to record our individual preferences and ideas in preparation for further discussion.

     

    Kind regards,

     

    Francis






  • 4.  RE: Comparison for terms for parameter of LOOKUP functions

    Posted 08-13-2025 08:55
      |   view attached

    Hi Francis,

    Sure.

    But this mailing does not allow upload of .ods files, so the trick here is to upload a hybrid PDF, generated by LibreOffice, where the ODS file is embedded in the PDF. Once you open the PDF in LibreOffice, it loads into the spreadsheet program.

    Cheers



    ------------------------------
    Olivier Hallot
    The Document Foundation
    ------------------------------

    Attachment(s)

    pdf
    LOOKUP_GRID_hyb.pdf   65 KB 1 version


  • 5.  RE: Comparison for terms for parameter of LOOKUP functions

    Posted 08-17-2025 15:34

    Olivier,

    Great work that will greatly assist the TC in this task!

    I successfully pasted into a spreadsheet, but it didn't line up on the multi-line cell entries. :-(

    Suggestion: Can you just send us the file directly as a spreadsheet? So we don't have to contend with the vagaries of the OASIS servers?

    If not, I have one more trick I may try tomorrow. 

    Thanks!

    Patrick


    On 8/13/2025 8:54 AM, Olivier Hallot via OASIS wrote:
    01000198a37f38db-72cf7352-bd29-48ef-8bb2-848dc18ca221-000000@email.amazonses.com">
    Hi Francis, Sure. But this mailing does not allow upload of .ods files, so the trick here is to upload a hybrid PDF, generated by... -posted to the "OASIS Open Document Format for Office Applications (OpenDocument) TC" community





  • 6.  RE: Comparison for terms for parameter of LOOKUP functions

    Posted 08-18-2025 10:49

    Sorry for the delay. I have your e-mail.

    If anyone else needs the source spreadsheet, please drop me a mail, as I can't get your address from from this list.

    Cheers

    Olivier



    ------------------------------
    Olivier Hallot
    The Document Foundation
    ------------------------------