Microsoft Excel Problems

Stimulsoft Reports.Silverlight discussion
Locked
User avatar
ChrisCookDev
Posts: 41
Joined: Sun May 20, 2012 7:07 pm
Location: UK

Microsoft Excel Problems

Post by ChrisCookDev »

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: -
2013-03-31 new version.xlsx
(441.56 KiB) Downloaded 315 times
2013-03-31 old version.xlsx
(45.29 KiB) Downloaded 269 times
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
2013-03-31 new version.png (208.85 KiB) Viewed 2339 times
Whilst the following image shows the settings used when producing the '2013-03-31 old version.xlsx' file from the old version: -
2013-03-31 old version.png
2013-03-31 old version.png (213.01 KiB) Viewed 2339 times
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()
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
Chris Cook :: Software Development Manager :: www.genesisit.co.uk
Design, Develop, Deliver! :: App development for smartphones, tablets, the desktop and the web
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Microsoft Excel Problems

Post by HighAley »

Hello.

We made an improvement in the Word and Excel exports.
It will available in our release on April 3.

Thank you.
Locked