Insert sheet defaults prefered over gnumeric defaults
Submitted by Jose Da Silva
Please describe the problem:
I currently have gnumeric set as Helvetica font=9 as a general preference, but
I have a sheet set as Times font=12. When inserting some cells, the new
inserted cells take-on the gnumeric default value of Helvetica font=9 instead
of this particular sheet default which is Times font=12.
I notice that gnumeric 1.6.x (relative to version1.4.2) has fixed the "insert
row of cells" and also fixed the "insert column of cells" but the insert group
of cells is still not fixed or got forgotten during the fixing process.
Just for your info, version 1.4.2 has all the inserts hard-coded to sans font=10, so I'm glad to know that gnumeric version 1.6.x has improved/fixed the bug mentioned (except for the insert cells).
Steps to reproduce:
Start gnumeric and set the preferences to something other than sans font=10 (I mention this step since version 1.4.2 apparently seemed hardcoded to insert new cells as sans font=10). Then close gnumeric so that you start step2 with a fresh gnumeric that selects the new preferred font type.
Start gnumeric and select the default sheet cell so that you highlight all cells on the spreadsheet (top-left above cell A-1).
After you highlight all the cells in step 2 above, then on the menu select "Format->cells" to open the "Format cells menu" and select a default font and size other than what you set in your gnumeric preferences in step 1, so if step 1 you selected gnumeric preferences of Helvetica font=9, then here you select sheet preferences of "Times font=12"
Insert some random data in a 4x4 grid, for example: B2=Hello, C2=5, D2=100, E2=Go B3=7, C3=Hi, D3=Where, E3=6 B4=x, C4=x, D4=y, E4=y B5=z, C5=z, D5=99, E5=-1.5
Using your mouse or cursor keys, select or highlight 2x2 cells at C3,D3,C4,D4 and then on the menu select "Insert->cells"
I usually need to insert a row of data, so I suggest select move data down when you insert a new 2x2 block within C3,D3,C4,D4
If you selected the preferences mentioned in step 3, then look at the cell attributes and you will note that the inserted cells now are set to the gnumeric default of Helvetica font=9 instead of the sheet preference of Times font=12.
Actual results: The spreadsheet ends up having inserted cells that take on the gnumeric preferences instead of the sheet defaults which may be set to a default that is not the same as the normal gnumeric preferences you usually use.
Expected results: I expected the inserted cells to take on the sheet preferences because the sheet was set by someone else that has different preferences to what I like. therefore I would like to insert new cells using their preferences instead of mine.
Does this happen every time? It happens with gnumeric 1.4.2 and gnumeric 1.6.x
I am glad to see that version 1.6.x has the "insert column" (example high-light row B) and "insert row" (example highlight row 2) fixed compared to 1.4.2 but the only one apparently missed is when you highlight a 1 cell or a group of cells.
Other information: I think it is probably a bug instead of a feature since I use another spreadsheet and the default action is for it to take the sheet preference instead of the application program default. For reference, I'm comparing it to the spreadsheet program that shipped with OS/2warp3. I don't know how other spreadsheets behave in this circumstance, or if they behave the same way or differently than what is described here. Thanks!