{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Feuil2"],"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":"Feuil1","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Date","Evenement","Date rectifiée"]
["14/07/1789","Prise Bastille",{"$f":"IFERROR(EDATE(A2*1,2400),DATE(RIGHT(A2,4)+200,MID(A2,4,2),LEFT(A2,2)))","v":"1989-07-14"}]
["09/11/1799","Coup Etat 18 brumaire",{"$f":"IFERROR(EDATE(A3*1,2400),DATE(RIGHT(A3,4)+200,MID(A3,4,2),LEFT(A3,2)))","v":"1999-11-09"}]
["1914-08-02","Début 1ere GM",{"$f":"IFERROR(EDATE(A4*1,2400),DATE(RIGHT(A4,4)+200,MID(A4,4,2),LEFT(A4,2)))","v":"2114-08-02"}]
["1918-11-11","Fin 1ere GM",{"$f":"IFERROR(EDATE(A5*1,2400),DATE(RIGHT(A5,4)+200,MID(A5,4,2),LEFT(A5,2)))","v":"2118-11-11"}]
["1939-09-01","Début 2nde GM",{"$f":"IFERROR(EDATE(A6*1,2400),DATE(RIGHT(A6,4)+200,MID(A6,4,2),LEFT(A6,2)))","v":"2139-09-01"}]
["1945-05-08","Victoire",{"$f":"IFERROR(EDATE(A7*1,2400),DATE(RIGHT(A7,4)+200,MID(A7,4,2),LEFT(A7,2)))","v":"2145-05-08"}]
["1946-12-19","Début guerre Indochine",{"$f":"IFERROR(EDATE(A8*1,2400),DATE(RIGHT(A8,4)+200,MID(A8,4,2),LEFT(A8,2)))","v":"2146-12-19"}]
["1954-04-21","Fin guerre Indochine",{"$f":"IFERROR(EDATE(A9*1,2400),DATE(RIGHT(A9,4)+200,MID(A9,4,2),LEFT(A9,2)))","v":"2154-04-21"}]
["1963-11-22","Assassinat Kennedy",{"$f":"IFERROR(EDATE(A10*1,2400),DATE(RIGHT(A10,4)+200,MID(A10,4,2),LEFT(A10,2)))","v":"2163-11-22"}]

{"sheet":"Feuil2","index":1,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Nom","Naissance","Decès","Naissance rectifiée","Decès rectifié","Evenements"]
["Jean MARTIN","04/12/1884","1953-06-13",{"$f":"IFERROR(EDATE(B2*1,2400),DATE(RIGHT(B2,4)+200,MID(B2,4,2),LEFT(B2,2)))","v":"2084-12-04"},{"$f":"IFERROR(EDATE(C2*1,2400),DATE(RIGHT(C2,4)+200,MID(C2,4,2),LEFT(C2,2)))","v":"2153-06-13"},{"$f":"evenements(D2,E2)","v":"02/08/1914 - Début 1ere GM / 11/11/1918 - Fin 1ere GM / 01/09/1939 - Début 2nde GM / 08/05/1945 - Victoire / 19/12/1946 - Début guerre Indochine / "}]
["Jacques DUPONT","1938-06-05","30/02/1975",{"$f":"IFERROR(EDATE(B3*1,2400),DATE(RIGHT(B3,4)+200,MID(B3,4,2),LEFT(B3,2)))","v":"2138-06-05"},{"$f":"IFERROR(EDATE(C3*1,2400),DATE(RIGHT(C3,4)+200,MID(C3,4,2),LEFT(C3,2)))","v":"2175-03-02"},{"$f":"evenements(D3,E3)","v":"01/09/1939 - Début 2nde GM / 08/05/1945 - Victoire / 19/12/1946 - Début guerre Indochine / 21/04/1954 - Fin guerre Indochine / 22/11/1963 - Assassinat Kennedy / "}]
[]
[]
[]
[]
[null,null,null,null,null,null,"Fonction personnalisée "]
[null,null,null,null,null,null,"Syntaxe :   =evenements(date naiss rectifiée; date decès rectifiée)"]