Issue 696 - sheet ranges not working
Summary: sheet ranges not working
Status: CLOSED FIXED
Alias: None
Product: App Dev
Classification: Unclassified
Component: api (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows 2000
: P3 Trivial
Target Milestone: ---
Assignee: niklas.nebel
QA Contact: issues@www
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2001-04-12 11:02 UTC by issues@www
Modified: 2013-02-24 21:06 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description issues@www 2001-04-12 11:02:29 UTC
hi the follwing code is not working
         
        ** iam using OpenOffice 6.09 API's to read an excel file:
        ** iam unable to get maxRow and maxColumn 
        ** it reads 0 , 0 for maxRow AND maxColumn       
** the same code works fine with StarOffice5.2API's ,OpenOfficeBean.jar


 XCellRangesQuery xi = (XCellRangesQuery) UnoRuntime.queryInterface  
(XCellRangesQuery.class, oSheet);
		XSheetCellRanges ranges = xi.queryEmptyCells();
		
                CellRangeAddress add[] = ranges.getRangeAddressess();
                System.out.println("SR-->  "+add.length);
		for(int i=0;i<add.length;i++)
		{
		  if(maxR < add[i].StartRow) maxR = add[i].StartRow;
                  if(maxC < add[i].StartColumn) maxC = add[i].StartColumn;
      		}
       
		System.out.println("--->"+maxR+" --->"+maxC);

Regard's
Ananth
Comment 1 oc 2001-05-03 11:56:55 UTC
API problem
Comment 2 niklas.nebel 2001-05-03 12:15:12 UTC
Bug in queryEmptyCells.
Comment 3 niklas.nebel 2001-05-03 12:17:00 UTC
Fixed in 630. If you have version 619 or above, update 
sc/source/core/data/markdata.cxx to revision 1.3 to get the fix.
Comment 4 Raphael Bircher 2007-10-13 09:06:28 UTC
close now