Hello,
In a SpreadSheet, I would like to get resolved formula result:
- A3 is defined as =A1&A2, F0F1 is displayed
- xCell.getFormula return "=A1&A2"
What is the way to get the resolved formula result, in this case "F0F1" ?.
Formulas:
A
1 F0
2 F1
3 =A1&A2
Display:
A
1 F0
2 F1
3 F0F1
Sheet.xCell
.getType() .getFormula .getValue()
A1 TEXT "F0" 0
A2 TEXT "F1" 0
A3 FORMULA "=A1&A2" 0
Tnak's for your help.
Best regards.
------------------------------
Paul Veuve
[EMAIL PROTECTED]
------------------------------
CDI CONSEILS ET DEVELOPPEMENTS
INDUSTRIELS SA
Chemin de la Justice 15
CH-2000 NEUCHATEL
------------------------------
http://www.cdisa.ch
Phone (+41 32) 733 31 31
or (+41 78) 600 31 31
Fax (+41 32) 733 31 32
------------------------------
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.14.15/550 - Release Date: 24.11.2006
17:20
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
