Xls import of pivot tables loses autoformating Xls import of pivot table loses custom field settings Xls import of pivot tables does not create in sheet controls Incorrect rendering of OLE object from AutoCAD when importing Excel to CalcĮxcel-Import: Performance with cell formatingīad XLS number format should trigger: ""File error: Some number formats may have been lost."īad translation of French Excel CELLULE() functionĬalc forgets sheet password when loading/saving Excel file with password-protected sheet(s) MS Excel file import ignores "Allow User to Edit Ranges"Ĭan't enter textboxes on a protected sheet Import hyperlink assigned to an autoform impossible Warning during the import of an Excel document with VB macro Request Calc to be able to import Quicken QDF files Would like to import as a column instead of a row TXT file in Calc should not automatically bring up Writer. with fixed format files (no field delimitter) leading and trailing spaces should be automatically eliminated like in Excel. xls files using constraints on a field.Įnhancement of CSV import, i.e. User defined rules are not possible for validation. When pasting/importing date data into a spreadsheet a warning should appear if the base/null date is different between the source document and the target document. Then there should be a way to reconnect the range to an existing query in the DSB. OOO should import the existing Excel Data Range as a Spreadsheet Database Range. Words of stacked text are displayed on top of each other after import instead of being displayed as originally aligned (words are staying parallely). TXT files should not bring up Writer, 2.) It should be easy to set the text delimiter to "none" if it is not needed, 3.) The formats set for the text file columns in the CSV import dialog should be carried over Improvement of CSV file import: 1.) Opening. That is for example, the ability to sum up the sales for the month direct from the datasource and return a single cellĬalc uses too much memory (was: Calc hangs after loading a large Excel Spreadsheet) Needed is the ability to use all the Calc database functions (dsum, dget etc) but with the range being direct from the datasource (F4). Import of xlsx does not transform intersection operator "space" to AOO syntax "!" Need an XML filter to convert XML document into a tableĬalc documents get bigger when you save them in xls formatĮxported from xlsx conditional formatting override whole cell format Storage of Add-In functions, such as ERFC, is broken between releases and localizations of OOo2.Įxcel spreadsheet buttons not assigned to macrosĬalc takes long time to open xls file with html tagsĮxcel 2007 spreadsheet containing pivottables crashes calc Import of XLS-Files with numerous linked files incomplete XLS import: Number not recognized, treated as string in a sum Stale file write locks now inescapably uncorrectableĮxternal database connection returns no data (ODBC)Ĭalc Crashes when trying to open after creating second scatter plot graph Importing Excel file with installed validity check based on a formula produces faulty result Text import wizard fails to detect currency ($) by defaultĮdit toolbar button on read-only file does not work on second clickĪdd option to control opening temp files as read-only Opening attached Excel file takes 3.5 HOURS! ODS inconsistent between Apache OpenOffice and LibreOfficeīasic functions not recognized on loading XLSM fileĬan't open document that i could previously open with former OO versionįile reference fails between Mac and XP with Umlauts in filename Import from base produces alternating empty columns csv file located on remote server does not work when authentication data is passed in URL Open a copy of a read-only document results in a new, read-only document.įile is locked when Openoffice fails to openĭifference in import speed depending on use of keyboard or mouseĮquivalent of MS Office Notify Feature missing ISO 8601 timestamps with time zone not interpreted correctly When saving as XLS spreadsheet cannot be shared Insert sheet from file: Considers file suffix rather than content
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |