Microsoft Excel Problems
Posted: Sun Mar 31, 2013 1:33 am
Since upgrading to the latest pre-release version (SL_v4_2013.03.11) I'm experiencing a significant problem with the Save to 'Microsoft Excel 2007/2013 File' option and a slightly less significant problem with the Save to 'Microsoft Excel File' option.
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: -
The second problem, relating to the Save to 'Microsoft Excel File' option, is that any images are not visible in the resulting xls file.
Any help would be greatly appreciated in resolving these two issues with the XLSX and XLS save options.
Thanks
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: -
- 2013-03-31 new version.png (208.85 KiB) Viewed 3182 times
- 2013-03-31 old version.png (213.01 KiB) Viewed 3182 times
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