I have a values only report. The output of the cells are in the format of ="Example Value". After an update for Jet Reports strikethrough is being applied randomly to cell contents making the values hard to read for users.
When I open the file and insert a column, excel applies strikethrough seem below to the values automatically.
Why is this happening and how can this be updated to prevent the autoformatting?
If you are Report Viewer, you will need a Designer to go back to the original design and remove that formatting. If you need the strikethrough on the original column but not on the new column, that is Excel functionality, not Jet.
Unfortunately, this is a case where Excel is trying to be helpful, and I haven't even found a way to prevent this.
Try in Excel - Formulas - Calculation Options to unckeck Format State Values.
I've also noticed that the newest version of Jet seems to add strikethroughs at run-time to cells that didn't have strikethroughs. It's very odd.
