News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) how to get space in ex...

Microsoft Dynamics NAV (Archived)

how to get space in export to excel in navision2015?

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

hi all,

i have a small issue in my report Export to excel code is there it's work fine.

here comment is text variable and i want to export this comment to excel and i write the code is

IF ExportToExcel THEN BEGIN
i+=1;
EnterCell(i,6,Comment,FALSE,FALSE,'');
END;

This is also works fine but i want to display Two spaces in front of Comment in Excel.

how can i done this one i tried as

CommentG:=' '+Comment;

IF ExportToExcel THEN BEGIN
i+=1;
EnterCell(i,6,CommentG,FALSE,FALSE,'');
END;

but it's not working can any suggest me please........

Regards,

Ramesh.

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (1)

keoma 32,675 on at

Like (0)

Report

RE: how to get space in export to excel in navision2015?

nice solution. did you try my solution ?
Verified answer

Community Member Microsoft Employee on at

Like (3)

Report

RE: how to get space in export to excel in navision2015?

Hi archer,

I got my solutions as

CLEAR(CommentG);

ChrL:=32;

CommentG:=Comment;

FormatL:='_($* " "_);_(@@_)';

IF ExportToExcel THEN BEGIN

i+=1;

EnterCell(i,6,CommentG,FALSE,FALSE,FormatL);

END;
Suggested answer

keoma 32,675 on at

Like (0)

Report

RE: how to get space in export to excel in navision2015?

this is excel specific. to write text in excel it needs to start with = and an apostroph sign: '

example: ='. sample text'

to use in c/al write '' (double apostroph) to get one aoostroph in the text.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans