Reply with quoteEdit postDelete postReport this posttext field changes to number
by Henk on Thu Apr 21, 2011 4:25 pm
I have a report which uses static textfields in a seperate sheet
this text fields contains number and also a dot (.)
for axample:
12345.0020 or 09876.1234
these cells have the "text" property
after running the report, the text fields have changed to numeric, this means for example that the prior zero is lost
a way to prevent the fields to get corrupted, is to secure the sheet with a password, but then I have to press escape for every row because jetreport asks for the password?!?!
confused? hope i explained my problem clearly enough
thnx4help
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Henk,
You should be able to preserve your numbers by using the Excel TEXT function. You would do something like this:
=TEXT(Sheet1!C6,"0.0000")
You can't secure sheets with a password because Jet Reports needs to access the sheets and thus you will get prompted for the password when running the report. Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts As proposed the Text function works only other thing you might want to consider is adding an NP("Eval",
Depends basically on how often your acccessing that other sheet for that same value and how many Jet functions are using it
As I understand it if you have a cell (c4) that is =TEXT(Sheet1!cell2) and you reference c4 it goes back and recalcs the value where NP("eval" doesn't
Please sign in to leave a comment.