{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["SHEET1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"SHEET1","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,0,17,2]]}
[]
[]
[null,null,null,null,"كود الموظف","بداية الاجازة","نهاية الاجازة"]
["\nفي الخلية E4 يتم وضع كود الموظف وفي الخلية F4 تاريخ بداية الاجازة وفي الخلية G4 تاريخ نهاية الاجازة \n\nعند كتابة كود الموظف يتم استدعاء اخر إجازة للموظف لكن بعد ادخال الاجازة الجديدة وطباعة الصفحة تتغير اخر اجازة للموظف الى نفس الاجازة المطلوبة وأريد ان تظل كما هي آخر إجازة حصل عليها قبل الاجازة الجديدة"]
[null,null,null,null,"اخر إجازة",{"$f":"IFERROR(LOOKUP(2,1/($E$7:$E$100000=E4), $F$7:$F$100000),\"\")","v":"00:00:00"},{"$f":"IFERROR(LOOKUP(2,1/($E$7:$E$100000=E4), $G$7:$G$100000),\"\")","v":"00:00:00"}]
[]
[null,null,null,null,507,"2022-01-01","2022-01-31"]
[null,null,null,null,508,"2022-02-02","2022-02-28"]
[null,null,null,null,509,"2022-03-03","2022-03-31"]
[null,null,null,null,507,"2022-04-04","2022-04-30"]
[null,null,null,null,511,"2022-05-05","2022-05-31"]
[null,null,null,null,507,"2022-06-06","2022-06-30"]
[null,null,null,null,513,"2022-07-07","2022-07-31"]
[null,null,null,null,514,"2022-08-08","2022-08-31"]
[null,null,null,null,515,"2022-09-09","2022-09-30"]
[null,null,null,null,507,"2022-10-10","2022-10-30"]
[null,null,null,null,507,"2022-11-11","2022-11-30"]
[null,null,null,null,507,"2022-12-12","2022-12-31"]
[null,null,null,null,507,"2023-01-01","2023-01-10"]