gnumeric issueshttps://gitlab.gnome.org/GNOME/gnumeric/-/issues2018-05-22T14:11:12Zhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/257Form objects are displayed as black rectangles under Windows2018-05-22T14:11:12ZBugzillaForm objects are displayed as black rectangles under Windows## Submitted by Norbert
**[Link to original bug (#732639)](https://bugzilla.gnome.org/show_bug.cgi?id=732639)**
## Description
Created attachment 279790
screen shot
See attached screen shot. Affected object types are indicated by r...## Submitted by Norbert
**[Link to original bug (#732639)](https://bugzilla.gnome.org/show_bug.cgi?id=732639)**
## Description
Created attachment 279790
screen shot
See attached screen shot. Affected object types are indicated by red frames on the tool bar.
**Attachment 279790**, "screen shot":
![Gnumeric](/uploads/7296d311dbe8cbda48a5fe7bb567d547/Gnumeric.png)
Version: 1.12.xhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/256Mouse right click disabled2018-05-29T07:14:12ZBugzillaMouse right click disabled## Submitted by numax
**[Link to original bug (#731327)](https://bugzilla.gnome.org/show_bug.cgi?id=731327)**
## Description
Mouse right click remain disabled (if click, no action).
You have to use the menu bar only.
This happens o...## Submitted by numax
**[Link to original bug (#731327)](https://bugzilla.gnome.org/show_bug.cgi?id=731327)**
## Description
Mouse right click remain disabled (if click, no action).
You have to use the menu bar only.
This happens on a Windows Seven pc 64 bit 8GB ram
This item was working on older versions of gnumeric.
Version: 1.12.xhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/255Increment cell by dragging like in other office suites2018-05-22T14:10:46ZBugzillaIncrement cell by dragging like in other office suites## Submitted by Nicolae Crefelean
**[Link to original bug (#730531)](https://bugzilla.gnome.org/show_bug.cgi?id=730531)**
## Description
So far I used a lot of MS Office versions, OpenOffice.org, LibreOffice.org, Kingsoft Office and...## Submitted by Nicolae Crefelean
**[Link to original bug (#730531)](https://bugzilla.gnome.org/show_bug.cgi?id=730531)**
## Description
So far I used a lot of MS Office versions, OpenOffice.org, LibreOffice.org, Kingsoft Office and a few others and all of them increment numeric cell values by dragging a single cell's "handler" to the right or to the bottom. If you drag it up or left the value will decrement.
Also, if you only want to copy that value to multiple cells, pressing Ctrl before releasing the mouse button will keep the same value for the whole interval. I thought this feature didn't exist in Gnumeric until I asked about it in the IRC channel. So it exists, but you have to add values to two cells and select them both when dragging the handler, so Gnumeric knows you want to increment the values.
For compatibility/usability reasons I would recommend the developers to tweak this feature to the existing behaviour in other office suites, but I have no idea how this would impact the current user base, so it's all up to the developers. At least now I know how to do it in Gnumeric.
Cheers! :)
Version: 1.10.xhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/254Cursor stays in cell with internal link although cell with the link destinati...2018-05-22T14:10:37ZBugzillaCursor stays in cell with internal link although cell with the link destination is selected## Submitted by Steff
**[Link to original bug (#729893)](https://bugzilla.gnome.org/show_bug.cgi?id=729893)**
## Description
Created attachment 276262
Screenshot to show the bug and the testcase I made to get it
Hi,
I found a litt...## Submitted by Steff
**[Link to original bug (#729893)](https://bugzilla.gnome.org/show_bug.cgi?id=729893)**
## Description
Created attachment 276262
Screenshot to show the bug and the testcase I made to get it
Hi,
I found a little bug/glitch which maybe can happen when you use internal links.
If you look at the screenshot you can see that the cursor is in A3, but cell A1 is marked.
To get this I first I made a internal link in A3 leading to A1.
Then I caused this bug by clicking fast multiple times on the link in A3. Then I get the cursor in A3 although cell A1 is selected.
When I type something, it shows in cell A3 first, but when I hit enter it shows in A1 instead.
Hope you can reproduce it to test yourself.
**Attachment 276262**, "Screenshot to show the bug and the testcase I made to get it":
![littlebug](/uploads/7c8438b928e0aacd8529b07630486328/littlebug.png)
Version: 1.12.xhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/253Roundtrip for graphs2018-05-22T14:10:20ZBugzillaRoundtrip for graphs## Submitted by an unknown user
**[Link to original bug (#728197)](https://bugzilla.gnome.org/show_bug.cgi?id=728197)**
## Description
New test t6516 fails for all formats.
Version: git master## Submitted by an unknown user
**[Link to original bug (#728197)](https://bugzilla.gnome.org/show_bug.cgi?id=728197)**
## Description
New test t6516 fails for all formats.
Version: git masterhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/252Cell comments displayed in a "marked" style2018-05-22T14:09:03ZBugzillaCell comments displayed in a "marked" style## Submitted by Steff
**[Link to original bug (#725490)](https://bugzilla.gnome.org/show_bug.cgi?id=725490)**
## Description
Created attachment 270684
Testfile for multiple bugs
In an older calculation file which I started to work ...## Submitted by Steff
**[Link to original bug (#725490)](https://bugzilla.gnome.org/show_bug.cgi?id=725490)**
## Description
Created attachment 270684
Testfile for multiple bugs
In an older calculation file which I started to work on in OpenOffice Calc, I have some cell comments displayed in the new black comment frame, but with white backround behind the text. It looks like the text is marked.
Maybe I continued work on it with LibreOffice, but I'm not sure.
Recently I switched to gnumeric 1.10.x There wasn't this bug, because the comment frame was white, so all comments looked equal.
With gnumeric 1.12.11 old comments already made in OpenOffice or LibreOffice have this bug, comments with gnumeric 1.10.x not.
I think there is no formatting option to change the appearance of buggy comments, just deleting them and rewriting helps.
A example is in my testfile in 6th sheet, 'Roxi':
B29 = old buggy comment, D29 = new comment, no problem.
**Attachment 270684**, "Testfile for multiple bugs":
[Testfile-Steff.gnumeric](/uploads/32b9036296b245b5024e8fc0210bd37d/Testfile-Steff.gnumeric)
Version: 1.12.xhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/251xlsx generated from auto-filter-tests not read by localc2018-05-22T14:08:41ZBugzillaxlsx generated from auto-filter-tests not read by localc## Submitted by an unknown user
**[Link to original bug (#725460)](https://bugzilla.gnome.org/show_bug.cgi?id=725460)**
## Description
New t6510 (yet to be committed).
The current state gets lost somewhere.
- <gnm:Filter Ar...## Submitted by an unknown user
**[Link to original bug (#725460)](https://bugzilla.gnome.org/show_bug.cgi?id=725460)**
## Description
New t6510 (yet to be committed).
The current state gets lost somewhere.
- <gnm:Filter Area="A3:G15">
- <gnm:Field Index="3" Type="expr" Op0="eq" Value0="60" ValueType0="welinder"/>
- </gnm:Filter>
+ <gnm:Filter Area="A3:G15"/>https://gitlab.gnome.org/GNOME/gnumeric/-/issues/250Grey sheet names left of the sheet which was selected when loading2018-05-22T14:08:23ZBugzillaGrey sheet names left of the sheet which was selected when loading## Submitted by Steff
**[Link to original bug (#725217)](https://bugzilla.gnome.org/show_bug.cgi?id=725217)**
## Description
Created attachment 270378
Note the color differences in the sheet names
I discovered minor differences in ...## Submitted by Steff
**[Link to original bug (#725217)](https://bugzilla.gnome.org/show_bug.cgi?id=725217)**
## Description
Created attachment 270378
Note the color differences in the sheet names
I discovered minor differences in the colors of the sheet names displayed on the left bottom of the window.
To reproduce you need to open a new .gnumeric file.
Then go to sheet3 and save.
Load the file again. Focus should be on sheet3.
The names of "sheet1" and "sheet2" look greyer then sheet3.
With more sheets in fact all sheet names left of the selected sheet should be displayed a little bit grey.
If you select "sheet1" the sheet name is displayed in black, so no problem on 1. sheet.
But if "sheet2" is selected, its name is displayed in greyish color. It's no real problem, too. But this can't be the intended behaviour, I think.
**Attachment 270378**, "Note the color differences in the sheet names":
![GreySheetnames](/uploads/1985be95071e8104247c4a0010e7c9e8/GreySheetnames.png)
Version: 1.12.xhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/249Cell comments2018-05-22T14:08:04ZBugzillaCell comments## Submitted by an unknown user
**[Link to original bug (#725168)](https://bugzilla.gnome.org/show_bug.cgi?id=725168)**
## Description
t6506
xls/biff8 is badly broken
xlsx roundtrips, but Excel doesn't see the comments at all.
Ve...## Submitted by an unknown user
**[Link to original bug (#725168)](https://bugzilla.gnome.org/show_bug.cgi?id=725168)**
## Description
t6506
xls/biff8 is badly broken
xlsx roundtrips, but Excel doesn't see the comments at all.
Version: git masterhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/248fixed colum-width helper breaks on moving data-field right2018-05-22T14:07:52ZBugzillafixed colum-width helper breaks on moving data-field right## Submitted by Sergey
**[Link to original bug (#724787)](https://bugzilla.gnome.org/show_bug.cgi?id=724787)**
## Description
Created attachment 269782
initial screen (helper is OK)
On text import (for this case usually from buffer...## Submitted by Sergey
**[Link to original bug (#724787)](https://bugzilla.gnome.org/show_bug.cgi?id=724787)**
## Description
Created attachment 269782
initial screen (helper is OK)
On text import (for this case usually from buffer, but from file should be the same) with fixed column-width.
If all column separators fits in the first screen (see gnumeric_import_initial-helper.png file attached) everything works OK (column separate helper appears on putting mouse pointer into data field).
But if not all column separators fits into first screen (and I need to move data filed right to select all needed columns), column separator helper's behaviour becomes inconsistent, up to it's complete disappearing (bit double mouse-click still points colum separator a right place, some example is on second attached image, using GIMP in expecting screenshot mode removed most of artefacts).
Maybe, it will be right to change behaviour, removing auto-appearing of field separator helper (making it appear after single mouse-click and disappear on ESC keypress)?
I use app-office/gnumeric-1.12.8 on 3.10.25 kernel Linux with x11-base/xorg-server-1.14.3-r2 (radeon video driver).
Maybe also useful: my system's sys-libs/glibc is 2.17, but I'm not shure, that used gnumeric was built against this version.
**Attachment 269782**, "initial screen (helper is OK)":
![gnumeric_import_initial-helper](/uploads/88d8782399563c14b95f199f2fb8853f/gnumeric_import_initial-helper.png)
Version: 1.12.xhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/247Separator changed from , to ;2018-05-22T14:07:27ZBugzillaSeparator changed from , to ;## Submitted by John
**[Link to original bug (#724304)](https://bugzilla.gnome.org/show_bug.cgi?id=724304)**
## Description
For a couple of years now, ssconvert has been in use on my wife's computer to import XLSs into CSV files. Th...## Submitted by John
**[Link to original bug (#724304)](https://bugzilla.gnome.org/show_bug.cgi?id=724304)**
## Description
For a couple of years now, ssconvert has been in use on my wife's computer to import XLSs into CSV files. This is done in two different programs, one in Python, the other in plain C, and the programs are used frequently (almost daily).
In C, the command was:
ssconvert -E iso-8859-1 --export-type=\"Gnumeric_stf:stf_assistant\" --export-options=\"charset=latin1 eol=unix\" %s %s\n"
Suddenly, a couple of days ago, instead of using the normal ',' separator, ssconvert switched to using ';', of course causing havoc. The same happens in Python as in C.
Of course, I can add separator=, in the export-options. But I wonder what factors could cause this sudden change. No changes have been applied recently. Are there any external factors which can influence ssconvert's behaviour? I could not discover any mention of any config files which could have been erroneously deleted.
Version: 1.10.xhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/246gnumeric saves incorrect path in reference to cell in another file2018-05-22T14:07:19ZBugzillagnumeric saves incorrect path in reference to cell in another file## Submitted by mb2..@..il.com
**[Link to original bug (#722923)](https://bugzilla.gnome.org/show_bug.cgi?id=722923)**
## Description
The format of a reference to a cell of a spreadsheet in a different file is (according to the on-l...## Submitted by mb2..@..il.com
**[Link to original bug (#722923)](https://bugzilla.gnome.org/show_bug.cgi?id=722923)**
## Description
The format of a reference to a cell of a spreadsheet in a different file is (according to the on-line documentation)
[filename]Sheet!Cell
(see https://projects.gnome.org/gnumeric/doc/sect-data-formulas.shtml#sect-data-formulas-references-tofiles )
Suppose I'm working on spreadsheet /home/jake/projects/thisyear/One.gnumeric, and I want to enter the value of the cell, e.g., in spreadsheet Two in the different directory
[/home/jake/projects/lastyear/january/weekfour/Two.gnumeric]'Sheet 1'!D35
This can be done on the second or third try in typing in the reference as given above, or by typing [../lastyear/january/weekfour/Two.gnumeric]'Sheet 1'!D35 .
However, when I save spreadsheet One with the reference to the cell in Two and later reopen spreadsheet One, the reference is wrong. It looks like
[../../../lastyear/january/weekfour/Two.gnumeric]'Sheet 1'!D35 .
That is, the saved relative reference goes too far up the directory hierarchy. So every time I open spreadsheet One, I need to correct the reference by deleting ../../ . The wrong path is shown in the data entry area as soon as I press enter after typing the correct reference, although the value in the cell is displayed correctly until I save, close spreadsheet One, and reopen it.
Version: 1.12.xhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/245Add outlier tests2018-05-22T14:07:12ZBugzillaAdd outlier tests## Submitted by Dale Shumaker
**[Link to original bug (#722456)](https://bugzilla.gnome.org/show_bug.cgi?id=722456)**
## Description
I would appreciate having an outlier test such as Dixon Q test added to gnumeric. http://en.wikiped...## Submitted by Dale Shumaker
**[Link to original bug (#722456)](https://bugzilla.gnome.org/show_bug.cgi?id=722456)**
## Description
I would appreciate having an outlier test such as Dixon Q test added to gnumeric. http://en.wikipedia.org/wiki/Q_test
This function (dixon.test) is in R and could be a starting point for adding the function to gnumeric.
http://cran.cnr.berkeley.edu/web/packages/outliers/outliers.pdfhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/244Excel data table does not work in Gnumeric2018-05-22T14:06:58ZBugzillaExcel data table does not work in Gnumeric## Submitted by hayden
**[Link to original bug (#722059)](https://bugzilla.gnome.org/show_bug.cgi?id=722059)**
## Description
I posted the below to the gnumeric list and was told to file a bug report here.
Short Version: I created...## Submitted by hayden
**[Link to original bug (#722059)](https://bugzilla.gnome.org/show_bug.cgi?id=722059)**
## Description
I posted the below to the gnumeric list and was told to file a bug report here.
Short Version: I created a data table via the menus in Excel 2000. It works fine when I open it with Excel 2000 on another machine, but does not work in Gnumeric (or Kingsoft or OpenOffice).
Details
I am running a simulation and gathering the results in a data table. The table should have a result for each time the simulation is run (just 25 times for testing purposes). If I press F9, I should get another, different set of 25 results. This works in Excel 2000. Ultimately it is intended for educational use and I would like it to run in a free spreadsheet. Opening the file in gnumeric 1.10-16 it looks fine but when I press F9 I just get 25 copies of the last run instead of results for 25 different runs. Using Kingsoft 2012, the spreadsheet looks OK on opening but if I press F9 I just see the original 25 outcomes. This is all on the machine where I created the file, and that version of Excel has several add-ins, so I copied the file to another machine and did a clean install of Office 2000. My spreadsheet still works fine in Excel 2000 without add-ins. This machine has OpenOffice 3.4 on it and when I open the spreadsheet there it is already 25 copies of the same number instead of 25 different outcomes. I installed gnumeric 1.12-9 on the second machine and it is just like 1.10-16 (does not work). It works in Excel 2000 in CrossoverOffice on a third machine running Linux. From my vantage point of total ignorance I am wondering if the alternate spreadsheets decided to speed things up by not recalculating the table "if nothing has changed". I admit the table is odd in that the input value does not appear in the quantity being calculated. In Excel, changing the input value prompts a recalculation anyway, and the result is different because the output of rand() changes each time you recalculate. As far as I know, what I am doing is standard practice for running simulations in Excel, so it seems to me a bug if gnumeric cannot do this. I am following a paper published 14 years ago. My spreadsheet file is just 20k and contains no macros or VBA -- just stuff from the default menu and function list (AFAIK). I am guessing the first step would be to see if anyone else can get this to run in Excel and confirm that it does NOT run in gnumeric. The file is at http://statland.org/temp/permtest3.xls. Cells G5:G29 is where the different programs differ.
Version: git masterhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/243conditional formatting feature: hide row /column2023-02-07T15:11:56ZBugzillaconditional formatting feature: hide row /column## Submitted by David Ronis
**[Link to original bug (#720629)](https://bugzilla.gnome.org/show_bug.cgi?id=720629)**
## Description
I'd like to be able to conditionally hide rows or columns based on some logical test on a cell (or ra...## Submitted by David Ronis
**[Link to original bug (#720629)](https://bugzilla.gnome.org/show_bug.cgi?id=720629)**
## Description
I'd like to be able to conditionally hide rows or columns based on some logical test on a cell (or range of cells). If this isn't currently possible consider this a feature request.
Thanks
David
Version: git masterhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/242[Win32] Right-click on sheet tab opens it on wrong monitor (with two monitors)2018-05-22T14:06:22ZBugzilla[Win32] Right-click on sheet tab opens it on wrong monitor (with two monitors)## Submitted by car..@..web.de
**[Link to original bug (#720182)](https://bugzilla.gnome.org/show_bug.cgi?id=720182)**
## Description
Hey,
I am experiencing a minor issue with the tab location when trying to rename or move a sheet ...## Submitted by car..@..web.de
**[Link to original bug (#720182)](https://bugzilla.gnome.org/show_bug.cgi?id=720182)**
## Description
Hey,
I am experiencing a minor issue with the tab location when trying to rename or move a sheet inside gnumeric with a two monitor system. When right-clicking the sheet to be renamed on my right monitor, the according tab opens on the left monitor. The tab itself works fine, though. The problem occured in the two most recent gnumeric-versions (1.12.8 and 1.12.9, windows)
Version: 1.12.xhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/241Cell comments get truncated when saving as .xls file2018-05-22T14:05:51ZBugzillaCell comments get truncated when saving as .xls file## Submitted by Steff
**[Link to original bug (#715110)](https://bugzilla.gnome.org/show_bug.cgi?id=715110)**
## Description
Created attachment 261354
Open the test file and save as .xls to watch yourself.
When I save a file with l...## Submitted by Steff
**[Link to original bug (#715110)](https://bugzilla.gnome.org/show_bug.cgi?id=715110)**
## Description
Created attachment 261354
Open the test file and save as .xls to watch yourself.
When I save a file with long cell comments inside as .xls file, the cell comments get truncated.
The lenght of the truncated cell comments is different.
Bye.
**Attachment 261354**, "Open the test file and save as .xls to watch yourself.":
[Comments.gnumeric](/uploads/5c742a58d3a36dac5e48d53d4b80a877/Comments.gnumeric)
Version: 1.10.xhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/240[Windows] rendering problem2018-05-22T14:05:39ZBugzilla[Windows] rendering problem## Submitted by an unknown user
**[Link to original bug (#712559)](https://bugzilla.gnome.org/show_bug.cgi?id=712559)**
## Description
With the new Windows experimental release on Windows 8:
new file
Select A1:B2
insert chart
click...## Submitted by an unknown user
**[Link to original bug (#712559)](https://bugzilla.gnome.org/show_bug.cgi?id=712559)**
## Description
With the new Windows experimental release on Windows 8:
new file
Select A1:B2
insert chart
click on insert
start dragging from somewhere in G8
While we are dragging the row headers 1 through 7 and column headers A to F are rendered just to the right and below where they should be rendered and the row headers 1 through 2 and column headers A to B disappear from there normal location.
When we stop dragging, the wrongly rendered row headers 1 through 7 and column headers A to F disappear again, but the row headers 1 through 2 and column headers A to B do not appear.
Finally when we deselect the chart, the row headers 1 through 2 and column headers A to B reappear (and the correct location).
Version: git masterhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/239When i open MS Excel xml file i don't see borders2018-05-22T14:05:18ZBugzillaWhen i open MS Excel xml file i don't see borders## Submitted by Ruslan Fatakhov
**[Link to original bug (#710438)](https://bugzilla.gnome.org/show_bug.cgi?id=710438)**
## Description
Created attachment 257614
Original ms excel xml file
Hello friends!
I have MS Excel xml file (i...## Submitted by Ruslan Fatakhov
**[Link to original bug (#710438)](https://bugzilla.gnome.org/show_bug.cgi?id=710438)**
## Description
Created attachment 257614
Original ms excel xml file
Hello friends!
I have MS Excel xml file (it's report with table data). When i open one by Gnumeric 1.12.6 i don't see borders (see attachment). MS Excel opens it correctly.
**Attachment 257614**, "Original ms excel xml file":
[1.xml](/uploads/c50fff4366f5ce94ebc5d3aec2fe9dad/1.xml)
Version: git masterhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/238Horrible ring plot display2018-05-22T14:04:49ZBugzillaHorrible ring plot display## Submitted by 12s..@..cor.de
**[Link to original bug (#708649)](https://bugzilla.gnome.org/show_bug.cgi?id=708649)**
## Description
Created attachment 255589
Terrible looking ring plot
Oh boy, last night I needed to create a ring...## Submitted by 12s..@..cor.de
**[Link to original bug (#708649)](https://bugzilla.gnome.org/show_bug.cgi?id=708649)**
## Description
Created attachment 255589
Terrible looking ring plot
Oh boy, last night I needed to create a ring plot. After entering the corresponding data and creating the chart I thought I was dreaming! Do you really think I can present this horrible locking graph to someone? (See attached screen shot.)
By all means - This should be corrected as soon as possible! Or is there anything preventing you in doing so?
I'm looking forward to your answer.
Bye
Dieter
**Attachment 255589**, "Terrible looking ring plot":
![ring_chart2](/uploads/5ae517065ebed38e482c5b35b017a1ca/ring_chart2.png)