https://bugs.documentfoundation.org/show_bug.cgi?id=168680
Bug ID: 168680
Summary: CALC UI -- User defined document properties in Calc
cannot be inserted into a calc spreadsheet
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If you are in Calc, and you provide custom document properties, they cannot be
used like they can in the Writer application.
In Writer, after the property fields have been defined, they can be inserted
into the document as a quick text for a field that needs to be updated
throughout the document. We use this with templates to make sure the user
updates all necessary fields in the document as the document properties dialog
launches on save.
Steps to Reproduce:
1. Open File --> Properties, in Calc
2. Define a new custom document property
3. click on an empty cell, hit F2, right-click, go to "insert Field" then there
are several options, but the custom document property is not there.
Actual Results:
Only "Date, Time, Date, Sheet Name, and Document Title appear on the "Insert
Field" menu. User-defined properties never appear.
Expected Results:
Maybe there could be an "other Fields" dialog that opens to allow you to select
which user-defined document field to insert, or just list all the user defined
properties as extra rows on that submenu.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
It is difficult to make a spreadsheet template that makes the user update all
the information we want them to without this feature.
I realize Calc can link cells so this feels like a dumb feature, but the
custom/user-defined document properties do nothing otherwise, and without this
feature, the user often forgets to change fields that must be changed. We have
several people using LibreOffice and we have them trained to edit the document
properties when making a writer document (thus making sure we have the
customer's correct information on saving the template into a new document).
Without the document properties populating cells, the user must scan the
document for placeholder text that we put in the template. It is embarassing
when the placeholder text goes out in the real world and even worse when the
placeholder text should have contained the information necessary to contact the
customer agian.
Even the LibreOffice help file references that a 'more fields' link should be
at the end of the insert-->fields submenu.
--
You are receiving this mail because:
You are the assignee for the bug.
