0

Cut cell text not returning full cell content

Jet Reports Historic Posts

January 27, 2015 16:21

None

Follow

hi,
thanks for the example.
So, there is a cut after exactly 100 signs….but why?
- is there a limitaion in your Excel-cell?
- is maybe the "original text" in Navision joined from (or with) two different fields?
Can you check the fieldlength via "object designer/tables/ table no/ design…..?

any other idea?

regards
jetsetter

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts January 27, 2015 16:21

  Hello
  
  Having the following issue:
  
  Using NAV 2009 (6.0)
  
  When returning a cell with text it cut the text and only a fragment of the text is transferred. (truncates the text)
  
  Any ideas?
  
  Also a Workaround is appriciated
  
  Cheers,

• 0
  
  Jet Reports Historic Posts January 27, 2015 23:20

  Can you put up a screenshot of what you are seeing? Is it cutting off at a certain character count?
  
  What is the function you are using? (Want to try against my own DB)

• 0
  
  Jet Reports Historic Posts January 28, 2015 09:38

  hi,
  i haven't had this Problem before
  
  pls post the code and an example of the result…
  
  regards
  jetsetter

• 0
  
  Jet Reports Historic Posts January 29, 2015 10:16

  Thanks
  
  here is the code:
  
  =NL(;"6038951 Maskinspecifikation";"Beskrivelse";"2 Maskinnr.";$C$2;"5 Beskrivelse";"<>''";"6 Typebeskrivelse";"Yderligere information")
  
  Sorry Danish
  
  Text presented:
  CaseIH 170CVX årg. 2002 timer 3991 med, trinløs gearkasse, frontlift, Hauer POM-S 150 frontlæsser me
  
  Original text:
  CaseIH 170CVX årg. 2002 timer 3991 med, trinløs gearkasse, frontlift, Hauer POM-S 150 frontlæsser med el joystick, lift kapcitet 9900 kg, højt vogntræk, air con, pæne 650/65X42 - 540/65X28 dæk
  
  Regards, Jesper