Hi,
In Excel, when I used the array formula on a group of
cells, I can use like {0;1;2;3;4} for the rowValue of
the cell and {0,1,2,3,4} for the column value of the
cell.
What is the equivalent method in OpenOffice?
I have asked in the user forum, but no answer
received. I am wondering, whether
mesa rit wrote:
In Excel, when I used the array formula on a group of
cells, I can use like {0;1;2;3;4} for the rowValue of
the cell and {0,1,2,3,4} for the column value of the
cell.
What is the equivalent method in OpenOffice?
Array constants will probably be supported sometime in the future
Hi,
have you considered using jakarta-poi?
have you considered using UNO-API and loading your XLS into OO and
extract pictures using OO-API?
Yes, I got some valuable information from jakarta-poi.
Now I can extract image data of each picture.
But I don't know how to decide which cell the
刘俊峰 wrote:
A date displays 2006-6-2, but becomes 2006-6-3 when read out according to
file format.
I find that Microsoft Excel counts the days of year 1900 as 366.
Yes, that's known and documented in Microsoft's knowledge base.
How to know whether the value of a RK cell is a date?
From
Christoph Lutz wrote:
Hi Mathias,
On 5/25/06, Mathias Bauer [EMAIL PROTECTED] wrote:
is there a way to suppress the popup of InputFields when I open a
template
that contains InputFields?
I'm searching for a global configuration-option for OOo or even better
for a
way to place
Alon Keren wrote:
On 5/29/06, Mathias Bauer [EMAIL PROTECTED] wrote:
ATM it is not possible to run OOo without write access to its user
profile without getting runtime errors that at least cause an error
message. I even wouldn't exclude crashes.
Bad news for me. Still, could you be a bit
Hi �??��?峰,
On Tue, May 30, 2006 at 09:50:42 +0800, �??��?峰 wrote:
Now I can extract image data of each picture.
But I don't know how to decide which cell the picture locates.
How to get the position info of a picture?
That's in the Escher stream's client anchor data. See usage of
Hi,
between SRC680 m164 and SRC680 m170 some important performance
improvements have been integrated, most notably is the empty string no
longer reference counted. This has significantly reduced the number of
reference counter calls. I redid the measurement to see if there is
still a
Jens-Heiner Rechtien wrote:
BTW column 1 and 2 are directly comparable to the columns below, a 23%
improvement from m164 to m170, wow!
A large part of that might be due to issue 64109, which was introduced
in m162 and fixed in m167.
Niklas