Excel calculation while importing

(0) Share

Report

Posted on by NavTech

2,382

I am importing a excel into Nav using excel buffer. I want to use excel calculation formula like LEN ,MID on some fields of excel.I want to apply the formula in some excel cell and import the value of cell in Nav.

*This post is locked for comments

All responses (6)

Answers (0)

Suggested answer

4BzSoftware 6,071 on at

Like (0)

Report

RE: Excel calculation while importing

Hi NavTech,

System imports value of Excel Cell (result of formula) by default. May be the formula cells are formatted as text. Try to format them as general, reupdate the formula. Besides, paste value can be helpful!
mmv 11,465 on at

Like (0)

Report

RE: Excel calculation while importing

Have you checked the below?

www.mibuso.com/.../viewtopic.php;t=1067
NavTech 2,382 on at

Like (0)

Report

RE: Excel calculation while importing

in clients functionality they have some fields for enter excel cell numbers like A1, B4,

Based on these cell value I have to prepare a excel formula( LEN(A1) or MID(B4,2,6) ) and apply.
mmv 11,465 on at

Like (0)

Report

RE: Excel calculation while importing

Why don't you use the same formula in NAV and calculate the values?
NavTech 2,382 on at

Like (0)

Report

RE: Excel calculation while importing

Excel formule for example =MID(A3,1,25),=LEN(A3).

I am trying to make formula string but dont know where to pass it
mmv 11,465 on at

Like (0)

Report

RE: Excel calculation while importing

Hi,

What kind of formula you want to use?

Best Regards,

MMV