LibreOffice and NAV2009

supremo
supremo Member Posts: 73
edited 2014-06-18 in NAV/Navision Classic Client
Good day!

We have clients with LibreOffice and would like to export reports or grid information into a spreadsheet. How can we directly configure NAV to use LibreOffice Calc instead of looking for Excel?

Thank you.

Comments

  • easy-navi
    easy-navi Member Posts: 31
    I would try this way:

    1. Look at Table t370. There are functions like: CreateBook(), OpenBook(), CreateSheet(), AddColumn() etc.
    2. Write your own funcktions like CreateBookLibreOffice(), OpenBookLO(), CreateSheetLO(). If only LibreOffice has its own Automation Servers it is possible. (I am not sure, because I haven't installed Libre on my computer).

    3. On a report that should be exported do LibreOffice, write a code that opens a LibreOffice Sheet and Fills it. Write it using your new functions: CreateBookLO(), OpenBookLO(), CreateSheetLO(), AddColumnLO(). Of course programming you can take a pattern from native NAV code :)
    http://www.reinwestuj.pl Inwestuj w nieruchomości. Condohotele, aparthotele.

Categories