Free Support Forum - aspose.com

Formula question

Dear Laurence,

I'm trying to get a out of workbook link to work using cell.formula. The cell has a basic cell addition formula in it already. I need to add to that formula. I'm doing the following:

Dim dsLink As DataSet = SqlHelper.ExecuteDataset(connString, CommandType.Text, "Select * from Estimate_Excel_Link where ReceiverTemplate ='" & Group & "'")

If dsLink.Tables(0).Rows.Count > 0 Then

Dim i As Integer = 0

While i < dsLink.Tables(0).Rows.Count

Dim linkCell As Cell = Excel.Worksheets(0).Cells(dsLink.Tables(0).Rows(i).Item("ReceiverCell"))

Dim cellTemp As String = linkCell.Formula

cellTemp = cellTemp & "+'\\Wwdbase\greensheet\temp\[" & EstimateID & "_" & dsLink.Tables(0).Rows(i).Item("SenderTemplate") & ".xls]Sheet1'!" & dsLink.Tables(0).Rows(i).Item("SenderCell")

linkCell.Formula = cellTemp

i += 1

End While

End If

When the browser gets redirected to the excel file saved at the end of the process, the formula in the cell becomes:

=M9+M10+'\:\[143_DOORLABOR.XLS]SHEET1'!G6

Why is it replacing the string: Wwdbase\greensheet\temp

with this string: \:\

Thanks in advance,

--Mike Morris

Hi Mike,

Currently Aspose.Cells doesn't support to assign formulas with external references. I will check and make this feature in the future releases.

Hi Mike,

I misunderstood this problem before. I find the root of this problem and fix it. Please try this attached version.