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
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
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]
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
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 :)
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.
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.
Hey Jesus, the test file no longer exists. No more debugging possible. Can you please provide the file in question? This is NEEDINFO.
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
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