{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ورقة2","SSSS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"ورقة2","index":0,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["كيفية جعل الطباعة تكون مرتبة بحيث جدول في كل ورقة مهما اختلف حجمه "]
[]
["https://www.officena.net/ib/topic/113318-كيفية-جعل-الطباعة-تكون-مرتبة-بحيث-جدول-في-كل-ورقة-مهما-اختلف-حجمه/"]
[]
[]
["وهي اني اريد ان اجعل الإكسل يقوم بعمل في الطباعة  صفحة لكل جدول بذاته  مهما كان عدد صفوف الجدول"]
["كيف يكون ذلك ؟؟"]
[" اريد ان اطبع كل جدول في ورقة  ،  حتى لو تم اخفاء منه بعض الصفوف او لم اقوم بالاخفاء"]

{"sheet":"SSSS","index":1,"n_rows":134,"n_cols":28,"rows_kept":134,"cut":false,"hidden":false,"merged":[[0,13,0,14],[6,13,6,14],[7,13,7,14],[3,6,8,8],[30,6,35,8],[57,6,62,8],[84,6,89,8],[111,6,116,8],[105,0,105,3],[106,0,106,3],[132,0,132,3],[133,0,133,3],[24,0,24,3],[25,0,25,3],[51,0,51,3],[52,0,52,3],[78,0,78,3],[79,0,79,3]]}
["اليوم الأول",null,null,null,null,null,1,"محرم",1437,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["م","اسم العميل","الفرع","العنوان","مبلغ1","مبلغ2","مبلغ3","مبلغ4","مبلغ5","مبلغ6","مبلغ7","اجمالي المبالغ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E3:K3)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[2,null,null,null,null,null,1,null,null,null,null,{"$f":"SUM(E4:K4)","v":1},null,"مـــن يـــوم","الـــي يـــوم",null,null,null,null,null,null,null,null,null,null,null,1]
[3,null,null,null,null,null,null,null,null,null,null,0,null,1,2,null,null,null,null,null,null,null,null,null,null,null,1]
[4,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[5,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[6,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[7,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[8,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Hidden"]
[9,null,null,null,13,null,null,20,null,25,null,58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Hidden"]
[10,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Hidden"]
[11,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Hidden"]
[12,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Hidden"]
[13,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Hidden"]
[14,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Hidden"]
[15,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Hidden"]
[16,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Hidden"]
[17,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Hidden"]
[18,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Hidden"]
[19,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Hidden"]
[20,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Hidden"]
[21,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Hidden"]
[22,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Hidden"]
["الإجمالي النقدي",null,null,null,{"$f":"SUM(E3:E24)","v":13},{"$f":"SUM(F3:F24)","v":0},1,20,0,25,0,{"$f":"SUM(L3:L24)","v":59},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["الشيكات",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E26:K26)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
["اليوم الثاني",null,null,null,null,null,2,"محرم",1437,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["م","اسم العميل","الفرع","العنوان","مبلغ1","مبلغ2","مبلغ3","مبلغ4","مبلغ5","مبلغ6","مبلغ7","اجمالي المبالغ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[1,null,null,null,100,null,null,null,null,null,null,{"$f":"SUM(E30:K30)","v":100},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[2,null,null,null,null,null,2,null,null,null,null,{"$f":"SUM(E31:K31)","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[4,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[5,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[6,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[7,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[8,null,null,null,300,null,null,null,null,null,null,300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[9,null,null,null,400,null,null,null,null,null,null,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[10,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[11,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[12,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[13,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[14,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[15,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[16,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[17,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[18,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[19,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[20,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[21,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[22,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["الإجمالي النقدي",null,null,null,{"$f":"SUM(E30:E51)","v":800},{"$f":"SUM(F30:F51)","v":0},{"$f":"SUM(G30:G51)","v":2},{"$f":"SUM(H30:H51)","v":0},{"$f":"SUM(I30:I51)","v":0},{"$f":"SUM(J30:J51)","v":0},{"$f":"SUM(K30:K51)","v":0},{"$f":"SUM(L30:L51)","v":802},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["الشيكات",null,null,null,null,null,null,500,null,null,null,{"$f":"SUM(E53:K53)","v":500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
["اليوم الثالث",null,null,null,null,"السبت",3,"محرم",1437,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["م","اسم العميل","الفرع","العنوان","مبلغ1","مبلغ2","مبلغ3","مبلغ4","مبلغ5","مبلغ6","مبلغ7","اجمالي المبالغ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E57:K57)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[2,null,null,null,null,null,3,null,null,null,null,{"$f":"SUM(E58:K58)","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[3,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[4,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[5,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[6,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[7,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[8,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[9,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[10,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[11,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[12,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[13,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[14,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[15,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[16,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[17,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[18,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[19,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[20,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[21,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[22,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["الإجمالي النقدي",null,null,null,{"$f":"SUM(E57:E78)","v":0},{"$f":"SUM(F57:F78)","v":0},{"$f":"SUM(G57:G78)","v":3},{"$f":"SUM(H57:H78)","v":0},{"$f":"SUM(I57:I78)","v":0},{"$f":"SUM(J57:J78)","v":0},{"$f":"SUM(K57:K78)","v":0},{"$f":"SUM(L57:L78)","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["الشيكات",null,null,null,null,null,null,100,null,null,null,{"$f":"SUM(E80:K80)","v":100},null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[]
["اليوم الرابع",null,null,null,null,"السبت",4,"محرم",1437,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["م","اسم العميل","الفرع","العنوان","مبلغ1","مبلغ2","مبلغ3","مبلغ4","مبلغ5","مبلغ6","مبلغ7","اجمالي المبالغ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E84:K84)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[2,null,null,null,null,null,4,null,null,null,null,{"$f":"SUM(E85:K85)","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[3,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[4,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[5,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[6,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[7,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[8,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[9,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[10,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[11,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[12,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[13,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[14,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[15,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[16,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[17,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[18,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[19,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[20,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[21,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[22,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["الإجمالي النقدي",null,null,null,{"$f":"SUM(E84:E105)","v":0},{"$f":"SUM(F84:F105)","v":0},{"$f":"SUM(G84:G105)","v":4},{"$f":"SUM(H84:H105)","v":0},{"$f":"SUM(I84:I105)","v":0},{"$f":"SUM(J84:J105)","v":0},{"$f":"SUM(K84:K105)","v":0},{"$f":"SUM(L84:L105)","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["الشيكات",null,null,null,null,null,700,0,null,null,null,{"$f":"SUM(E107:K107)","v":700},null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[]
["اليوم الخامس",null,null,null,null,"السبت",5,"محرم",1437,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["م","اسم العميل","الفرع","العنوان","مبلغ1","مبلغ2","مبلغ3","مبلغ4","مبلغ5","مبلغ6","مبلغ7","اجمالي المبالغ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E111:K111)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[2,null,null,null,null,null,5,null,null,null,null,{"$f":"SUM(E112:K112)","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[3,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[4,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[5,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[6,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[7,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[8,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[9,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[10,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[11,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[12,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[13,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[14,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[15,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[16,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[17,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[18,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[19,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[20,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[21,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[22,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["الإجمالي النقدي",null,null,null,{"$f":"SUM(E111:E132)","v":0},{"$f":"SUM(F111:F132)","v":0},{"$f":"SUM(G111:G132)","v":5},{"$f":"SUM(H111:H132)","v":0},{"$f":"SUM(I111:I132)","v":0},{"$f":"SUM(J111:J132)","v":0},{"$f":"SUM(K111:K132)","v":0},{"$f":"SUM(L111:L132)","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["الشيكات",null,null,null,900,null,null,0,null,null,null,{"$f":"SUM(E134:K134)","v":900},null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]