Bug 139936 - open *.xlsx file
Summary: open *.xlsx file
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.6.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 139937 (view as bug list)
Depends on:
Blocks:
 
Reported: 2021-01-27 02:21 UTC by Harald Langheinrich
Modified: 2022-07-06 10:40 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
self describing see short film (21.84 MB, video/mp4)
2021-01-27 12:21 UTC, Harald Langheinrich
Details
This file was create by makro (6.50 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-01-27 16:58 UTC, Harald Langheinrich
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Harald Langheinrich 2021-01-27 02:21:12 UTC
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
Comment 1 Timur 2021-01-27 08:54:39 UTC
*** Bug 139937 has been marked as a duplicate of this bug. ***
Comment 2 Xisco Faulí 2021-01-27 10:35:24 UTC Comment hidden (obsolete)
Comment 3 Harald Langheinrich 2021-01-27 12:21:55 UTC Comment hidden (obsolete)
Comment 4 [REDACTED] 2021-01-27 14:10:14 UTC
(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.
Comment 5 Harald Langheinrich 2021-01-27 16:58:00 UTC
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
Comment 6 BogdanB 2021-01-28 05:35:16 UTC
If I run the script I get the error: "BASIC runtime error. Object variable not set" for this line:

BasisVerzeichnis = ActiveWorkbook.Path & GetPathSeparator()
Comment 7 Harald Langheinrich 2021-01-28 08:11:30 UTC
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
Comment 8 Buovjaga 2021-12-02 12:48:10 UTC
It sounds like some problem with Ubuntu's file manager. Maybe try resetting your user profile: https://wiki.documentfoundation.org/UserProfile
Comment 9 Harald Langheinrich 2021-12-05 14:41:52 UTC
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....
Comment 10 Buovjaga 2021-12-05 15:10:53 UTC
You could also ask about it in Ubuntu's tracker: https://bugs.launchpad.net/ubuntu/+source/libreoffice/
Comment 11 Timur 2022-07-06 10:40:05 UTC
(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.