To demonstrate the first of these issues, I've attached the following two example xlsx files one produced from the latest version and the other produced from an older version: -
As you can see in the '2013-03-31 new version.xlsx' example, the saved file is being corrupted by the introduction of strange images overlaying all of the text. Whilst in most cases these strange images closely mirror the text they unnecessarily overlay, sometimes they only show the first character of the text beneath it.
The following image shows the settings used when producing the '2013-03-31 new version.xlsx' file from the new version: -
Whilst the following image shows the settings used when producing the '2013-03-31 old version.xlsx' file from the old version: -
I'm also using the following vb.net code to display the report: -
Code: Select all
StiOptions.Silverlight.Themes.CurrentTheme = StiSilverlightThemes.Office2010Blue
StiOptions.Viewer.Elements.ShowReportOpenButton = False
StiOptions.Viewer.Elements.ShowPageNewButton = False
StiOptions.Viewer.Elements.ShowPageDeleteButton = False
StiOptions.Viewer.Elements.ShowBookmarksPanel = False
StiOptions.Viewer.SaveReportsButtons.ShowDocumentButton = False
Dim report As New StiReport
Dim a As Assembly = Assembly.GetCallingAssembly()
Using sr As StreamReader = New StreamReader(a.GetManifestResourceStream(reportResourceName))
report.Load(sr.BaseStream)
End Using
report.CalculationMode = StiCalculationMode.Compilation
report.RegBusinessObject("ReportModel", "ReportModel", Me)
report.Render()
report.Show()
Any help would be greatly appreciated in resolving these two issues with the XLSX and XLS save options.
Thanks