Bug 122983 - Enhancement UPC Barcode check digit calculation funtion
Summary: Enhancement UPC Barcode check digit calculation funtion
Status: CLOSED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-01-25 20:59 UTC by admfubar
Modified: 2019-03-25 14:16 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description admfubar 2019-01-25 20:59:08 UTC 
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.
Comment 1 Xisco Faulí 2019-03-21 16:23:49 UTC 
@Eike, @Winfried, what your opinion here ?
Comment 2 Winfried Donkers 2019-03-23 06:20:59 UTC 
(In reply to Xisco Faulí from comment #1)
> @Eike, @Winfried, what your opinion here ?

IMHO creating and using a macro would be the best solution.

This seems a very specific use case, of which there are lots of similar situations (without possibilities to combine them in a simple, user friendly function), each with a very limited use.
I have made several barcode generator applications/scripts/macro's, and each had its own check mechanism.
Comment 3 Eike Rathke 2019-03-25 14:16:42 UTC 
Yeah right, there are dozens of barcodes, nothing for core; a user function / macro / extension is better suited.