{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ورقة1"],"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":"ورقة1","index":0,"n_rows":56,"n_cols":15,"rows_kept":56,"cut":false,"hidden":false,"merged":[[23,0,23,4],[6,0,6,1],[6,5,6,6],[7,0,7,2],[7,5,7,6],[8,5,8,6],[0,6,0,7],[2,5,2,6],[3,5,3,6],[4,0,4,1],[5,4,5,7],[41,0,41,4],[52,0,52,4],[53,0,53,4],[9,14,23,20],[35,0,35,1],[35,5,35,6],[36,0,36,2],[36,5,36,6],[37,5,37,6],[29,6,29,7],[31,5,31,6],[32,5,32,6],[33,0,33,1],[34,4,34,7],[24,0,24,4],[12,0,12,4]]}
["المقر",null,null,null,null,null,"خاص",null,null,null,"رقم الفاتورة","تاريخ الفاتورة","اسم العميل ","اجمالى الفاتورة"]
["العنوان",null,null,null,null,null,null,null,null,null,1,"2020-12-23","شركة النور",28.5]
["البريد الاكترونى",null,null,null,null,"الفاتورة #",null,2]
["تليفــــــــــون  :"]
["سجل تجاري :  ",null,null,null,null,null,null,"Email:"]
["ملف ضــريبي :",null,null,null,"mobile: "]
["القيمة المضافة :",null,null,null,null,"2020-12-23",null,"Date:."]
["فاتورة إلى",null,null,null,null,"معرّف العميل",null,"الشروط"]
["اسم العميل /","شركة النور"]
["عنوانة /",null,null,null,null,null,null,null,null,null,null,null,null,null,"عند الضعط على زر انشاء فاتورة ينسخ الفاتورة ويلصقها اسفل الأخرى ويرحل رقم الفاتورة في العمود K المطلوب إضافة على الكود لعمل ربط تشعبى بين رقم الفاتورة في العمود k وأرقام الفاتورة اللى في الشيت "]
["تليفون /"]
[]
["البيان",null,null,null,null,"الكمية","سعر الوحدة","المبلغ"]
[null,null,null,null,null,5,5,{"$f":"IF(F14=\"\",ROUND(1*G14,2),ROUND(F14*G14,2))","v":25}]
[null,null,null,null,null,null,null,{"$f":"IF(F15=\"\",ROUND(1*G15,2),ROUND(F15*G15,2))","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
["شكراً لتعاملك معنا!",null,null,null,null,null,"الإجمالي الفرعي",{"$f":"SUM(H14:H23)","v":25}]
[{"$f":"NoToTxt(H27,\"جنيه\",\" قرش\")","v":" ثمانية وعشرون جنيه وخمسون  قرش فقط لا غير"},null,null,null,null,null,"معدل الضريبة",0.14000000000000001]
[null,null,null,null,null,null,"الخصم",{"$f":"H24*H25","v":3.5000000000000004}]
[null,null,null,null,null,null,"الإجمالي",{"$f":"H24+H26","v":28.5}]
[]
[]
["المقر",null,null,null,null,null,"خاص"]
["العنوان"]
["البريد الاكترونى",null,null,null,null,"الفاتورة #",null,1]
["تليفــــــــــون  :"]
["سجل تجاري :  ",null,null,null,null,null,null,"Email:"]
["ملف ضــريبي :",null,null,null,"mobile: "]
["القيمة المضافة :",null,null,null,null,"2020-12-23",null,"Date:."]
["فاتورة إلى",null,null,null,null,"معرّف العميل",null,"الشروط"]
["اسم العميل /","شركة النور"]
["عنوانة /"]
["تليفون /"]
[]
["البيان",null,null,null,null,"الكمية","سعر الوحدة","المبلغ"]
[null,null,null,null,null,5,5,{"$f":"IF(F43=\"\",ROUND(1*G43,2),ROUND(F43*G43,2))","v":25}]
[null,null,null,null,null,null,null,{"$f":"IF(F44=\"\",ROUND(1*G44,2),ROUND(F44*G44,2))","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
["شكراً لتعاملك معنا!",null,null,null,null,null,"الإجمالي الفرعي",{"$f":"SUM(H43:H52)","v":25}]
[{"$f":"NoToTxt(H56,\"جنيه\",\" قرش\")","v":" ثمانية وعشرون جنيه وخمسون  قرش فقط لا غير"},null,null,null,null,null,"معدل الضريبة",0.14000000000000001]
[null,null,null,null,null,null,"الخصم",{"$f":"H53*H54","v":3.5000000000000004}]
[null,null,null,null,null,null,"الإجمالي",{"$f":"H53+H55","v":28.5}]