{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["English","Deutsch"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"English","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Input","Output","Comment"]
[1234567,{"$f":"sbEAN(A2,FALSE)","v":0},"Just the EAN-8 check digit"]
[1234567,{"$f":"sbEAN(A3)","v":"12345670"},"Full EAN-8"]
[12345670,{"$f":"sbEAN(A4)","v":true},"EAN-8 is correct"]
[12345678,{"$f":"sbEAN(A5)","v":false},"EAN-8 is incorrect"]
["123456789012",{"$f":"sbEAN(A6,FALSE)","v":8},"Just the EAN-13 check digit"]
["123456789012",{"$f":"sbEAN(A7)","v":"1234567890128"},"Full EAN-13"]
["1234567890128",{"$f":"sbEAN(A8)","v":true},"EAN-13 is correct"]
["1234567890129",{"$f":"sbEAN(A9)","v":false},"EAN-13 is incorrect"]
["12345678901234567",{"$f":"sbEAN(A10,FALSE)","v":5},"Just the EAN-18 / NVE / SSCC check digit"]
["12345678901234567",{"$f":"sbEAN(A11)","v":"123456789012345675"},"Full EAN-18"]
["123456789012345675",{"$f":"sbEAN(A12)","v":true},"EAN-18 is correct"]
["123456789012345676",{"$f":"sbEAN(A13)","v":false},"EAN-18 is incorrect"]
["9023671254823",{"$f":"sbEAN(A14,FALSE, TRUE)","v":0},"Just the EAN-14 / GTIN check digit"]
["9023671254823",{"$f":"sbEAN(A15,TRUE,TRUE)","v":"90236712548230"},"Full EAN-14 / GTIN"]
["90236712548230",{"$f":"sbEAN(A16,TRUE,TRUE)","v":true},"EAN-14 / GTIN is correct"]
["90236712548231",{"$f":"sbEAN(A17,TRUE,TRUE)","v":false},"EAN-14 / GTIN is incorrect"]
["1234567890123456789",{"$f":"sbEAN(A18)","v":{"$error":"#VALUE!"}},"Wrong length of input"]
["123456789O12",{"$f":"sbEAN(A19)","v":{"$error":"#NUM!"}},"Not a number (character 'O')"]

{"sheet":"Deutsch","index":1,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Eingabe","Ausgabe","Kommentar"]
[1234567,{"$f":"sbEAN(A2,FALSE)","v":0},"Nur die EAN-8 Prüfziffer"]
[1234567,{"$f":"sbEAN(A3)","v":"12345670"},"Ganze EAN-8"]
[12345670,{"$f":"sbEAN(A4)","v":true},"EAN-8 ist korrekt"]
[12345678,{"$f":"sbEAN(A5)","v":false},"EAN-8 ist falsch"]
["123456789012",{"$f":"sbEAN(A6,FALSE)","v":8},"Nur die EAN-13 Prüfziffer"]
["123456789012",{"$f":"sbEAN(A7)","v":"1234567890128"},"Ganze EAN-13"]
["1234567890128",{"$f":"sbEAN(A8)","v":true},"EAN-13 ist korrekt"]
["1234567890129",{"$f":"sbEAN(A9)","v":false},"EAN-13 ist falsch"]
["12345678901234567",{"$f":"sbEAN(A10,FALSE)","v":5},"Nur die EAN-18 / NVE / SSCC Prüfziffer"]
["12345678901234567",{"$f":"sbEAN(A11)","v":"123456789012345675"},"Ganze EAN-18 / NVE / SSCC"]
["123456789012345675",{"$f":"sbEAN(A12)","v":true},"EAN-18 ist korrekt"]
["123456789012345676",{"$f":"sbEAN(A13)","v":false},"EAN-18 ist falsch"]
["9023671254823",{"$f":"sbEAN(A14,FALSE, TRUE)","v":0},"Nur die EAN-14 / GTIN Prüfziffer"]
["9023671254823",{"$f":"sbEAN(A15,TRUE,TRUE)","v":"90236712548230"},"Ganze EAN-14 / GTIN"]
["90236712548230",{"$f":"sbEAN(A16,TRUE,TRUE)","v":true},"EAN-14 / GTIN ist korrekt"]
["90236712548231",{"$f":"sbEAN(A17,TRUE,TRUE)","v":false},"EAN-14 / GTIN ist falsch"]
["1234567890123456789",{"$f":"sbEAN(A18)","v":{"$error":"#VALUE!"}},"Falsche Eingabelänge"]
["123456789O12",{"$f":"sbEAN(A19)","v":{"$error":"#NUM!"}},"Ist keine Zahl (Zeichen 'O')"]