Free Support Forum - aspose.com

Problem with corrupted text in workbook

Aspose.Cells Product Family
#1

hello - can you help me - i'm using aspose cells to open an existing workbook and then stream it to a browser all works fine except when the file opens in excel, the fonts and text are corrupted

HELP

(i'm using version 4.1.2.0 but i have downloaded the latest 4.4 and tied it in that and I get the same problem)

#2

Hi,

Thanks for the template file.

We will check and figure it out soon.

Thank you.

#3

Hi,

Could you post the protected password of the workbook? It will help us to check the problem.

#4

Attached is the protected workbook - the password to unprotect it is 'astra'

Ive tried opening and saving both the protected and unprotected versions and I still get the garbage text when the file is streamed to the browser

#5

Hi,

Could you post unprotected file? If i unprotected the file and save the file with Excel ,then open with Aspose.Cells, it will works fine.

#6

This is the code for opening and streaming the file I'm using - It doesnt matter whether I use the protected or unprotected file - i corrupts the file

Dim fstream As FileStream = Nothing

try

primarySheet = path + "/Docs/secondary.xls"

InitLicense() ' checks the license

Dim workbook As New Aspose.Cells.Workbook()

Dim sheet As Aspose.Cells.Worksheet

fstream = New FileStream(primarySheet, FileMode.Open)

workbook.Open(fstream)

sheet = workbook.Worksheets(0)

workbook.Save("secondary.XLS", Aspose.Cells.FileFormatType.Default, Aspose.Cells.SaveType.OpenInExcel, response)

Catch ex As Exception

Throw ex

Finally

If Not fstream Is Nothing Then fstream.Close()

End Try

End Sub

#7

Attached is a screensht of what I get from Excel when it streams

(image file is zipped)

#8

Hi Steve,

Please try this fix.