Bug 105648

Summary:	Allow default date of "now" in table columns
Product:	LibreOffice	Reporter:	Peter Toye <lo>
Component:	Base	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	btomi96, jluth, lionel
Priority:	medium
Version:	unspecified
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108441

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.