Completed
Last Updated: 12 Dec 2018 13:36 by ADMIN
ADMIN
Martin
Created on: 29 Oct 2018 13:18
Category: Spreadsheet
Type: Bug Report
1
SpreadProcessing: Documents with a global filter cannot be imported
Xlsx documents with a global filter defined cannot be imported. Message box "The name that you entered is not valid." is shown and internally SpreadsheetNameException is thrown. MS Excel can import such document and even preserve the filter, but do not respect it and doesn't have UI to clear it.

Workaround 1 (includes processing the document with MS Excel):
- Open the document in MS Excel
- Choose Formulas -> Defined names -> Named Manager
- Choose Filter -> Names with errors
- Find all Filter defined names and delete them
- Save the document
1 comment
ADMIN
Peshito
Posted on: 12 Dec 2018 13:36
Fix available in LIB Version 2018.3.1012.