Hello,
Not sure if this section of the forum is the place to post this, but I'll have a go at it anyway.
Very frequently I get terribly frustrated by the fact that my reports get corrupted during the proces of making them. Just today I had to skip back 6 steps in versions, losing more than half a day's work due to a corruption.
The net result of the corruption is that the temporary? spreadsheet is 'remembering' old cell-values, cell properties and formulas which magically reappear after returning to the design modus of JR. The spreadsheet also appears to be locked in that JR can't get fully back to presenting the sheet in design modus, leaving formula references to other worksheets in Cell A1.
Is there a way to avoid the corruption from happening (I'm familliar with the tips 'dont design in non-design modus' and the 'don't break off during the Excel calculation').
Furthermore, is there a way to repair a corrupted spreadsheet (without the usage of things like notepad++)?
Kind regards and thanks in advance for looking into this. I'm interested to learn if I'm the only one suffers from this pesky phenomenon.
Date
Votes
4 comments
-
Jet Reports Historic Posts I had this problem with a clients spreadsheet once. I logged the call with Jet support and the issue was caused by the designer attempting to comment out an IF statement whilst he was working on the report. For example, he had this in a cell:
'="=if(p12<50000,"Below Minimum",P12-W12-AD12-AK12-AR12-AU12)"
When I changed it to below, the problem would not occur:if(p12<50000,"Below Minimum",P12-W12-AD12-AK12-AR12-AU12)
Have a look through all your formulas and see if anything is out of the ordinary. If you have a version to revert back to, save your changes incrementally going forward so you can use process of elination to work out the issue.
Also, you can log the issue with the offical Jet Support line. In the case I had, they were able to extract the formulas from the corrupted sheet. -
Jet Reports Historic Posts Thanks for the reply,
I'll scout my sheet for anything out of the ordinary but I'm pretty sure it's all very straightforward and not really exotic by any strech of the imagination. I find it strange that even previous versions 'all of a sudden' start giving the same error messages when they previously worked fine. Maybe I'd better start looking for moths in my PC.
But if I'm understanding you correctly, I could eventually send my sheet to Jetreports support where they may be able to locate the corruption and restore it?
regards,
Ite Boerema -
Jet Reports Historic Posts They may not be able to identify the corruption, however they can often (or in my case) extract your original formulas so you don't lose your work.
-
Jet Reports Historic Posts I have removed and replaced some of the formulas which I had added lastly (Copy pasted them from a previous version) and my error seems to have gone for now. I've also send the report to Jet support for analysis.
T.B.C.
Please sign in to leave a comment.