[Libreoffice-bugs] [Bug 125705] Impossible to edit any TextField (except URL) inside a spreadsheet cell by user code.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from Ross Johnson <ross.johnson at homemail.com.au> ---
This behaviour still exists in:

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 5244f02b4da126a1361a72ae07e8c53618dc920f
CPU threads: 12; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: en-AU (en_AU); UI: en-US
Calc: threaded

However, shouldn't this be regarded as desirable behaviour? I don't think this
is a bug. It looks like a feature.

The reporter noted in a macro comment that the IsFixed value changed
momentarily:

          .IsFixed      = True 'Was first accepted but later set back to False.

I couldn't reproduce this. I modified the demo macro:

          .IsFixed      = True 'Was first accepted but later set back to False.
          if (.IsFixed = True) Then
            MsgBox "Changed Ok"
          Else
            MsgBox "Did not change"
          End If

It always reported no change, even with auto-recalculate turned off.

I suspect that if any of these fields could be changed then the value would be
reset again at the next sheet recalculation run. This would be what I would
expect to occur.

The behaviour as it is would seem to be consistent with the nature of the
TextFields that Calc offers for insertion into cells. There are three:

Date:
  this is always set to today's date;

Document Title:
  set in File > Properties (or uses the basename of the file if not set);

Sheet Name:
  the name of the current spreadsheet.

These are all values that are set elsewhere in the document or the system and I
wouldn't expect to be able to change them via the textfield object in the cell.

The latter two values can be programmatically set at the document or sheet
level such that the cells that use those textfields would naturally inherit the
new value.

If a date embedded in cell text needs to be set programmatically then that is
no-doubt possible also, but the Date TextField probably shouldn't be used as
the basis for that.

-- 
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/20210921/e717c51a/attachment-0001.htm>