<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Impossible to edit any TextField inside a spreadsheet cell by user code."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125705">125705</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Impossible to edit any TextField inside a spreadsheet cell by user code.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>3.3.0 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>sdk
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>jag@psilosoph.de
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=151932" name="attach_151932" title="The attachment announced in the report. Shall support checks.">attachment 151932</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=151932&action=edit" title="The attachment announced in the report. Shall support checks.">[details]</a></span>
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
<a href="https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1text_1_1textfield_1_1DateTime.html">https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1text_1_1textfield_1_1DateTime.html</a>
and
<a href="https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1sheet_1_1SheetCell.html">https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1sheet_1_1SheetCell.html</a>
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>