[sc-dev] Re: [dev] Farewell
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 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.**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: Internship 2010: Statistical Data Analysis Tool
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 wrote: > 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
Re: [sc-dev] How to access cell values in a cell range in Calc add-ins?
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 wrote:
> Hi, i have succeeded in adding a function to Calc and reading the input
> figures on a Calc spreadsheet. I'm using the .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++){
> ...
> }
> }
> but it even doesn't work
>
> Great help if one can give me a hint.
> Thanx in advance
>
> --
> ~SeekerN~
>
[sc-dev] Get individual cells inside a cell range
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
[sc-dev] Range selection and UNO awt
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
