[Libreoffice-bugs] [Bug 122983] New: Enhancement UPC Barcode check digit calculation funtion

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 122983
           Summary: Enhancement UPC Barcode check digit calculation
                    funtion
           Product: LibreOffice
           Version: 6.1.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: admfubar at gmail.com

Description:
Need function to handle check digit calculation.

Actual Results:


Expected Results:



Reproducible: Always


User Profile Reset: No



Additional Info:
Found a formula on the net. and while usable, it is clunky to use. (would
require editing cell references to use in in other cells.
e.g.
=MOD(10-MOD((SUM(RIGHT(A1,1) + MID(A1,9,1) + MID(A1,7,1) + MID(A1,5,1) +
MID(A1,3,1) + LEFT(A1,1))*3 + SUM(MID(A1,10,1) + MID(A1,8,1) + MID(A1,6,1) +
MID(A1,4,1) + MID(A1, 2, 1))), 10),10) 

A built in function that would simplify use would be greatly appreciated.

-- 
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/20190125/92183928/attachment.html>