[Libreoffice-ux-advise] [Bug 145358] Dynamic QR / Barcode creation using spreadsheet cell reference

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from pharmankur <pharmankur at gmail.com> ---
(In reply to Heiko Tietze from comment #3)
> The ticket was on the agenda of the design meeting but didnt receive more
> input. So let's close as WF based on arguments in comment 2.

(In reply to Heiko Tietze from comment #2)
> Formulae require to be defined in the file format with cross-plattform and
> -application compatibility. So it's not working out of the box. And
> ultimately I don't see a good use case for this as QR or barcodes don't need
> to be generated in large numbers. Maybe for special cases but then you can
> run a macro.

Hi, thanks for considering the case.
I was on Diwali Vacation so could not post reply earlier.

It is true that PRESENTLY there are not many use cases of Barcode/QRCode
formula feature. But it is just because such feature DOES NOT EXIST in any
office suites !
( Baby is yet not bourn and we are discussing how it won't change the world :P
)

Just consider the fact that the world is now flooded with smart phones or
scanners with QR reading ability and data entry point using QR / barcode is
getting status of basic necessity. QR / Barcode generation ability with cell
reference formula can add excellent flexibility and ease to Libreoffice Calc
and help to penetrate its use.

Don't wait for MSoffice to add this functionality and then LO will copy it.
This is a good feature to show LO's unique benefit and distinction from others.

If the feature is a reality there are tonnes of uses can be built around it in
sectors like education / industry / retail / banking etc ... wherever data in
the cells needs to get converted dynamically to QR / Barcode for getting back
to other systems ... few wild examples of use...

Education - 
1) Library - List of books details >> QR >> Stickers >> Automate book
management
2) Students - - List of Student details >> QR >> Student ID >> Automate
attendance / school portal access
3) Assets - List of Asset-Furniture-Lab equipment details >> QR >> Asset ID
sticker >> Automate audits / maintenance procedures
.. etc ...

Industry / Retail / Banking -
1) Inventory - List of material details >> QR >> Material ID Sticker >>
Automate Material Issue / Costing / Stock etc
2) Employee / Guest Management - - List of personal details >> QR >> ID batch
print  >> Automate attendance / access
3) Invoice / Internal Documents referencing - Invoice / Document details >> QR
>> Invoice QR >> Automate order tracking / Payment / Document tracking
4) Assets - List of Assets-equipment details >> QR >> Asset ID sticker >>
Automate audits / maintenance procedures
5) Serialisation - List of production line items >> QR >> Item ID sticker >>
Automate Item tracking / warranty / track and tracing
5) MailMerge with autogenerated QR - Mailmerge Address details >> QR >> QR
Printed along side of Mailmerge document / envelope address >> Automate letter
issue / track and tracing
... etc many ... many...

Basically it will help last user to increase productivity without learning /
using complicated ERPs OR if ERPs already there, it will be easier to integrate
with ERP. As in every organisation even if EPRs exists, employees any how
prefer to maintain their own data / records in some sort of Word / Excel
documents.

Thus in my view adding this functionality in LibreOffice will be extremely
helpful for users. Just add it and prepare good tutorial around it and people
will find out newer usage of it we have not imagined yet.

AND it is perfectly OK to ignore this request as well if others feel so !

-- 
You are receiving this mail because:
You are on the CC list for the bug.