poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 58325] New: getShapes() returns zero if sheet has more than one embedded OLE object
Date Thu, 03 Sep 2015 13:29:35 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=58325

            Bug ID: 58325
           Summary: getShapes() returns zero if sheet has more than one
                    embedded OLE object
           Product: POI
           Version: 3.12-FINAL
          Hardware: PC
            Status: NEW
          Severity: major
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: leotamura@gmail.com

I am trying to find out the position (sheet, row, column) of each embedded file
in my workbook.

I am testing my code with two different files both created and handled
exclusively using Excel 2010:
1) lt.xlsx : only one embedded file in a single sheet
2) db.xlsx : three embedded files in a single sheet

Code:
    public static void bugcheck(String path) throws EncryptedDocumentException,
InvalidFormatException, FileNotFoundException, IOException{
        Workbook wbook = WorkbookFactory.create(new FileInputStream(path));
        if (wbook instanceof XSSFWorkbook ) {
            //test each sheet
            for (int n = 0; n < wbook.getNumberOfSheets(); n++){
                XSSFSheet sheet = ((XSSFWorkbook)wbook).getSheetAt(n);
                System.out.print("sheet " + sheet.getSheetName() + " - ");
                XSSFDrawing drawing = ((XSSFSheet)sheet).getDrawingPatriarch();
                //drawing = ((XSSFSheet)sheet).createDrawingPatriarch();

                List<XSSFShape> shapes = drawing.getShapes();
                System.out.println("drawing.getShapes().size() = " +
drawing.getShapes().size());
                Iterator<XSSFShape> it = shapes.iterator();
                while(it.hasNext()) {           
                    XSSFShape shape = it.next();
                   
System.out.println("Col1:"+((XSSFClientAnchor)shape.getAnchor()).getCol1());
                   
System.out.println("Col2:"+((XSSFClientAnchor)shape.getAnchor()).getCol2());
                   
System.out.println("Row1:"+((XSSFClientAnchor)shape.getAnchor()).getRow1());
                   
System.out.println("Row2:"+((XSSFClientAnchor)shape.getAnchor()).getRow2());

                } 
            }
        }
    }


Code returns the following:
Testing: lt.xlsx
sheet MetasNM001 - drawing.getShapes().size() = 1
Col1:1
Col2:1
Row1:2
Row2:2

Testing: db.xlsx
sheet MetasNM001 - drawing.getShapes().size() = 0
sheet Plan1 - drawing.getShapes().size() = 0


The tested files are attached to this bug submission

-- 
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