{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["تسديدات الشهر","Feuil2","Feuil3"],"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":"تسديدات الشهر","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["الاسم","المبلغ","تاريخ التسديد"]
["علي",2000,"2019-01-15"]
["رضا ",8000,"2019-03-23"]
["سمير",12500,"2019-03-26"]
["وليد",12500,"2019-03-18"]

{"sheet":"Feuil2","index":1,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,"سلام عليكم "]
[null,null,null,null,null,null,null,null,null,"سادة الاعضاء كيف حالكم اتمنى ان تكونوا في احسن حال ان شاء الله"]
[null,null,null,null,null,null,null,null,null,"اظن اني اكثرة الطلبات لكن اعرف ان كرمكم  كبير"]
[null,null,null,null,null,null,null,null,null,"طلبت سابقا عن كيفية اغلاق السطر بمجرد ان يكون الرصيد بالخلية محددة  يساوي صفر وتم حل المشكل  جزاكم الله خيرا"]
[null,null,null,null,null,null,null,null,null,"في هذه المرة  عكس المطلوب السابق هو ان لدي خلايا مغلقة لاتفتح الا اذا اصبح محتوى الخلية في العمود (B) ابتداء من سطر 10"]
[null,null,null,null,null,null,null,null,null,"اكبر من صفر مع العلم ان محتوى الخلية يجلب تلقائيا من الصفحة المجاورة |(تسديدات الشهر)"]
["الاسم","المبلغ","تاريخ التسديد",null,null,null,null,null,null,"في هذا المثال لدي  من الخلية رقم 13 الى الخلية رقم 40 مغلقة"]
[{"$f":"IF('تسديدات الشهر'!A10=\"\",\"\",'تسديدات الشهر'!A10)","v":"علي"},{"$f":"'تسديدات الشهر'!B10","v":2000},{"$f":"IF(B10>0,'تسديدات الشهر'!B10,\" \")","v":"1905-06-22"}]
[{"$f":"IF('تسديدات الشهر'!A11=\"\",\"\",'تسديدات الشهر'!A11)","v":"رضا "},{"$f":"'تسديدات الشهر'!B11","v":8000},{"$f":"IF(B11>0,'تسديدات الشهر'!B11,\" \")","v":"1921-11-25"},null,null,null,null,null,null,"  "]
[{"$f":"IF('تسديدات الشهر'!A12=\"\",\"\",'تسديدات الشهر'!A12)","v":"سمير"},{"$f":"'تسديدات الشهر'!B12","v":12500},{"$f":"IF(B12>0,'تسديدات الشهر'!B12,\" \")","v":"1934-03-22"},null,null,null,null,null,null,"اتمنى ان اجد الجواب "]
[{"$f":"IF('تسديدات الشهر'!A13=\"\",\"\",'تسديدات الشهر'!A13)","v":"وليد"},{"$f":"'تسديدات الشهر'!B13","v":12500},{"$f":"IF(B13>0,'تسديدات الشهر'!B13,\" \")","v":"1934-03-22"}]
[{"$f":"IF('تسديدات الشهر'!A14=\"\",\"\",'تسديدات الشهر'!A14)","v":""},{"$f":"'تسديدات الشهر'!B14","v":0},{"$f":"IF(B14>0,'تسديدات الشهر'!B14,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A15=\"\",\"\",'تسديدات الشهر'!A15)","v":""},{"$f":"'تسديدات الشهر'!B15","v":0},{"$f":"IF(B15>0,'تسديدات الشهر'!B15,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A16=\"\",\"\",'تسديدات الشهر'!A16)","v":""},{"$f":"'تسديدات الشهر'!B16","v":0},{"$f":"IF(B16>0,'تسديدات الشهر'!B16,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A17=\"\",\"\",'تسديدات الشهر'!A17)","v":""},{"$f":"'تسديدات الشهر'!B17","v":0},{"$f":"IF(B17>0,'تسديدات الشهر'!B17,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A18=\"\",\"\",'تسديدات الشهر'!A18)","v":""},{"$f":"'تسديدات الشهر'!B18","v":0},{"$f":"IF(B18>0,'تسديدات الشهر'!B18,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A19=\"\",\"\",'تسديدات الشهر'!A19)","v":""},{"$f":"'تسديدات الشهر'!B19","v":0},{"$f":"IF(B19>0,'تسديدات الشهر'!B19,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A20=\"\",\"\",'تسديدات الشهر'!A20)","v":""},{"$f":"'تسديدات الشهر'!B20","v":0},{"$f":"IF(B20>0,'تسديدات الشهر'!B20,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A21=\"\",\"\",'تسديدات الشهر'!A21)","v":""},{"$f":"'تسديدات الشهر'!B21","v":0},{"$f":"IF(B21>0,'تسديدات الشهر'!B21,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A22=\"\",\"\",'تسديدات الشهر'!A22)","v":""},{"$f":"'تسديدات الشهر'!B22","v":0},{"$f":"IF(B22>0,'تسديدات الشهر'!B22,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A23=\"\",\"\",'تسديدات الشهر'!A23)","v":""},{"$f":"'تسديدات الشهر'!B23","v":0},{"$f":"IF(B23>0,'تسديدات الشهر'!B23,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A24=\"\",\"\",'تسديدات الشهر'!A24)","v":""},{"$f":"'تسديدات الشهر'!B24","v":0},{"$f":"IF(B24>0,'تسديدات الشهر'!B24,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A25=\"\",\"\",'تسديدات الشهر'!A25)","v":""},{"$f":"'تسديدات الشهر'!B25","v":0},{"$f":"IF(B25>0,'تسديدات الشهر'!B25,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A26=\"\",\"\",'تسديدات الشهر'!A26)","v":""},{"$f":"'تسديدات الشهر'!B26","v":0},{"$f":"IF(B26>0,'تسديدات الشهر'!B26,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A27=\"\",\"\",'تسديدات الشهر'!A27)","v":""},{"$f":"'تسديدات الشهر'!B27","v":0},{"$f":"IF(B27>0,'تسديدات الشهر'!B27,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A28=\"\",\"\",'تسديدات الشهر'!A28)","v":""},{"$f":"'تسديدات الشهر'!B28","v":0},{"$f":"IF(B28>0,'تسديدات الشهر'!B28,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A29=\"\",\"\",'تسديدات الشهر'!A29)","v":""},{"$f":"'تسديدات الشهر'!B29","v":0},{"$f":"IF(B29>0,'تسديدات الشهر'!B29,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A30=\"\",\"\",'تسديدات الشهر'!A30)","v":""},{"$f":"'تسديدات الشهر'!B30","v":0},{"$f":"IF(B30>0,'تسديدات الشهر'!B30,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A31=\"\",\"\",'تسديدات الشهر'!A31)","v":""},{"$f":"'تسديدات الشهر'!B31","v":0},{"$f":"IF(B31>0,'تسديدات الشهر'!B31,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A32=\"\",\"\",'تسديدات الشهر'!A32)","v":""},{"$f":"'تسديدات الشهر'!B32","v":0},{"$f":"IF(B32>0,'تسديدات الشهر'!B32,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A33=\"\",\"\",'تسديدات الشهر'!A33)","v":""},{"$f":"'تسديدات الشهر'!B33","v":0},{"$f":"IF(B33>0,'تسديدات الشهر'!B33,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A34=\"\",\"\",'تسديدات الشهر'!A34)","v":""},{"$f":"'تسديدات الشهر'!B34","v":0},{"$f":"IF(B34>0,'تسديدات الشهر'!B34,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A35=\"\",\"\",'تسديدات الشهر'!A35)","v":""},{"$f":"'تسديدات الشهر'!B35","v":0},{"$f":"IF(B35>0,'تسديدات الشهر'!B35,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A36=\"\",\"\",'تسديدات الشهر'!A36)","v":""},{"$f":"'تسديدات الشهر'!B36","v":0},{"$f":"IF(B36>0,'تسديدات الشهر'!B36,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A37=\"\",\"\",'تسديدات الشهر'!A37)","v":""},{"$f":"'تسديدات الشهر'!B37","v":0},{"$f":"IF(B37>0,'تسديدات الشهر'!B37,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A38=\"\",\"\",'تسديدات الشهر'!A38)","v":""},{"$f":"'تسديدات الشهر'!B38","v":0},{"$f":"IF(B38>0,'تسديدات الشهر'!B38,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A39=\"\",\"\",'تسديدات الشهر'!A39)","v":""},{"$f":"'تسديدات الشهر'!B39","v":0},{"$f":"IF(B39>0,'تسديدات الشهر'!B39,\" \")","v":" "}]
[{"$f":"IF('تسديدات الشهر'!A40=\"\",\"\",'تسديدات الشهر'!A40)","v":""},{"$f":"'تسديدات الشهر'!B40","v":0},{"$f":"IF(B40>0,'تسديدات الشهر'!B40,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,"وجزاكم الله خيراا"]
["المجموع",{"$f":"SUM($B$10:$B$41)","v":35000},null,null,null,null,null,null,null,"والسلام عليكم  ورحمة الله تعالى وبركاته"]

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}