Page 1 of 1

Excel formulae don't work in PAX

Posted: Tue Apr 30, 2019 2:50 am
by hadimulam
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.

Re: Excel formulae don't work in PAX

Posted: Wed May 08, 2019 7:51 pm
by hadimulam
Can experts provide any suggestions pls?

Re: Excel formulae don't work in PAX

Posted: Thu May 09, 2019 7:17 am
by Steve Rowe
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.