How to set the Excel DisplayZeros Option to false in Navisio

Nokio
Nokio Member Posts: 52
edited 2007-07-18 in NAV/Navision Classic Client
Hi,
I don't want to see any zero amounts in my Excel Sheet so i need the code for the excel buffer Table in which I say that Excel should not show any zero amounts.
I've created a new field inside the table "Display Zeros". The makro for this Option in Excel was: ActiveWindow.DisplayZeros = False. I've tried the same code in Navision with XLWorkSheet and XLWorkBook but it doesn't work.
Does anyone know the right code?

Best Regards.

Comments

  • NR
    NR Member Posts: 78
    Using xlWorkSheet, it can be acheived by using the format() which will actually convert the variable to a string and the output will be a blank cell instead of a zero.

    xlWorkSheet.Range(RowNoColNo).Value := FORMAT(ValVar);
  • Nokio
    Nokio Member Posts: 52
    Is there another option?

    I want to use this funktion: ActiveWindow.DisplayZeros = False

    Is it possible?
  • Albertvh
    Albertvh Member Posts: 516
    Hi

    use 
      App.ActiveWindow.DisplayZeros := FALSE;

    App is 'Microsoft Excel 11.0 Object Library'.Application

    Hope this helps

    Albert

Categories