Ask Your Question
0

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

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

Wildcard gravatar image

I thought it was here: https://wiki.documentfoundation.org/F...

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 close merge delete

Comments

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 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

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

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

Comments

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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 1,078 times

Last updated: Feb 01 '15