VLOOKUP/HLOOKUP now allow a single reference as the second parameter.
Signed-off-by: Kohei Yoshida <kyoshida@novell.com>

Excel then won't complain about invalid xls file
(this is some fallout from increasing Calc row limit above 65k lines)
Signed-off-by: Kohei Yoshida <kyoshida@novell.com>

Signed-off-by: Tor Lillqvist <tlillqvist@novell.com>

Check for NULL cache state to handle invalid database connection more
gracefully (i.e. without crashing).
Signed-off-by: Norbert Thiebaud <nthiebaud@gmail.com>

Signed-off-by: Kohei Yoshida <kyoshida@novell.com>

Font IDs in XF records are

* 0-based when it's less than 4, but
* 1-based when it's greater than 4.

That's what the spec says.  And apparently the font ID of 4 is still
used in BIFF5 format, but not in BIFF8.

Signed-off-by: Markus Mohrhard <markus.mohrhard@googlemail.com>

Also added unit test for this built-in function.

The key is to temporarily store all sheet-local named range data,
and insert them en masse after importing the sheet contents fully.
Signed-off-by: Markus Mohrhard <markus.mohrhard@googlemail.com>

Signed-off-by: Markus Mohrhard <markus.mohrhard@googlemail.com>

Signed-off-by: Tor Lillqvist <tlillqvist@novell.com>

Signed-off-by: Markus Mohrhard <markus.mohrhard@googlemail.com>

Refactoring of ScRangeList accidentally skipped the first element during
for loop.
Signed-off-by: Markus Mohrhard <markus.mohrhard@googlemail.com>

Simple NULL pointer checks will prevent crashes....

Signed-off-by: Kohei Yoshida <kyoshida@novell.com>

The size of the array may change during the loop, so we need to always
query it dynamically via size() instead of caching it at the beginning
of the loop.
Signed-off-by: Markus Mohrhard <markus.mohrhard@googlemail.com>

... and for autofilters || query params in those. This avoids
overwriting the hidden cells in drag-fill operation
Signed-off-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
Signed-off-by: Kohei Yoshida <kyoshida@novell.com>

Signed-off-by: Tor Lillqvist <tlillqvist@novell.com>

Signed-off-by: Kohei Yoshida <kyoshida@novell.com>

Signed-off-by: Kohei Yoshida <kyoshida@novell.com>

Signed-off-by: Kohei Yoshida <kyoshida@novell.com>

This fixes incorrect result with LINEST cell function.
Signed-off-by: Kohei Yoshida <kyoshida@novell.com>

Avoid retrieving defined name items on positions >= maNameList.size()
(boost::ptr_vector doesn't like it)
Signed-off-by: Kohei Yoshida <kyoshida@novell.com>
Signed-off-by: Michael Meeks <michael.meeks@novell.com>
Signed-off-by: Noel Power <noel.power@novell.com>

When displaying the page, header and footer borders, calc uses a fake
ScDocument with no drawing page. Create a new SdrPage if none can be
fetched from the ScDocument to create the primitive processor.
Signed-off-by: Kohei Yoshida <kyoshida@novell.com>

Signed-off-by: Kohei Yoshida <kyoshida@novell.com>

This fixes a crasher, and also some incorrect usage of standard
algorithms, where boolean values were passed which end up doing
things that the original author probably never intended.

This fixes the empty value check during unit test for the debug build
on (32-bit) Windows.
Signed-off-by: Tor Lillqvist <tlillqvist@novell.com>

Signed-off-by: Kohei Yoshida <kyoshida@novell.com>

Signed-off-by: Kohei Yoshida <kyoshida@novell.com>

Signed-off-by: Kohei Yoshida <kyoshida@novell.com>

Some of the dialog code depends on the controls being hidden unless
explicitly set visible.  Unfortunately that's not really guaranteed
so we need to make that logic explicit.