After running a report all formulas are replaced by specific number results, making it impossible to make changes in the final spreadsheet, without reentering the formulas. Is it there a way to retain formulsa, such as "IF" statements and additions, subtractions, and multiplications?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hey Richard,
First, I'm assuming that you have a +Values in Cell A1 of your report. When you use +Values, Jet Reports converts all of it's formulas to the results of the formula. However, I just checked and it only does this when you have a Jet Functions (NL, NF, etc) in the formula. If the formula is just Excel functions (like subtotals, sums, if, etc) then the formula is not changed.
I suspect that you may have something else going on here as what your are describing is not what my experience has been. Are you on an older version of Jet Reports? The latest is v7.
Please sign in to leave a comment.