[api-dev] Range/Cell Address as Parameter for calc addin

2010-05-18 Thread Martin Dobiasch
Hi! I want to write a function with a rangeaddress as parameter. Is there a way to do this with java? The function should be part of an extension. (Which is written in java) The function does something like that: Public Function CSDRangeAddress(arg As Range) As String CSDRangeAddress =

Re: [api-dev] Using transformation matrices

2010-05-18 Thread Thibault Vataire
Hello Ariel, Great example, I never thought to read SDK examples. The AffineTransform class seems to be promising. It could help me to understand how matrices operates. It is even possible that I convert my extension in Java to take advantage of this class. Thank you very much. Regards

[api-dev] Limiting the selection base of a combobox based on another

2010-05-18 Thread Johannes Öberg
I'm trying to make a selection form for selecting a single customer from a database that contains quite a lot of customers. The end user will type either the birthdate of the customer, their first name or their surname; or a combination of these, any that can contain wildcards or be only partially

Re: [api-dev] Range/Cell Address as Parameter for calc addin

2010-05-18 Thread Niklas Nebel
On 05/18/10 12:53, Martin Dobiasch wrote: I want to write a function with a rangeaddress as parameter. Is there a way to do this with java? The function should be part of an extension. (Which is written in java) The function does something like that: Public Function CSDRangeAddress(arg As

Re: [api-dev] Limiting the selection base of a combobox based on another

2010-05-18 Thread Fernand Vanrie
Johannes , I think you need to use a event who fire some macro's to change the SQL statement behind the comboboxes depending on the content of the others hope it helps Fernand I'm trying to make a selection form for selecting a single customer from a database that contains quite a lot of

[api-dev] Regarding significant digits in cell

2010-05-18 Thread Madhur Kashyap
Hi, The getValue() function of a cell object returns the value with significant digits which are visible in that cell. Is there a way to get the actual value stored in the cell regardless of the significant digits consideration ? Thanks Madhur

AW: [api-dev] Range/Cell Address as Parameter for calc addin

2010-05-18 Thread Martin Dobiasch
Thanks for your help Niklas My problem is now to convert the Address Object back to a String public String CSDRangeAddress(XCellRange range) { XCellRangeAddressable xAdd= (XCellRangeAddressable)UnoRuntime.queryInterface(

Re: AW: [api-dev] Range/Cell Address as Parameter for calc addin

2010-05-18 Thread Daniel Rentz
Hello, Martin Dobiasch schrieb: My problem is now to convert the Address Object back to a String public String CSDRangeAddress(XCellRange range) { XCellRangeAddressable xAdd= (XCellRangeAddressable)UnoRuntime.queryInterface(

Re: AW: [api-dev] Range/Cell Address as Parameter for calc addin

2010-05-18 Thread Paolo Mantovani
Il 18/05/2010 19:00, Daniel Rentz ha scritto: Hello, Martin Dobiasch schrieb: My problem is now to convert the Address Object back to a String public String CSDRangeAddress(XCellRange range) { XCellRangeAddressable xAdd= (XCellRangeAddressable)UnoRuntime.queryInterface(