Hi,
We are using PAX 37 and noticing the following issues with some data entry sheets that were built with a bunch of DBRW formulas
1) When a cell containing DBRW formula, it takes calculations that results whole number(ex. 100/2 ) and doesn't like calculations that results with decimals (ex. 101/2). Also, other calculations 100*2 is not supported
2) Copying and pasting multiple cells allows paste as values only and sometimes the values don't get pasted properly
Please suggest if you implemented any solutions for the above problems. We like the tool but these kind of small issues are causing us headaches.
Excel formulae don't work in PAX
-
- Posts: 5
- Joined: Mon Feb 11, 2019 8:39 pm
- OLAP Product: TM1
- Version: PAX37
- Excel Version: 2016
Re: Excel formulae don't work in PAX
Can experts provide any suggestions pls?
- Steve Rowe
- Site Admin
- Posts: 2415
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Excel formulae don't work in PAX
Hi,
I suggest you provide some more detail, perhaps show us the formula that are working and not working and the results that are displayed in the cells. Or perhaps the workbook itself. e.g. You say "doesn't like" but you need to state exactly what the issue is, if its just display are you sure it is not an issue with formatting?
It sounds very odd and if it was something obvious happening the issue would be well known so the more detail you can provide the more likely it is you will get some pointers.
I suggest you provide some more detail, perhaps show us the formula that are working and not working and the results that are displayed in the cells. Or perhaps the workbook itself. e.g. You say "doesn't like" but you need to state exactly what the issue is, if its just display are you sure it is not an issue with formatting?
It sounds very odd and if it was something obvious happening the issue would be well known so the more detail you can provide the more likely it is you will get some pointers.
Technical Director
www.infocat.co.uk
www.infocat.co.uk