Description: since version Version: 6.4.6.2 Build-ID: 1:6.4.6-0ubuntu0.20.04.1 if I try open for example settings.xlsx file from explorer it opens unbekannt1.xlsx instead before this update it worked ! Steps to Reproduce: 1.doble cklick in explorer on the name settings.xlsx 2. 3. Actual Results: no error message but unbekannt 1 .xlsx is opened Expected Results: settings.xlsx to be opened Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: [Information automatically included from LibreOffice] Locale: de Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes
*** Bug 139937 has been marked as a duplicate of this bug. ***
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 169180 [details] self describing see short film it only me having this fault ?
(In reply to Harald Langheinrich from comment #3) > Created attachment 169180 [details] > self describing see short film Please understand, that a video could not give any insight to the real content of the file having extension .xlsx and which is opened in the video. Please provide a sample file which could be investigated for its content.
Created attachment 169192 [details] This file was create by makro Sub Settings_sichern() Dim NewWorkbook dim BasisVerzeichnis dim Settings_DateiName BasisVerzeichnis = ActiveWorkbook.Path & GetPathSeparator() Settings_DateiName = "Settings.xlsx" 'make new workbook NewWorkbook= Application.Workbooks.Add 'give it a name NewWorkbook.SaveAs filename:= BasisVerzeichnis & Settings_DateiName , CreateBackup:=True'give it a name 'put data in Workbooks(Settings_DateiName).Worksheets(1).Name="Settings-Daten" Workbooks(Settings_DateiName).Worksheets(1).Cells(1,1).value = "AblageVerzeichnis = " Workbooks(Settings_DateiName).Worksheets(1).Cells(1,2).value = AblageVerzeichnis Workbooks(Settings_DateiName).Worksheets(1).Cells(2,1).value = "AuftragsVerzeichnis = " Workbooks(Settings_DateiName).Worksheets(1).Cells(2,2).value = AuftragsVerzeichnis Workbooks(Settings_DateiName).Worksheets(1).Cells(3,1).value= "RechnungsVerzeichnis = " Workbooks(Settings_DateiName).Worksheets(1).Cells(3,2).value = RechnungsVerzeichnis Workbooks(Settings_DateiName).Worksheets(1).Cells(4,1).value= "KundenListe_PfadDateiName= " Workbooks(Settings_DateiName).Worksheets(1).Cells(4,2).value = KundenListe_PfadDateiName Workbooks(Settings_DateiName).Worksheets(1).Cells(5,1).value= "ObjektListe_PfadDateiName= " Workbooks(Settings_DateiName).Worksheets(1).Cells(5,2).value = ObjektListe_PfadDateiName Workbooks(Settings_DateiName).Worksheets(1).Cells(6,1).value= "AuftragListe_PfadDateiName= " Workbooks(Settings_DateiName).Worksheets(1).Cells(6,2).value = AuftragListe_PfadDateiName Workbooks(Settings_DateiName).Worksheets(1).Cells(7,1).value= "Artikel_PfadDateiName= " Workbooks(Settings_DateiName).Worksheets(1).Cells(7,2).value = Artikel_PfadDateiName Workbooks(Settings_DateiName).Worksheets(1).Cells(8,1).value= "Dienste_PfadDateiName= " Workbooks(Settings_DateiName).Worksheets(1).Cells(8,2).value = Dienste_PfadDateiName 'Save it Workbooks(Settings_DateiName).Save 'close it Workbooks(Settings_DateiName).Close end sub The content is defined somewhere else Saving the file works fine and makes a file if I open this file again it is a workbook with a worksheet and all the content , but without filename filename is unbekannt1.xlsx
If I run the script I get the error: "BASIC runtime error. Object variable not set" for this line: BasisVerzeichnis = ActiveWorkbook.Path & GetPathSeparator()
the extract was too short the options where missing ... and you can run it only once because NewWorkbook.SaveAs throws an error when it is already there, in the content I run this part only for the first time otherwise always open the existing one. But I made this extract only to show how I created the file which makes the problem at opening : Option VBASupport 1 Option Compatible Option explicit Global AblageVerzeichnis As string Global BasisVerzeichnis As String 'endet auf "/" Global AuftragsVerzeichnis As String 'endet auf "/" Global RechnungsVerzeichnis As String 'endet auf "/" Global Ergebnis As Variant Global TestErgebnis As Variant Global BetriebsSystemName As String Global SystemName As String Global Settings_DateiName As String Global existiert As Boolean Sub Settings_sichern() Dim NewWorkbook BasisVerzeichnis = ActiveWorkbook.Path & GetPathSeparator() Settings_DateiName = "Settings1.xlsx" 'make new workbook NewWorkbook= Application.Workbooks.Add 'give it a name NewWorkbook.SaveAs filename:= BasisVerzeichnis & Settings_DateiName , CreateBackup:=True'give it a name 'put data in Workbooks(Settings_DateiName).Worksheets(1).Name="Settings-Daten" Workbooks(Settings_DateiName).Worksheets(1).Cells(1,1).value = "AblageVerzeichnis = " Workbooks(Settings_DateiName).Worksheets(1).Cells(1,2).value = AblageVerzeichnis Workbooks(Settings_DateiName).Worksheets(1).Cells(2,1).value = "AuftragsVerzeichnis = " Workbooks(Settings_DateiName).Worksheets(1).Cells(2,2).value = AuftragsVerzeichnis Workbooks(Settings_DateiName).Save 'close it Workbooks(Settings_DateiName).Close end sub
It sounds like some problem with Ubuntu's file manager. Maybe try resetting your user profile: https://wiki.documentfoundation.org/UserProfile
At the moment the problem is history. ... but strange behavior while opening files continues and deleting my profile doesn't help first example: I mark 10 files .ods type in file manager and press open with openoffice calcualtion program ...the first or sometimes up to four of them open correctly with their own name the rest is opened as named unnamed1 ... etc. second example: I mark 10 files .xlsx type in file manager and press open with openoffice calcualtion program ... they are opened slowly but at the moment completely correct. Hope this will last , but may someone check his with .ods files Think you have some strange timeout problems....
You could also ask about it in Ubuntu's tracker: https://bugs.launchpad.net/ubuntu/+source/libreoffice/
(In reply to Harald Langheinrich from comment #9) > At the moment the problem is history. > first example: I mark 10 files .ods type in file manager and press open with > openoffice calcualtion program > > ...the first or sometimes up to four of them open correctly with their own > name the rest is opened as named unnamed1 ... etc. Maybe you should report to openoffice? This is LibreOffice. I couldn't reproduce. I don't see that this bug should remain open.