[sc-dev] Range selection and UNO awt

2010-07-22 Thread Pivithuru Wijegunawardana
I have created a simple GUI using UNO awt for statistical data analysis tool
in summer internship program. Now I want to get the user input data from the
spreadsheet from clac range selection. I hope to do this after user has
opened the dialog. Functionality I need is something alike the cell function
data input method. I wanted to know whether this is possible in using UNO
awt and cell range selection.

-- 
Best regards,
Pivithuru


[sc-dev] Get individual cells inside a cell range

2010-08-06 Thread Pivithuru Wijegunawardana
Hi,
I need to get the individual cells inside a cell range. But I need to do
this without giving its x and y positions. Is there any method I could get a
XCell list from a cell range? I am doing this in java.

-- 
Best regards,
Pivithuru Wijegunawardana
University of Moratuwa
Sri Lanka


Re: [sc-dev] How to access cell values in a cell range in Calc add-ins?

2010-10-17 Thread Pivithuru Wijegunawardana
Hi Nadee,

You can use com.sun.star.sheet.XCellRangeAddressable interface and
CellRangeAddress.

com.sun.star.sheet.XCellRangeAddressable xRangeAddr =
(com.sun.star.sheet.XCellRangeAddressable)
UnoRuntime.queryInterface(com.sun.star.sheet.XCellRangeAddressable.class,
xCellRange);

CellRangeAddress aRangeAddress = xRangeAddr.getRangeAddress();

From aRangeAddress you can get details about range start column,start row
 and range end column,end row. Then you can get the no of columns and rows
you have in the range

int noOfColums = aRangeAddress.EndColumn - aRangeAddress.StartColumn + 1;
int noOfRows = aRangeAddress.EndRow - aRangeAddress.StartRow + 1;

Then traverse through the range using this and you can get all the cells
inside the given range.

for (int i = 0; i  noOfColums; i++) {

for (int j = 0; j  noOfRows; j++) {

XCell cell = xCellRange.getCellByPosition(i, j);

}

Hope this might help you


-- 
Best regards,
Pivithuru Wijegunawardana
University of Moratuwa
Sri Lanka



On Mon, Oct 18, 2010 at 12:58 AM, Nadee Hwg nadsee...@gmail.com wrote:

 Hi, i have succeeded in adding a function to Calc and reading the input
 figures on a Calc spreadsheet. I'm using the projectName.impl.java file
 generated and changing its return statement so as to give the result of my
 function.

 But I can only access a pre-defined number of cells only. i.e. the size of
 the array i define in the java code. How can I access a dynamically
 determined cell range and use its values to do a computation?? [image:
 Rolling Eyes]
 eg: when the user inputs the cell values as
 2 4 7
 1 7 3
 4 3 9
 each value in one cell, and when I program to take a 3*3 array(2-D array),
 computation succeeds(obvious) But I need to extend the code to be able to
 access any sized cell range.

 I've tried out the method of creating the for loop as
 for(int i=0; ; i++){
 for(int j=0; ; j++){
 ...mycode
 }
 }
 but it even doesn't work

 Great help if one can give me a hint.
 Thanx in advance

 --
 ~SeekerN~



[sc-dev] Re: Internship 2010: Statistical Data Analysis Tool

2011-03-26 Thread Pivithuru Wijegunawardana
Hi Regina,

I am the student who developed the extension for summer internship 2010. At
the end of the internship I submitted the code and the developed extension
to my mentor Niklas Nebel. I am not quite sure whether I have to make it
available at extension repository. I will discuss this with supervisory team
for internship and take necessary action.

On Fri, Mar 25, 2011 at 8:12 PM, Regina Henschel rb.hensc...@t-online.dewrote:

 Hi all,

 There has been the project 'Internship 2010: Statistical Data Analysis
 Tool'. On Wiki
 http://wiki.services.openoffice.org/wiki/OpenOffice.org_Internship/Projects/2010/Statistical_Data_Analysis_ToolI
  read in 'Project Status' the sentences The implementation of the data
 analysis tool project has been completed. The analysis tool has all the
 above mentioned analysis methods covering variety of statistical aspects.

 But where can I find the results?

 Kind regards
 Regina
 --
 -
 To unsubscribe send email to dev-unsubscr...@sc.openoffice.org
 For additional commands send email to sy...@sc.openoffice.org
 with Subject: help




-- 
Best regards,
Pivithuru
--
-
To unsubscribe send email to dev-unsubscr...@sc.openoffice.org
For additional commands send email to sy...@sc.openoffice.org
with Subject: help


[sc-dev] Re: [dev] Farewell

2011-09-04 Thread Pivithuru Wijegunawardana
Hi Niklas,

I got the opportunity of working with you in OpenOffice.org summer
internship program last year. You were a great mentor for me and your
guidance helped me a lot throughout the internship. Thanks for everything
you did at OpenOffice.org and I wish you all the best in your new career.

On Mon, Sep 5, 2011 at 10:11 AM, Cor Nouws oo...@nouenoff.nl wrote:

 Hi Niklas,

 I remember talking with you in Beijing, between some lectures, to get some
 guidance for a Calc extension. I had to try my best to keep understanding
 your deep technical explanation... Thanks for all the good work you did at
 OpenOffice.org.

 Wishing you all the best in your new job,

 CU,
 Cor

 Niklas Nebel wrote (04-09-11 18:56)

  In case anyone is still reading these lists:

 I have left Oracle and started a new job, not related to
 OpenOffice.org. Because of this, I won't have enough time for any
 meaningful participation in the new OpenOffice.org at Apache. So
 it's time for me to say goodbye. OpenOffice.org has always been great
 fun for me, so I'm happy to see some familiar names in the Apache
 project, which makes me confident they will be able to continue the
 success of OpenOffice.org.

 Thanks everybody for a great time!
 Niklas



 --
  - Cor
  - http://nl.libreoffice.org

 --
 --**--**-
 To unsubscribe send email to 
 dev-unsubscribe@sc.openoffice.**orgdev-unsubscr...@sc.openoffice.org
 For additional commands send email to sy...@sc.openoffice.org
 with Subject: help




-- 
Best regards,
Pivithuru
-- 
-
To unsubscribe send email to dev-unsubscr...@sc.openoffice.org
For additional commands send email to sy...@sc.openoffice.org
with Subject: help