The problem continues... (A simple example)
Dim Saldo as string = "-881147.42"
*saldo must be a string not a number
Hoja.Range(F, C).Value = Saldo2
...and in excel : -88,114,742.00 why?
**************************
We are using vstudio2003 and Essential Studio Backoffice v 4.400.0.51
We have a problem usin excel.
for example:
hoja.Range(F, C).Formula = FormulaFinal
and i save the book as :
ibro.SaveAs(c:\work\libro2.XLS")
where formulafinal = "881147,42+B1+881147,42"
where B1 = 10
when i open the book "c:\work\libro2.XLS" In the place of comma places point and comma
like = "881147;42+B1+881147;42" is an error
¿how can i to solve this problem?
(im sorry for my english)
Libro1_vba.zip
By Melba [Syncfusion] at 7/3/2007 6:40:58 AM
Hi Haf,
Thank you for your interest in Essential XlsIO.
You can solve this problem by using separator "." instead of ",". Please refer the following code snippet to achieve this:
[C#]
string formulafinal = "881147.42+B1+881147.42";
//Formula
sheet.Range["C5"].Formula = formulafinal;
Here is the sample for your reference:
http://websamples.syncfusion.com/samples/XlsIO.Windows/F63310/main.htmPlease let me know if you need any further assistance.
Thanks,
Melba
excel0.zip