Ivan Radovanovic's picture

How to check if row is visible when filter is active in OpenOffice Calc or Excel

For example to check if row 5 is visible use formula subtotal(2; A5:A5) - that will return 1 if row is visible, and 0 if it is not. It should work in Excel as well.

Ivan Radovanovic's picture

Running Mono with NGINX

Important thing (if using regular expressions in server names configuration in NGINX) is to make sure to past $host as SERVER_NAME in fastcgi_params - like:
fastcgi_param SERVER_NAME $host;

Default value of $server_name will pass regexp and that will cause Mono to crash while parsing request URI.

Ivan Radovanovic's picture

Configuring default resolution for FreeBSD 11 with UEFI

If you have to set native resolution on system console (if for example you have to run scfb driver for X), first check resolutions supported by UEFI - escape to loader prompt when booting OS and type:
That should list all textual modes recognized by loader (alternatively you can also try gop list or uga list, but saving gop mode setting using following method won't work (I don't know about uga since my computer doesn't support it)). After this you can set mode you want to use using

Ivan Radovanovic's picture

If NVIDIA is not finding screens for X

Things to check:
That you have BusID in your Device section - syntax example BusID "PCI:1:0:0" (you can discover it for example using nvidia-xconfig --query-gpu-info or pciconf -lv). If you have problem with finding modes for monitor you can add Option "ModeDebug" "True" to your Device section in xorg.conf.

Ivan Radovanovic's picture

How to delete message from sendmail queue

First find it with

$ mailq
/var/spool/mqueue (1 request)
-----Q-ID----- --Size-- -----Q-Time----- ------------Sender/Recipient-----------
w0MEs0vA055142 5289 Mon Jan 22 14:54
(Deferred: Operation timed out with some server.)

Total requests: 1

Then delete it using qtool.pl (in sendmail's contrib dir):
./qtool.pl -C /etc/mail/sendmail.cf -d /var/spool/mqueue/w0MEs0vA055142

Ivan Radovanovic's picture

Command for CMake to generate makefiles showing commands


Ivan Radovanovic's picture

How to run Eclipse with debug info sent to console

By running it from command line with arguments -consoleLog -debug

Ivan Radovanovic's picture

How to build JAR from Eclipse plugin project

Right click project in project explorer window, choose "Export...", then choose "Deployable plug-ins and fragments" under "Plug-in Development". After that everything should be simple - when choosing directory to export be aware that inside that directory plugins subdirectory will be created and plugin jar will be placed in it (rather than in directory itself).


Subscribe to codenicer.com RSS