https://issues.apache.org/bugzilla/show_bug.cgi?id=45970
Summary: Unble to read and write the formula string which has
"HTTP url"
Product: POI
Version: unspecified
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: major
Priority: P1
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
I am using HSSF api to automate our excel sheets which is really helpful. We
are able to reduce lot of manual works due to the automation with help of HSSF
api package. Thank you so much for contribution and I have one quick doubt on
handling formula's which has ( sheet reference with http address). I tried to
read and write formulas with sheet reference with http address. Looks like it's
not supported. If it's supported, kindly request you to send me some
sample/examples on how to do that.
Example : my excel sheet cell has formula as :
=('http://dummyurl/~qa/p4depot3/qa/main/doc/logan/QualityIndex/API_FVT/VC-ESX40/[VC40-ESX40-IndexRating_100608.xls]Summary'!$X$6)
when I read it using "Cell.getCellFormula()" it returns the formula string as
"(QualityIndex!$X$6)" where Quality Index is my excel sheet name.
But I don't see the way to convert the formula to the actual string which has
HTTP value. Coz, I want to modify the http location file name and set the
formula back.
I couldn't read the formula and get the value
'http://dummyurl/~qa/p4depot3/qa/main/doc/logan/QualityIndex/API_FVT/VC-ESX40/[VC40-ESX40-IndexRating_100608.xls]Summary'
as well if I try to write the above formula string using cell.setCellFormula
("('http://dummyurl/~qa/p4depot3/qa/main/doc/logan/QualityIndex/API_FVT/VC-ESX40/[VC40-ESX40-IndexRating_100608.xls]Summary'!$X$6)");
also didn't work out.
Pls let me know if this is a restriction with HSSF api or I need to use
alternate api.
Thanks in Advance,
Krishna.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
