Excel Buffer Text limit of 250 Characters

G8tor
Member Posts: 29
Hello. Im doing a report that reads comments from table and output them into Excel.
These comments can be as long as 1000 characters. When I tried to send these text strings into the Excel Buffer table for proccessing and outputting to Excel I notice that
the "Cell Value as Text" field in the Excel buffer only allows 250 characters.
Is there some way for me to get one big comment ( 251+ characters) in one cell in Excel from Navision?
These comments can be as long as 1000 characters. When I tried to send these text strings into the Excel Buffer table for proccessing and outputting to Excel I notice that
the "Cell Value as Text" field in the Excel buffer only allows 250 characters.
Is there some way for me to get one big comment ( 251+ characters) in one cell in Excel from Navision?
0
Comments
-
why yes ofcourse.
However, if you stick by using excel buffer, it might get harder.
A cell in excel is not limited to 250 characters. so the automation should be able to handle larger texts
What I would do is add another table (extended excel buffer) that holds the row, the column and a line number so that overflows from cell value as text can be inserted in this new table (with also a field of text 250, since that is the limit of NAV).
In code when the excel buffer assigns the field "cell value as text" to the automation cell.value, i'd add code to iterate over the records in my new table, filtered by the excel buff record primary key. with the code ExcelCel.value := excelcel.value + extendedbuffer."additional text"
Just remember, when facing technical limitations when solving a problem, try to divide the problem in smaller problems that can be solved within the limitations0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions