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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
