Bug 105648 - Allow default date of "now" in table columns
Summary: Allow default date of "now" in table columns
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Tables
  Show dependency treegraph
 
Reported: 2017-01-31 16:01 UTC by Peter Toye
Modified: 2019-05-01 17:19 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Peter Toye 2017-01-31 16:01:33 UTC
I often want to enter the current date in a new table record. I know that this can  be done with an "ALTER TABLE" SQL statement, but it is undocumented (and may well have different syntax in different database backends) and does not appear in the "Default" entry in the Table|Edit window.

At the very least, put the default into the Table|Edit window. It's available in the Information Schema, at least in HSQLDB.
Comment 1 Alex Thurgood 2017-02-01 10:00:08 UTC
From memory, this was a feature that previously existed in OpenOffice.org 1.x and was removed by Sun at the time because people got annoyed with it, i.e. there was a sufficiently large amount of users that hated having to delete/overwrite the default today date in order to enter the date they actually wanted.

So, in the meantime, we have lived without this feature for more than 10 years and workarounds have been developed (mostly macro based) to implement the same functionality on a case-by-case scenario.

Personally, I would be in favour of such a feature, but as I'm not the one writing the code I'll mark it as feature request for enhancement and see what others think.