All Issues
24,993 verified issues
Median in Pivot Table in Excel 2010?
Astonishing that this functionality is not present in such an ancient application Is there a known workaround? I'm on about the part where you can change the aggregation type for a value field: It has sum, min, max, avg etc but not median
Shortcut to User Home Folder
I want to create a short cut to the System Folder version of my home folder. Actually, I want to do this for every user, but lets focus on a single user. I do not want to create a link to , while it is the same location, the view settings can be different and this for some reason confuses users. It…
How can I make sure that users log out of Remote Desktop sessions instead of just closing the RDP window?
We have a bunch of servers that our engineers remote desktop into, but each server has a two connection limit. We will often attempt to RDP into these boxes and we will see the "This machine has exceeded the maximum number of connections" message. It's a big pain because we have sent out several em…
A file shows in "locate" command but don't exist. Why?
I'm having a strange issue. I am currently fixing a flash install on Backtrack 5 (Based on Ubuntu). I really need to get flash to work, so I looked up on Google. On some board, one guy said that on this distribution (which is finally based on Debian) flash installs into Iceweasel-flashplugin, so we…
How to open a large file with an .tar.xz extension?
I got a 1GB file with an .tar.xz extension. Apparently, inside this single file is PDF files and ebooks. How do I open this type of file and read these files? Does ExtractNow work? Any simple tools? Windows 7 64-bit. IE 8.
Prevent Word from Including Bullet Letter when Copying Text
I'm copying quite a bit of text from Word into a text-based application, line by line. The word text is structured like this: Topic a. Item A b. Item B When I highlight , copy, and then paste into the text-based application, I get rather than just as desired. How can I prevent Word from including t…
Redirect folder on one HDD to a folder on another HDD
This may be a simple question but I couldn't find any answers - folder redirection usually refers to redirecting profile folders only. I have two hard drives in my laptop: (an SSD) and (a regular hard drive). I'd like to keep some files on but transparently access those files through the drive. For…
Extracting "one of every 10 frames" in a video using VLC or FFmpeg
I am trying to extract "exactly 1 frame of every 10" frames of a video (i.e. extract 1 , leave 9 then repeat) for scientific purposes. The video is 105 frames, 3.5 seconds, 29.97fps (h.264, .mov, produced by Nikon D3100). I have uploaded it here. VLC Below command should produce 10 frames, but it o…
How do I connect to a PostgreSQL server using LibreOffice Base?
I'm running into errors when I try to connect to a PostgreSQL server on the local machine using LibreOffice Base 3.5 (this applies to LibreOffice 4 as well): The following syntax ( ; database name ) doesn't work: When I try to test the connection on the next page, I get the following error: Error i…
How can I make the following conversion in VLC from the commandline?
I find the command line documentation a little overwhelming, given that I know almost nothing about codecs and the like... So the following is exactly what I'm doing in VLC (1.1.11) and it would be great to know what the exact command line equivalent of this would be: in Media -> Convert/Save add a…
What's the difference between - CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited)
What's the difference between - CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited) file types in excel 2010? They are all listed as a save file type, but ultimately are Comma Separated Value files.
Close SSH connection
I'm using Mac's Terminal App and I know how to connect to an external server via ssh ( ). But how do I close the connection once I'm done? Thanks.
Cannot connect to a shared network drive
I am using windows 7, I cannot connect to a shared network drive on another machine. I can ping the machine. I can remote desktop connect to the machine. The machine is on the same subnet My friend with the exact same laptop as me (and on the same network, same workgroup) can connect to the shared …
Using tmux with both emacs and vim
What is the best default key binding for tmux and why if one sometimes uses emacs and sometimes uses vim (on Linux Mint 12)? Ctrl-b is OK, but that conflicts a bit with the bash shell and emacs.
Shortcut to switch tabs in MacVim
Are there any shortcuts to switch the Tabs from one to another in MacVim? Any tips to bind the shortcuts myself in .vimrc like ⌘ + 1 for Tab 1 and ⌘ + 2 for Tab 2. For example, like switching browser tabs. edit: i'm back to working on linux. Not being forced to sufer a Mac just entered my list of d…
How can I tell if my image is CMYK from Linux command line?
I'm converting images from RGB to CMYK. How can I tell if my image is CMYK from the Linux command line?
How do I debug bash completions?
I have created some bash completion functions that all appear to work in isolation but give me unexpected results when I attempt to tab complete with them. Is it possible to connect bashdb, then attempt to tab complete something and step through to debug and determine what is going wrong?
Unknown glyph symbols on the Volume Mixer
I get these symbols on the volume mixer. It seems to happen at the end of every line. This is a nearly clean install of Windows 7 x64 (only Chrome and Firefox installed). Any idea where this could be coming from? The system is using all the default fonts. It is not a localization issue, and has sin…
How do I make my Boot Camp partition bootable again?
I needed to resize my Boot Camp partition so I used Gparted to move and resize it. This seemed to work, except that now I can't boot into Windows. I can boot into OS X just fine. OS X can recognize the Boot Camp partition and view its contents. When I try to reboot into Windows, however I get the m…
Where are my private/public SSH keys on UNIX?
I'm starting to understand how RSA and public/private key systems work, and I was wondering where my private and public SSH key are stored. When I go to my home directory, and I browse my .ssh directory (cd .ssh), I only see the "known_hosts" file, which I guess contains the public keys of differen…