As soon as there is a text in some column, any database program will treat the whole field as text.ĮxcelDB.zip (70.28 KiB) Downloaded 137 times This is not a problem if there is no text in the source column. Nevertheless, I had to format the pivot table's date column before I could group it by quarters and years. Notice that Sheet1 in Source.xlsx is a most simple, flat list with clear, separated data types.
This is an extremely useful feature in LibreOffice but not in OpenOffice. The chart is made from the registered data source. The chart has as many colmns as the import range has rows.
Start LibreOffice, call menu:Tools>Options>LibreOffice Base>Databases and register the document ExcelDB.odb as ExcelDBĬlick the list on the first sheet, call menu>Data>Refresh, enter a year between 20 and a month 1-12. The import range updates when you click any cell in it and call menu:Data>Refresh and the chart will update accordingly.Īttached is an archive with 3 Files Source.xlsx, ExcelDB.odb and ExcelDB_Report.ods Keep formatting (the formatting of the target sheet)Ĭreate your chart from the imported range CLick that, expand the and check two additional options:Ģ. Under menu:Data>Define Range you find a new database range "Import1". In the left pane open your registered database, the container and drag the right table icon into your target sheet. Get Calc's data source window (menu:View>Data Sources) It is just another view on your spreadsheet. The best way is a linked database range because it will adjust as the amount of rows changes.Įvery table in that pseudo-database represents the used area of a sheet.
0 kommentar(er)
