Wikipedia:Reference desk/Archives/Computing/2014 December 23

Welcome to the Wikipedia Computing Reference Desk Archives
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages.

December 23

The Mysterious Android Hiding Bar

The first-generation Nexus 7 tablet

What is the name for the black-and-white navigation bar (back, UI, select opened app, volume +/- ..., not these app icons) at the very bottom of the Android interface?

My Android 4.4.2 no-brand tablet sometimes keeps on hiding this bar. Most of the times I can swipe out the bar if I try hard enough. Sometimes, the bar just refuse to show up. Is there a way to set this bar always on? -- Toytoy (talk) 03:55, 23 December 2014 (UTC)

sarees

Request for opinion Tevildo (talk) 11:10, 23 December 2014 (UTC)
The following discussion has been closed. Please do not modify it.
which is the best online store to buy sarees with traditional or stylish, modern with affordable costs. — Preceding unsigned comment added by Venellasravs (talk • contribs) 07:03, 23 December 2014 (UTC) I don't know, but I bet you will come to tell us where to buy them under a different account name soon... — Preceding unsigned comment added by 217.158.236.14 (talk) 10:57, 23 December 2014 (UTC)

Turning excel into a grid

What height a width would I use to turn a standard excel page into a perfect grid?205.143.205.150 (talk) 20:35, 23 December 2014 (UTC)

The required grid measure is up to you, try an use the print preview.

Marking the whole sheet CTRL+A and moving the width of col A as wide as posible, doubleclick between line 1 and 2, mouse cursor looks like this: ←|→ then doubleclick between col A and B. Your table should have optimal formatted cells. --Hans Haase (有问题吗) 20:47, 23 December 2014 (UTC)

Sorry I used some incorrect words. I know I can set the height and width to anything I want what I am looking for is perfect squares for a graph paper effect. It seems that the units of measurment that the height and width are measured in are different one is pica the other is inches ( I think ) so they have to have a certain ration of one to the other to make the perfect squares. What would that raito be?205.143.205.150 (talk) 20:57, 23 December 2014 (UTC)

The ratio is a little hard to work out due to the way Excel measures rows and columns. This support page notes that "width of cells is displayed in characters and pixels... the height of cells is displayed in points and pixels." Note however that pixels are only displayed when you actually use the cursor to drag the cell boundary; if you use the cell format menu to set width or height you will only see a number in characters (for column width) or points (for row height). While there is a conversion of 18 points = 24 pixels (see the link above), the conversion for characters isn't so exact. Trial and error in my copy of Excel suggests that 24 pixels = 2.71 characters.

And in the end, it still may not work. I did a quick grid in Excel with columns 2.71 characters/24 pixels wide and 18 points/24 pixels high. That should have been a quarter-inch grid. I then printed it out and measured it, and it wasn't. An eight-by-eight block, which should have been two inches on a side, was actually 2-1/8" wide and 1-7/8" high. So something seems to go ever so slightly askew between the screen and the printer. There may be some other subtle formatting issue I don't know about, or maybe I just need a better printer.

So if you want an exact grid, you may be out of luck with Excel. But if you can handle losing or gaining one-sixteenth per inch, you will be OK. - Eron^Talk 21:37, 23 December 2014 (UTC)

No, there's no problem with your printer; it's a known issue and a pain in the ass. Honestly, the best way to make this work is to make up a series of slightly different "squares" using different row/column coordinates until you get something useful to you. Note, if you use page control to force Excel to squeeze an oversize amount of spreadsheet down to a single page, it will likely become hopeless. Matt Deres (talk) 04:19, 24 December 2014 (UTC)

The perfect mp3 file with lyrics

I am trying to create the perfect music discography collection of my favorite band. I Bought all of their music from their website and I am editing the meta data on windows 7 in foobar. All the files are mp3, how can I add and more options in the mp3's metadata? I think you can add a slot for lyrics and i wanted to add all of the lyrics to every mp3 file. How would I go about doing this? I am not to good with mp3 stuff. — Preceding unsigned comment added by Lostboy.exe (talk • contribs) 23:59, 23 December 2014 (UTC)

Try searching for "edit mp3 metadata"; you'll find plenty of suggestions. --jpgordon^{::==( o )} 17:11, 25 December 2014 (UTC)

After trying a number of apps, I now use Mp3tag. --  Gadget850 ^talk 18:17, 26 December 2014 (UTC)