How to set the Excel DisplayZeros Option to false in Navisio

Nokio

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.

NR

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

Is there another option?

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

Is it possible?

Albertvh

Hi

use

  App.ActiveWindow.DisplayZeros := FALSE;

App is 'Microsoft Excel 11.0 Object Library'.Application

Hope this helps

Albert