GNOME Bugzilla – Bug 312631
Macros or Scripts
Last modified: 2018-05-22 13:11:41 UTC
Version details: Win32 1.5.2 Distribution/Version: Swedish Windows 98 SE Being 100% M$-Excel compatible I expect to find macros and push buttons among the tools, but there is no such thing. If I open an Excel file, created with Swedish version of M$-Excel 2000, it generally looks very nice (looks better than OOo 1.1.4). But if there are pictures inserted in the Excel sheet they are replaced with someting else. And if there are push buttons in the Excel sheet they appear fairly correct but the caption is replaced and nothing happens when pressing the buttons.
Macros are not yet implemented, but pictures should be correctly displayed. Can you provide sample files and screenshots (of the same file displayed in excel and in gnumeric) showing the differences ?
Created attachment 50268 [details] Screen shot of an Excel file Four screen shots merged to one picture from the same Excel workbook. The left column shows sheet1 and sheet2 in Excel. The right column shows sheet1 and sheet2 in Gnumeric.
The picture with the question mark is our "unknown image type" filler. Note, that the logo picture on top is rendered fine.
WHat kind of image is the one that we render as the "unknown image type" filler?
The image file is a Windows Enhanced Meta File (EMF).
Created attachment 50371 [details] More picture related problems After starting a new clean session of Gnumeric I started with trying to insert a picture. During browsing for a picture (without having selected any picture) Gnumeric crached with the error message as attached.
Regarding EMF: This is a known shortcoming. It is hard to fix on Linux - there is no library to render EMF. Both OpenOffice and Wine have EMF code, but nobody has yet done the work of extracting that code to a library or a rendering service. A windows only fix may be possible. The good news is that the data isn't thrown away. If you change the spreadsheet and save in Excel format, the image will be there when you open it in Excel. Regarding the crash: If you can make it crash again, it would be helpful if you could describe in detail what you did before the crash. If you can get a backtrace, even better. This involves a debugger, but I don't know the details on Windows.
Created attachment 50384 [details] Cnumeric crash. Step by step. Description of Gnumeric crash. Step by step: 1. Start Gnumeric. 2. Choose to insert a picture. 3. Select C:\ 4. During the scrolling with the scroll-bar Gnumeric crashes.
I filed the crash against pango as bug 312898.
Could you give us a list of all files in c:\ please? Especially files with non-ASCII names.
If you by ASCII names mean files with 8.3 characters, then there are several files and folders not having ASCII names.
non ASCII names are names containing characters other than a..z, A..Z, 0..9 and some other characters (-,_,+,...) all having codes between 0x20 and 0x7F. As a sample, my_file_with_a_long_name.file_type is an ASCII file name.
Naturally there are folders and files with names containing Swedish characters, as I am Swedish. If the Gnumeric is depending on that the user is using only the English characters, then the code is fundamentally bad written.
Hans, Your comment "If the Gnumeric is depending on that the user is using only the English characters, then the code is fundamentally bad written." is quite counter productive. Of course Gnumeric does not assume that one uses only ASCII characters. Your crash happens in pango. A library whose whole purpose is to support non ASCII glyphs. To determine the exact cause of that bug one has to determine which string is being rendered. That's why we need to know the (non-ASCII) names of the files in your directory.
Created attachment 50484 [details] The Swedish characters Sorry if I upset someone with my comment. I have attached a picture of the characters because I think that they will not be displayed correctly, on a computer running a non Swedish operating system, if I just type them here.
Not e that the crash has been fixed with pango 1.12 that has been out for 3.5 years. Absence of macros and push buttons seems to be what is left from this report.
Push buttons are implemented (even if they currently only change the value in a cell, but that could be used to trigger a script)
-- GitLab Migration Automatic Message -- This bug has been migrated to GNOME's GitLab instance and has been closed from further activity. You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/40.