on 02-16-2017 2:22 PM
Hello,
we use AfO 2.3 with Excel 2010. We want calculate a new result in a AfO column with a Excel formular. This calculation works correctly in one row (see File attached to row 4). When copying to several lines, a formula element is converted to a fixed reference ($D$4) (marked in yellow). How can this permanent relationship be exempted? The correct formula is in the green marked column beside it.
Thanks for tips and Solutions.
Heiko Stranghoenerafo-formular.jpg
I have noticed that the Excel formula integration has changed and is improved in 2.4 over 2.3...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Heiko - I can't replicate this in Analysis Office 2.4.1 with Excel 2016. Perhaps you can upgrade to 2.4.1 and try it again?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.