Ask Your Question

Where is the list of Base SQL functions that work when using Calc as a datasource? [closed]

asked 2015-02-01 10:03:57 +0100

Wildcard gravatar image

I thought it was here:

However, I've just tested and DATEDIFF doesn't work—it returns an error that it is unsupported.

It works fine if the embedded database is used, but not when Calc is the data source. However, some functions do still work, like ROUND.

I suppose I can get around it by adding a bunch of extra, hidden columns in the Calc spreadsheet, but that seems really ugly and clunky. A list of what actually works with Calc as the datasource would be great.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-15 15:00:59.397955


Oh, and by the way, extra hidden columns (plus pivot tables) is totally the way to go if anyone else runs into this problem ever. Either that, or skip Calc entirely and do everything from Base.

Wildcard gravatar imageWildcard ( 2015-02-06 06:46:04 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2015-02-01 23:10:57 +0100

frofa gravatar image

Here is an old specification list for SQL Functions for file based database drivers relating to Apache OpenOffice - not sure how relevant it is?

edit flag offensive delete link more


Kind of absurd that those functions haven't been expanded in the last 12 years...that document is dated 2003. However, everything I've tried from that list seems to work, and everything I couldn't get to work (before asking my question here) isn't on that list. So I think it IS the currently valid list. :) Thanks.

Wildcard gravatar imageWildcard ( 2015-02-06 06:44:13 +0100 )edit

Question Tools

1 follower


Asked: 2015-02-01 10:03:57 +0100

Seen: 1,477 times

Last updated: Feb 01 '15