[Libreoffice-bugs] [Bug 145358] Dynamic QR / Barcode creation using spreadsheet cell reference
https://bugs.documentfoundation.org/show_bug.cgi?id=145358 Heiko Tietze changed: What|Removed |Added Resolution|--- |DUPLICATE Status|UNCONFIRMED |RESOLVED --- Comment #8 from Heiko Tietze --- Thanks for reporting, pharmankur. Please add important aspects to the duplicate bug and follow the progress there. *** This bug has been marked as a duplicate of bug 138856 *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145358] Dynamic QR / Barcode creation using spreadsheet cell reference
https://bugs.documentfoundation.org/show_bug.cgi?id=145358 V Stuart Foote changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||8856 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145358] Dynamic QR / Barcode creation using spreadsheet cell reference
https://bugs.documentfoundation.org/show_bug.cgi?id=145358 --- Comment #7 from Heiko Tietze --- Changed my mind and we should make this available somehow. But I wonder if this is a duplicate of bug 138856. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145358] Dynamic QR / Barcode creation using spreadsheet cell reference
https://bugs.documentfoundation.org/show_bug.cgi?id=145358 Eike Rathke changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||8779 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145358] Dynamic QR / Barcode creation using spreadsheet cell reference
https://bugs.documentfoundation.org/show_bug.cgi?id=145358 --- Comment #6 from pharmankur --- Recently read this comment on forum requesting Dynamic QR code feature ... https://forum.openoffice.org/en/forum/viewtopic.php?f=47=106330 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145358] Dynamic QR / Barcode creation using spreadsheet cell reference
https://bugs.documentfoundation.org/show_bug.cgi?id=145358 Heiko Tietze changed: What|Removed |Added Keywords|needsUXEval | CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145358] Dynamic QR / Barcode creation using spreadsheet cell reference
https://bugs.documentfoundation.org/show_bug.cgi?id=145358 V Stuart Foote changed: What|Removed |Added Status|REOPENED|UNCONFIRMED Ever confirmed|1 |0 CC||vstuart.fo...@utsa.edu -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145358] Dynamic QR / Barcode creation using spreadsheet cell reference
https://bugs.documentfoundation.org/show_bug.cgi?id=145358 pharmankur changed: What|Removed |Added Ever confirmed|0 |1 Resolution|WONTFIX |--- Status|RESOLVED|REOPENED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145358] Dynamic QR / Barcode creation using spreadsheet cell reference
https://bugs.documentfoundation.org/show_bug.cgi?id=145358 --- Comment #5 from Heiko Tietze --- All good examples but not for a formula like =qrcode(a2;JAB). This formula is not standardized. And I'd expect a solution rather similar to the label wizard https://help.libreoffice.org/7.2/en-US/text/shared/guide/labels.html (In reply to pharmankur from comment #4) > AND it is perfectly OK to ignore this request as well if others feel so ! It's also perfectly okay to reopen the ticket :-) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145358] Dynamic QR / Barcode creation using spreadsheet cell reference
https://bugs.documentfoundation.org/show_bug.cgi?id=145358 --- Comment #4 from pharmankur --- (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 the assignee for the bug.
[Libreoffice-bugs] [Bug 145358] Dynamic QR / Barcode creation using spreadsheet cell reference
https://bugs.documentfoundation.org/show_bug.cgi?id=145358 Heiko Tietze changed: What|Removed |Added Resolution|--- |WONTFIX Status|UNCONFIRMED |RESOLVED Blocks||127232 --- Comment #3 from Heiko Tietze --- 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. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=127232 [Bug 127232] [META] QR/barcode generator's problems and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145358] Dynamic QR / Barcode creation using spreadsheet cell reference
https://bugs.documentfoundation.org/show_bug.cgi?id=145358 Heiko Tietze changed: What|Removed |Added CC||er...@redhat.com, ||rb.hensc...@t-online.de --- Comment #2 from Heiko Tietze --- 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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145358] Dynamic QR / Barcode creation using spreadsheet cell reference
https://bugs.documentfoundation.org/show_bug.cgi?id=145358 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added CC||libreoffice-ux-advise@lists ||.freedesktop.org Keywords||needsUXEval -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145358] Dynamic QR / Barcode creation using spreadsheet cell reference
https://bugs.documentfoundation.org/show_bug.cgi?id=145358 --- Comment #1 from pharmankur --- Created attachment 175969 --> https://bugs.documentfoundation.org/attachment.cgi?id=175969=edit Demo of QR / Barcode auto generation from referenced cell -- You are receiving this mail because: You are the assignee for the bug.