Wikipedia:Reference desk/Archives/Computing/2018 July 23

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

July 23

can someone help with the security code in the link?

What do I type in this security code in this link: http://www.xyfos.com/contact_us.php?action=send 50.68.252.153 (talk) 02:21, 23 July 2018 (UTC)

Nothing. The site is defunct. Skip it and use an updated website. 50.233.27.176 (talk) 12:47, 23 July 2018 (UTC)

Excel: add separate conditional formatting simultaneously

Not sure what to call the concept I'm seeking; all my Google searches have found unrelated stuff, e.g. [1].

Let's say I have a few columns of numbers, and I want to add data bars to each column separately. I can highlight everything at once and apply Conditional Formatting/Data Bars and pick the one I want, but that wouldn't help because the contents of B4 might be compared with the contents of C4856, and I'm only interested in comparing B:B and C:C. Short of running a macro, is there any way to apply the same Conditional Formatting to multiple columns at once? I tried Format Painter, but that applies it to the whole area onto which I paint: I still have to apply it separately to each column. In case you wonder — in real life, I have a large file with several thousand rows, and I'm trying to apply the Duplicate Values to each row separately. I'm basically trying to remove duplicates from each row (F4643 and AQ4643 might have the same contents by accident, and I can't easily notice that due to the size of the sheet), so Conditional Formatting is great if I can apply it ideally. However, highlighting a big area all at once or using Format Painter, without clicking thousands of rows separately, will give me the useless facts that D4644 is identical to I9, and F4643 is identical to F4645: it's good that items in separate rows have identical content, and only duplicates in the same row are problems. Nyttend backup (talk) 13:45, 23 July 2018 (UTC)

Highlight the first row and apply the conditional formatting you wish. Then, highlight the row and copy-paste special onto the second row, selecting "paste formats". Then highlight both those rows and copy-paste special onto the following two rows the same way. If you keep doubling up like this a few times you'll quickly end up with a large chunk you can just keep pasting-special. You'll end up with individually conditional-formatted rows. Matt Deres (talk) 14:23, 23 July 2018 (UTC)

Nice, thank you! Nyttend backup (talk) 17:48, 23 July 2018 (UTC)

Vitu V3 android

I'm unsuccessful in finding the full specification for the entitled android. So far I only found one result. This android is available at hand for purchase and its a used piece. If I could know the screen resolution, ppi, and whether it provides OTG cable facility, it would be of help in decision making process. Thanks in advance. 119.30.39.44 (talk) 16:27, 23 July 2018 (UTC)

See the full specification. Ruslik_Zero 20:23, 23 July 2018 (UTC)

Ruslik: You displayed a different android. Review the 'result' I found, linked above. 119.30.35.199 (talk) 15:33, 26 July 2018 (UTC)

No, they are exactly the same. Ruslik_Zero 08:02, 28 July 2018 (UTC)

Ruslik: Hello, sorry to disturb you again. Thank you for your advice on one of my other query. Before I leave, I just wish to show you the following to images [2] and [3]. 123.108.246.67 (talk) 19:21, 30 July 2018 (UTC)

Android phone

I'm searching for androids based on the following specs:

Dual SIM (dual stand by).

6 inch.

1080*1920 (367 ppi) or higher.

IPS LCD or higher.

3GB RAM.

16GB ROM.

OTG Cable facility.

Could you help me please?

119.30.39.44 (talk) 16:19, 23 July 2018 (UTC)

Do you mean that you're trying to see if they exist, or you're trying to find one for sale, or something else? Nyttend backup (talk) 17:47, 23 July 2018 (UTC)

Interactive smartphone comparison chart. Comparison of Android versions. DroneB (talk) 19:00, 24 July 2018 (UTC)

While I don't think you're going get useful answers here, for the OTG point wherever you ask you need to be clear whether you mean a phone which supports OTG with an appropriate adapter, or whether you want a phone with a built in USB type A port. The former is quite common (although often only something you can actually find out when someone tries it), the later is very rare to non existent. Even 10" tablet are often not bothering with that anymore, even more so with the growing using of type C. Note that very few phones which support OTG come with an adapter. Considering you can buy one on AliExpress etc for about USD0.30 or something shipped, I'm not sure why you'd want to make it a requirement. Nil Einne (talk) 18:08, 25 July 2018 (UTC)

DroneB, Nil Einne: — Preceding unsigned comment added by 119.30.35.199 (talk) 15:37, 26 July 2018 (UTC)

1) What do you suggest I look for when buying an android? camera is for definite.

2) How much memory (internal and external) is required to possess an android for life, until of course you personally destroy it completely with or without using it?

3) A rough idea of a specification I should look for to possess an android for life - as stated above, until of course you personally destroy it completely with or without using it? I've given my analysis above.

119.30.35.199 (talk) 15:35, 26 July 2018 (UTC)

As it says on the top of the page: We don't answer requests for opinions, predictions or debate. Your question is squarely into the realm of opinion; the above answers were already fairly generous in trying to extract a factual question from the OP. Tigraan^{Click here to contact me} 14:23, 27 July 2018 (UTC)

Also, of course there ain't no such thing as a technology device for life. Anything you buy will be hopelessly obsolete in just a few years time. You knew that already. Jahoe (talk) 14:37, 27 July 2018 (UTC)

And definitely 16Gb ROM is too small. You should try something with at least 64 Gb. Ruslik_Zero 08:05, 28 July 2018 (UTC)

DroneB, Nil Einne, Jahoe, Ruslik: As one of you know about the storage issue, the other (main) problem is the battery. I can't keep a lot of apps on all the time... If you could also give me a current analysis of which phone is currently doing good in the market for best battery power consumption comparing with open apps and usage, I would be grateful. 123.108.246.67 (talk) 19:32, 30 July 2018 (UTC)

The article Smartphone describes these hyper-marketed short lived gadgets that try to emulate multiple devices (computer, camera, telephone, and more) and are generally impossible to repair. You may find they are like a Mermaid: if you want a fish you get a woman and if you want a woman you get a fish. Wikipedia cannot know how you will use a smartphone (like this?) and will not give you a buying recommendation. DroneB (talk) 00:57, 31 July 2018 (UTC)

Wow, that reply was savage mate. :P But yeah, OP would probably be better off asking XDA or Reddit about which smartphone to buy. Personally, I prefer modding smart devices over just poring into Facebook or Instagram. At least it gives me an excuse to take things in a different perspective than be the typical phone zombie. Blake Gripling (talk) 01:09, 31 July 2018 (UTC)