Download it now!
Bug 57654 - [VBA DATALOSS APPCRASH] LibreOffice doesn't play The Worlds First Music Video In An Excel Spreadsheet by ACDC
Summary: [VBA DATALOSS APPCRASH] LibreOffice doesn't play The Worlds First Music Video...
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2012-11-28 16:02 UTC by Jesus Corrius
Modified: 2015-07-18 17:27 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Document after crah (2.37 MB, application/x-zip-compressed)
2013-04-06 14:15 UTC, Florian Reisinger
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jesus Corrius 2012-11-28 16:02:29 UTC
LibreOffice doesn't play The Worlds First Music Video In An Excel Spreadsheet by ACDC. You can find the original document in the following URL:

http://excel.acdc.com/acdc.xls

As a reference, you can see how this document should play in this Youtube video:

http://www.youtube.com/watch?v=h9_YkXHCkgA
Comment 1 Florian Reisinger 2013-04-06 14:15:43 UTC
Created attachment 77526 [details]
Document after crah

@Joel: This is a major bug with some subbugs:
- VBA code can't be executed [Okay this is the main bug and quite obvious]
-- APPCRASH, when clicking play (Everything is fine, when opening it on Excel
-- Document restore needs a long time to save the document for recovery (2-3 min on a i5-2500k machine)
-- Compare the content of the .xls before and after the crash INFORMATION got lost

Version:

OS: Win 7 x64

Version LibreOffice 3.4.5 OOO340m1 (Build:502)[Portable version] reports a "BASIC-Syntaxerror: Unexpected symbol: Get" [Translated from German.] Line: 
Get myFileId, , myArr() AND does not crash -> Regression

[BTW: OO.org 3.2 does not crash as well]
opening BugPrio chart: Critical -> High + MAB to Critical -> medium
More in the next comment
Comment 2 Florian Reisinger 2013-04-06 14:26:37 UTC
BTW: Version: Version: 4.1.0.0.alpha0+
Build ID: 61d1f8f237bb45901de9c8016ea48fab1c3570d [missing in last comment]

Tried with 3.6.6.2: "Basic-Runtimeerror '57' (Original) Geräte-E/A-Fehler [de] Device -i/O-Error and a little movement, but no sound at all [Except of an error sound ~every second and (when the video stops) continueing for a long time...

So Latest working version 3.6.6.2 IMHO broken in 4.0 First tested broken "4.0.2.2"
Compatibility problem since time of OO.org

@Joel: read the previous comment as well. It is quite a major bug and a regression, with 4.0 data loss... THIS bug has everything (Thinking of HardHack)

I need your input here.... [Reason for needinfo]
Comment 3 Julien Nabet 2013-04-06 15:32:03 UTC
I know almost nothing about macros but I wonder how it can work, since:
1) we can see this:
 Private Sub Workbook_Open()

Dim tmpPath As String

Sheet1.Activate
tmpPath = ThisWorkbook.Path
AudioFile = tmpPath & "\ACDC.wav"

which "ACDC.wav"?

2) Load module
impFile = ThisWorkbook.Path & Application.PathSeparator & _
          "logo-outline.txt"
impFile = ThisWorkbook.Path & Application.PathSeparator & _
          "12fps-45sec-cut.txt"

where are these files?

Noël: put you in cc, you might be interested
Comment 4 Florian Reisinger 2013-04-06 16:06:07 UTC
There are "embedded" in the .xls (at least the music file). You can see it, when opening it in Excel...

The regression is the crash...

Feel free to leave a comment, if you need additional information :)
Comment 5 Julien Nabet 2013-04-06 16:15:08 UTC
I would have tried to retrieve a bt but I think it should be a Windows only bug since we can read this "winmm.dll" in the macro. I'm too lazy to try to retrieve a bt on Windows even with https://wiki.documentfoundation.org/BugReport#How_to_get_a_backtrace_on_Windows, I must be too accustomed with Linux way :-)

But Jesus must know how since he created a video tuto (see http://www.youtube.com/watch?v=fppBTs215yc)
You may also put bfoman in cc (he's already retrieved a lot of bts on Windows)

Finally, perhaps try to run the macro step by step to know exactly which instruction triggers the problem/crash.
Comment 6 bfoman (inactive) 2013-05-21 08:40:48 UTC
Checked with:
LO 4.0.2.2
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit

There is no LO crash, but simple break in ExtractWAV(). Error message is: 
BASIC runtime error.
'57'
Device I/O error.

in line:
Open tmpFileName For Binary As #myFileId

When this file is first opened in Excel 2010 ACDC.wav is extracted into current dir. 
When file is available all of this is working in LibreOffice - music is played and video rendered (quite slow).

Marking as NEW - macro execution error confirmed, all details seems to be delivered.
Comment 7 retired 2014-11-10 10:53:00 UTC
Hey Jesus,

the test file no longer exists. No more debugging possible.

Can you please provide the file in question?

This is NEEDINFO.
Comment 8 QA Administrators 2015-06-08 14:28:47 UTC
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INVALID
due to lack of needed information.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO

If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.
 
Thank you for helping us make LibreOffice even better for everyone!

This NEEDINFO Message was generated on: 2015-06-08

Warm Regards,
QA Team
Comment 9 QA Administrators 2015-07-18 17:27:23 UTC
Dear Bug Submitter,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INVALID due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided):

a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. 
Please do not:
a) respond via email 
b) update the version field in the bug or any of the other details on the top section of FDO

Message generated on: 2015-07-18