Export To Excel format fields decimal type (#,##0.00)

Business Central/NAV Developers Forum
1

Hi Everybody

When i use function EnterCell export field to excel then can’t format field type #,##0.00

Function i use :

EnterCell(RowNo : Integer;ColumnNo : Integer;CellValue : Text[120];Bold : Boolean;UnderLine : Boolean;NumberFormat : Text[30];CellType : Integer)
ExcelBuf.INIT;
ExcelBuf.VALIDATE(“Row No.”,RowNo);
ExcelBuf.VALIDATE(“Column No.”,ColumnNo);
ExcelBuf.“Cell Value as Text” := CellValue;
ExcelBuf.Formula := ‘’;
ExcelBuf.Bold := Bold;
ExcelBuf.Underline := UnderLine;
NumberFormat := NumberFormat;
ExcelBuf.“Cell Type” := CellType;
ExcelBuf.INSERT;

And call function :

EnterCell(RowNo,7,FORMAT(TempExcelBuffer.Decimal_1),FALSE,TRUE,’#,##0.00’,ExcelBuf.“Cell Type”::Number);

But it’s no export format type #,##0.00

Please help fix format type. Thanks very much.

Best Regards

Dinh Son

2

Please always mention which version of NAV this is about and which version of Excel.

I’ve seen some examples of “strange” formatting with Excel 2013.

3

Hi Erik

I use NAV 2013

4

And which Excel?

5

I use Excel version 2013