Bug 138856 - Allow for input to QR-Code Generator by reference to another object
Summary: Allow for input to QR-Code Generator by reference to another object
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
6.4.6.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsUXEval
Depends on:
Blocks: QR-code
  Show dependency treegraph
 
Reported: 2020-12-12 14:28 UTC by Michael
Modified: 2022-12-08 15:29 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Michael 2020-12-12 14:28:36 UTC
Description:
The built-in QR-Code Generator ultimately only allows for input within its own pop-up configuration box. (While it can be superimposed on existing text, it replaces this text and subsequently allows for edits only within its own UI.)

Please add functionality that will allow for referencing a spreadsheet cell or a textbox or a label or some other persistent text-laden entity.

A good start would be a reference to a spreadsheet cell. This would allow for a QR-Code to result from a formula calculation in the referenced cell.

In combination with allowing for multi-line input (see bug 128718) it would allow for automated generation of bank transfer QR-Codes in invoices.

Steps to Reproduce:
1. Menu -> Insert -> Object -> QR-Code
2. Pop-up UI for QR-Code Generator opens


Actual Results:
UI only allows for direct input in text field.

Expected Results:
If no object (potentially) containing text is selected before the insert:
Toggle (e.g. Radio buttons) for choice between direct input and reference initially set to direct input. When toggled, allow for selecting a cell/textbox or similar object that will supply the input.

If an appropriate object is selected before insert, the toggle should initially be set to reference and have the object linked (read-write) and its contents displayed (read-only).


Reproducible: Always


User Profile Reset: No



Additional Info:
The UI for referencing might be modeled from parts of the existing UI for Pivot tables, but limited to only one referenced object.
Comment 1 Phoebus 2021-05-12 10:04:11 UTC
I'm also relating to this - referring to the cell to create QR, would be really useful. 
What I'd need for my purpose would be some kind of formula so I could drag it and generate QR codes for a list of records (codes) (=QR_sth(CELL)).

Would something like that be possible?
Comment 2 denialdon9 2022-02-11 13:07:48 UTC Comment hidden (spam)
Comment 3 V Stuart Foote 2022-12-08 15:29:22 UTC
This is the generic case of bug 145358 which is limited to barcode generated from content or formula result of a Calc cell.

Here it is the more versatile ask for barcode source: "...a spreadsheet cell or a textbox or a label or some other persistent text-laden entity".

+1