How do I force a 16x16 icon size for toolbar icons in GTK 3?

Question

so am working on a spreadsheet to simplify logging of data. However it's quite a tedious process of copy, paste & change. Is there a way I can create a Macro to copy the following:

=IF(Trade2!I16=99,0,Trade2!I15)

Paste it the cell directly below but as

=IF(Trade3!I16=99,0,Trade3!I15)

Beyond this it needs to be copied 100 times. Am at 15 typing it manually each time and losing the will to live haha This seems insanely simple but everything am trying is leading to a massive mess, am good at getting the spreadsheet side working but the coding isn't my strong point.

Any advice would be greatly appreciated

Solution

You can try this by creating/modifying ~/.config/gtk-3.0/settings.ini:

[Settings]
gtk-icon-sizes = panel-menu=16,16:panel=16,16:gtk-menu=16,16:gtk-large-toolbar=16,16:gtk-small-toolbar=16,16:gtk-button=16,16

However, your theme may override this in its theme file.

Comments

[SeanC]

if you fix the one cell in place using $ signs, you can just copy and paste: e.g. you're first formula would be =IF(Trade1!$I$16=99,0,Trade1!I15) - when you copy it, Excel will know to not change the 1st cell reference, but to change the second.

[Siddharth Rout]

Loop not required ;) This will do... Range("A1:A100").Formula = "=IF(Trade3!I1=99,0,Trade3!I1)" or whatever formula goes in A1

[steven2805]

Very close, with a little work I managed to get it working how I wanted. Just for your reference the actual code should have been Sub Main() Dim i As Long For i = 1 To 100 Range("O" & i).Formula = "=IF(Trade" & i + 1 & "!I16=99, 0, Trade" & i + 1 & "!I15)" Next i End Sub

[steven2805]

Thanks for taking the time to help its much appreciated :-)

[Quasímodo]

-1 the answer is obsolete since the end of 2013, please delete it. web.archive.org/web/20131015113808/https://developer.gnome.o‌​rg/…