Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Excel Buffer - Formula Bug 2015
Mauddib
Member Posts: 269
I am not sure if this is a bug or am I doing something wrong?
I used Excel Buffer to create an Excel Sheet in 2015. Everything worked except for my totals.
My totals were a simple =SUM(A1:A10) style formula.
When I open the completed sheet however the cell with the formula in it just shows #NAME. If I click on the cell however and type ENTER, the cell calculates correctly.
Refreshing with F9 or the like does not seem to help. Only clicking into the cell and ENTER does the trick.
I used Excel Buffer to create an Excel Sheet in 2015. Everything worked except for my totals.
My totals were a simple =SUM(A1:A10) style formula.
When I open the completed sheet however the cell with the formula in it just shows #NAME. If I click on the cell however and type ENTER, the cell calculates correctly.
Refreshing with F9 or the like does not seem to help. Only clicking into the cell and ENTER does the trick.
0
Comments
Just tried this. The function AddColumn in the Excel Buffer table has as second parameter a Boolean called 'IsFunction'.
When I add the column with value '=SUM(A1:A10)' and IsFunction=FALSE then I get exactly what you describe. (*UPDATE*) : no , just get the text '=SUM(A1:A10)' instead of '#NAME?' . Maybe it is a language setting thingy ?
When I add the column with value '=SUM(A1:A10)' and IsFunction=TRUE then I get the result you would expect: the sum of cells a1 through a10.
The "Isformula" boolean decides whether to populate the "Cell Value as Text" or "Formula" fields in the Excel Buffer.
When set to false I get the Formula in the Excel sheet as Text. That is I actually see "=SUM(A1:A10)" in the cell as text.
When set to true I get #name. So it is a mystery to me why you get the correct calculation to show. There may be a setting in Excel I am not seeing causing this.
http://www.epimatic.com
I am partially convinced it is going to come down to being a language thing actually. And I probably should have made it clear I am using a German EXCEL and Windows here. So apologies for that.
I am using Nav 2015 and I am actually exporting the formula
=SUMME(A1:A10)
and it comes out as #name but when I enter the cell and press ENTER it works fine.
So I am wondering now if somehow when inserting =SUMME(A1:A10) that Navision or the DotNet functions do not understand it is German and so do not recognize the function SUMME? But when I open excel itself and ENTER in the cell - it is THEN recognizing it????
Could that theory be correct, and if so how to correct for it?