poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 45201] New: HSSFComment or HSSFPatriarch
Date Fri, 13 Jun 2008 17:10:47 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=45201

           Summary: HSSFComment or HSSFPatriarch
           Product: POI
           Version: unspecified
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: khsohel@gmail.com
                CC: khsohel@gmail.com


I have a blank excel sheet having some macro and command button
embadded in that. I have written a program using HSSF API to fill some
data in this sheet and create cell comment.

Now the problem is when execute this program the command button
getting removed from the excel sheet.

Please find the code i am using :

HSSFPatriarch patr = sheet.createDrawingPatriarch();//This method is
responsible for removing command button

HSSFComment comment1 = patr.createComment(new HSSFClientAnchor(2, 2,
2, 2, (short)4, 2, (short) 6, 5));
       comment1.setString(new HSSFRichTextString("We can set comments in
POI"));
                               comment1.setAuthor("Apache Software
Foundation");
                               comment1.setRow(2);

                               comment1.setColumn((short)2);


Please help me if you have any solutions or is there any way i can
create a command button and assign a macro fucntion to it, in excel
sheet using java program


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message