Excel Exporting with Strikethrough lines
-
I have a report with some of the data with strikethroughs(a word and a line on top of the word to show its been cancelled ). When I export my report to excel - all the data gets a strikethrough. Therefore the strikethrough formatting takes place in the entire document even for the data that is not suppose to have these lines. Any advise on how to sort out this problem will be appreciated. Thank you.
-
Shelmina -- strike through's are just a text formatting option, like bold , italic, type face or font size; they are not part of the data.
So the problem lies with the Excel Format Cells specification, check to be sure it is not called for in the columns or cells. If they are meant to distinguish old rows from new (or some such) you should probably add Excel's conditional formatting, based on some cell value in the data, to create the distinguished formatting.
On the other and, since I just noticed that your post was in Reporting Services (about which I also know nothing, sorry), I would suspect that the fault may be with the formatting you specified in your report definition.
That does not help a bit, does it?
-
Thanks for your reply. But this doesn't really help. I haven't specified any formatting in the report. Normally, when you export a reporting services report to excel it should display it exactly the same way as it is displayed in the reporting services. But for some reoson when I export this particular report to excel the formatting changes and it adds strikethoughs all over the document.
-
I decided it wouldn't help either. Sorry.
Have you tried different version of Excel (using Office 2007/2003?)
Can you remove the formatting after the workbook is generated?
Let us know how you finally solve it.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply