Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Mon Feb 28, 2011 9:56 am

hello,

if we use any property to change/set, autofilter, panes and so on, and save the file as excel 2003, then the gridlines a disappear???

Thx in advance,

Reinhold

reinhold
 
Posts: 10
Joined: Wed Feb 09, 2011 8:13 am

Tue Mar 01, 2011 5:38 am

Did mean that you want to disappear the border of all cells?
Harry
Technical Support / Developer,
e-iceblue Support Team
User avatar

harry.support
 
Posts: 180
Joined: Mon Nov 08, 2010 3:11 pm

Wed Mar 02, 2011 9:31 am

Dear Harry,

we generate from a ssrs-server the excel-file, download them and then, based on a configuration, we changed different things, like add panes, or autofilter and so on. if we apply these features to the downloaded excel-file from ssrs then the gridlines disappear. the normal gridlines not the border of cells.

Greets

Reinhold

reinhold
 
Posts: 10
Joined: Wed Feb 09, 2011 8:13 am

Fri Mar 04, 2011 3:25 am

I can't reappear your issue. Could you please provide your Excel file from the server and your code?? I will try my best to help you.
e-iceblue support
User avatar

iceblue support
 
Posts: 240
Joined: Tue Dec 21, 2010 2:56 am

Tue Apr 26, 2011 8:37 am

Hello,

here are the testfiles/code to verifiy the bug:


Public Sub TestMethodOpenAndSave()

Dim wb As XlsHelper.WorkbookHandler = Nothing
Dim fileName As String = String.Empty
Dim fileNameTemplate As String = String.Empty

Dim names As New List(Of XlsHelper.WorksheetName)
names.Add(New XlsHelper.WorksheetName(0, "Index"))
names.Add(New XlsHelper.WorksheetName(1, "Overview"))
names.Add(New XlsHelper.WorksheetName(2, "Details"))

Dim autoFilters As New List(Of XlsHelper.AutoFilter)
autoFilters.Add(New XlsHelper.AutoFilter(2, 8, 1))

Dim freezedPanes As New List(Of XlsHelper.FreezedPane)
freezedPanes.Add(New XlsHelper.FreezedPane(2, 9, 1))

fileNameTemplate = System.IO.Path.Combine(_TEST_DIRECTORY, "test.xls")
fileName = System.IO.Path.Combine(_TEST_DIRECTORY, String.Format("MyExcelFile97to2003_{0}.xls", Now.ToString("yyyyMMddHHmmss")))
IO.File.Copy(fileNameTemplate, fileName)
wb = New XlsHelper.WorkbookHandler(fileName, XlsHelper.XlsHelper.ExcelVersion.Version97to2003)

wb.RenameWorksheets(names)
wb.SetAutoFilters(autoFilters)
wb.FreezePanes(freezedPanes)

wb.Save()

End Sub

reinhold
 
Posts: 10
Joined: Wed Feb 09, 2011 8:13 am

Wed Apr 27, 2011 2:38 am

Hello,

Thank you for your additional informaiton.
We will fix it and notify to you.
Please let me know if you have any questions and concerns.

Best regards.
Jason Tan
Technical Support / Developer,
e-iceblue Support Team
User avatar

Jason.Tan
 
Posts: 30
Joined: Tue May 25, 2010 7:17 am

Return to Spire.XLS