https://bugs.freedesktop.org/show_bug.cgi?id=62301
Priority: medium
Bug ID: 62301
Assignee: [email protected]
Summary: RFE: macro writing; improve interop between calc cells
and datefield control forms
Severity: enhancement
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.0.0.3 release
Component: Spreadsheet
Product: LibreOffice
In calc, setting a date on a cell from a python macro is very difficult.
The cell expects a CDate, a numerical value from some specific offset, but this
offset is not known to the user.
Furthermore, the value returned by calling getDate() on a DateField is returned
as a numerical value in a different format, e.g. 20130313 for 13/03/2013.
Converting between these different values is not simple.
A workaround for example is to use setFunction instead, using a date string
that's manually created by the user, and the function =DATEVALUE. However, this
is error prone.
Perhaps cell objects could have a setDate value, that could accept a date in
different formats, including the ISO 8601 format used by DateFields?
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
