[Libreoffice-bugs] [Bug 125705] New: Impossible to edit any TextField inside a spreadsheet cell by user code.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125705

            Bug ID: 125705
           Summary: Impossible to edit any TextField inside a spreadsheet
                    cell by user code.
           Product: LibreOffice
           Version: 3.3.0 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: sdk
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jag at psilosoph.de

Created attachment 151932
  --> https://bugs.documentfoundation.org/attachment.cgi?id=151932&action=edit
The attachment announced in the report. Shall support checks.

I don't remember what was the first version implementing text fields (except
URL) at all for spreadsheet cells. Thus I report this only for my current
working version 6.2.3.2 (also tested with 6.3.0.0.alpha1)

See
https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1text_1_1textfield_1_1DateTime.html 
and
https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1sheet_1_1SheetCell.html 

A SheetCell supports com.sun.star.text.Text.
It may contain some types of TextField, among them some subtypes of .docinfo
and, most relevant, the type .DateTime. The respective text fields claim to
support the respective services.

However: While in text objects of Writer user code can process the relevant
attributes and property values of such text fields, this seems to be impossible
for spreadsheet cells. Attempts to assign new values directly don't throw
errors, but are not executed. 

Assignments of the respective properties to helper variables create copies.
Working on such a copy ends up with no way to get the copy applied as a new
setting.

Running the Basic code included with the attached example file you should be
able to confirm my claims.

Also regard this:
There is the special TextField type URL which seems to only be used in Calc.
The properties of text fields of this type can be processed as usual.

Since the .DateTime textfield (e.g.) uses some stubborn anti-ISO format you
cannot change subsequently, it is factually useless.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190605/d967e13f/attachment-0001.html>