Created attachment 114653 [details]
Name cannot be the same as a built-in name
Running the release version (did not see in the version list):
Build ID: c4c7d32d0d49397cad38d62472b0bc8acff48dd6
The file in questions is an Excel-created .xlsx (2007/2013), which contains filter-enabled columns. If the file is opened in Calc, and a filter is applied, and the file is saved, it appears to alter some internal names of the file. When re-opening the file again in Excel, you're prompted to rename them: "Name cannot be the same as a built-in name. Old name: _FilterDatabase_0". I have attached an example of one of these messages.
Naming it something else, such as "asdf", works fine, until the file is opened, filtered, and saved in Calc again. Upon opening in Excel again, you're hit again with the same issue, and a different name is again required. Calc appears to be mangling something in the file structure.
LibreOffice 18.104.22.168 does not exhibit this behavior with the same file.
This may actually be FILESAVE, not FILEOPEN.
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug.
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it.
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 114678 [details]
Sample affected file.
The attached Test File.xlsx is currently in it's 'inconsistent' state; if you open with Excel, it will prompt to rename to those items. I noticed that sometimes it does not always do it, and may take 2-3 openings before it happens. This file had been last saved with LibreOffice Calc.
After speaking about this with the person internally who brought up the issue, it seems that it's not only the filtered columns which causes this. They have received the prompts with no filters applied. However, setting these filters appears to be one method I have used to repeatedly trigger it.
(In reply to AdamD. from comment #3)
> Created attachment 114678 [details]
> Sample affected file.
What's the password of the file?
I'm sorry, I forgot to put that in. It's "testfile".
Created attachment 114691 [details]
names in LO
As you can see in Name manager these names exist. You can delete them and then you can open file in excel without message.
Created attachment 114692 [details]
excel 2010 name manager
excel's bug / even after rename, excel doesn't delete _FilterDatabase_0 (new_name)
Closing as notabug.
*** Bug 96170 has been marked as a duplicate of this bug. ***