Created attachment 202098 [details] list of tabs I have an ods file with several tabs In an odt file menu "change database" several tabs are not proposed
Created attachment 202099 [details] list proposed in menu change database
Created attachment 202103 [details] file
Created attachment 202104 [details] file
hello, it isn't really a bug because your ods calc file doesn't respect the rules to be usable as database file : 1 - it is an older excel file converted to ods and there are some marks of this in the file 2 - Some sheets does'nt respect those rules : Sheet name: avoid spaces or special characters. Data starting in A1: Row 1 must contain column names. Each column name should be unique and must not contain dots, quotes, or SQL-reserved characters. Data should begin immediately in row 2, with no empty rows above. No empty rows or columns in the data range. Consistent column types: avoid mixing text and numbers in the same column, or Base will treat everything as text. in French : Nom de la feuille : évitez les espaces ou caractères spéciaux. Données dès A1 : La première ligne (ligne 1) doit contenir les noms de colonnes. Chaque nom de colonne doit être unique, ne pas contenir de points, de guillemets ou de caractères réservés à SQL. Les données commencent immédiatement à la ligne 2, sans lignes vides. Pas de lignes ou colonnes vides dans la plage de données. Format homogène par colonne : si possible, ne mélangez pas texte et nombre dans la même colonne, sinon Base les traitera comme du texte Ami calmant, J.P
Jurasic Pork I don't understand, even if the sheet has no column name, there are empty columns, no problem to include fields in an odt file It's the case of sheet "List Bureau" In an odt file I have include following columns (without names) <C><E><F><G><Mettre un commentaire pour fiche adhésion ====>>> and I can print all the fields _ _ _ _ A1 Mr. AIN - SIMON Georges PSH229 _ _ _ A2 M. et Mme. ALLA Jean-Marc et Catherine PSH285 PSH278 _ _ A307 Mme. ALLEM BRIGITTE For sheets name I have replaced the spaces by "_", but it doesn't change the list of sheets that I can see in an odt file So I don't understand why all sheets are not available Regards