Hi there,
assuming that in this group there may be interest in the results of
assessing the compatibility of MS Excel and OOo Calc macros/functions, I
would like to point you to the seminar paper of Franz Müller at
http://wi.wu-wien.ac.at/rgf/diplomarbeiten/index.htm#sem_200901,
entitled
Hi there,
Using the interface
http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCellRangesQuery;
the range A1:C4 is compared with the value in cell B5 (4,1) (value
1) using the queryColumnDifferences method of the range, supplying
the address of the cell 4,1 as an argument. The
the inverse
result to be wrongly reported.
On 09.07.2010 13:08, Rony G. Flatscher wrote:
Hi there,
Using the interface
http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCellRangesQuery;
the range A1:C4 is compared with the value in cell B5 (4,1) (value
1) using
Hi Niklas,
On 09.07.2010 18:16, Niklas Nebel wrote:
On 07/09/10 13:08, Rony G. Flatscher wrote:
Using the interface
http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCellRangesQuery;
the range A1:C4 is compared with the value in cell B5 (4,1) (value
1) using
Hi there,
in the process of creating a little nutshell to demonstrate how to use
the XSortable.sort(props) methods it is possible to sort the rows of a
cell range by columns successfully (including variants to copy the
sorted result to a different cell in the spreadsheet).
Trying to do the same
, and not 2).
However, in this case something strange happens as well, which I forgot
to report: the rows A25 (the one indicated to sort by) and A27 get
exchanged in the (unsorted) result !
---rony
On 18.07.2010 15:48, Rony G. Flatscher wrote:
Hi there,
in the process of creating a little
On 18.07.2010 15:57, Rony G. Flatscher wrote:
Sorry there is a typo in the output of the SortDescriptor, its
TableSortField.Field matches the one set to (I mixed up the output of
different runs with different variants in effect). So in this example
(trying to sort the columns by Name), Field
Hi there,
it turned out that I totally mis-interpreted the documentation about
IsSortColumns. If this property gets set to true, then the cell
range is sorted by columns (funny, I know :) ) by the value in the given
row. If set to false then the cell range is sorted by rows by the
value in the
Hi there,
after researching for quite some time I am turning to this list for
asking help on a possible easy/rookie question:
* having an XSheet in hands and querying it for a cell range using
getCallRangeByName(...) returns a com.sun.star.table.XCellRange
* now what is needed to
Hi Oliver,
thank you *very* much, that was it!
After reading your snippet it took me not even two (!) minutes to
finish the code-snippet.
(Before posting my plea for help, I tried for almost 90 minutes to
figure out a solution to no avail.)
Again, thank you very much indeed!
Best regards,
10 matches
Mail list logo