| Computing desk | ||
|---|---|---|
| < June 3 | << May | June | Jul >> | June 5 > |
| 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. |
June 4 Information
Is there anyway to change the size on an application written in java? I mean for me as an user. Can a client change the size of an applet size? 190.60.93.218 ( talk) 14:16, 4 June 2012 (UTC)
- I'm sorry, that's really not a comprehensible question. Can you be much more specific about what it is you actually want to achieve. What working thing are you trying to improve, or what broken thing are you trying to fix? 91.125.113.50 ( talk) 15:46, 4 June 2012 (UTC)
- Are you trying to change the on-screen size (to do that you'd change the html that hosts it)? Or do you mean the memory size? Download size? What applet specifically? And on what browser (on some we can tell you some javascript which will let you change the size of things, but we'd need to see the specific page). 91.125.113.50 ( talk) 15:49, 4 June 2012 (UTC)
- Oops, sorry. I think I wasn't really clear. Let's say that the applet is fixed on a 500x500px square. How as a client without modifying the java applet can I change it from 500x500px in my display to 200x200px. Changing the html won't work because the object won't resize, it will just crop it.
- So the question is. How to resize an applet or object? (For flash would be helpful) too. 190.60.93.218 ( talk) 17:40, 4 June 2012 (UTC)
- When a browser starts an applet (creating something typically called an AppletContainer) it sets the size of that according to the HTML applet or embed tag information. Some applets read the size of this and will adapt their layout to whatever size their given. But it sounds like the applet you're talking about just assumes it's given the size it expects, and so its display is cropped, as you've observed. There's isn't a practical fix for that; applets aren't readily zoomable and you'd need to alter the applet's source code to change how the it works. I don't know anything about Flash. -- Finlay McWalterჷ Talk 17:59, 4 June 2012 (UTC)
- Is there any application that allows resizing of windows? apart from a virtual machine? — Preceding unsigned comment added by 190.158.212.204 ( talk) 20:58, 4 June 2012 (UTC)
After installing a Chrome extension (a search toolbar) I found it worked okay. I closed Chrome for a short while and when I tried to open Chrome, it wouldn't open no matter what I tried (shortcuts, going through Explorer (this is a whole story in itself), through Run etc). I searched Add/Remove programs for a way to remove the toolbar (as I installed it as an exe, it wasn't installed through Chrome) to no avail. At this point I tried to uninstall Chrome, but it wouldn't let me do that either (nothing happens). I did a manual uninstall from the registry as per the steps on the Chrome help site. I restarted my PC but Windows Update updated something or other in the process, and when my computer had rebooted completely I loaded my Windows profile and it had, stylistically, resetted to default settings. All my programs and data were still present, but the wallpaper, internet homepage etc. had reset back to the default Asus ones. In addition, whenever I browse through Windows Explorer it crashes and reboots, particularly if I try to backspace back in the navigation.
At this point I'm thinking I've installed some form of malware or virus, so I'm over halfway through a Malware check through Malwarebytes and nothing has been found so far. A virus scan will follow, but something tells me it won't return anything positive.
Does anyone have any ideas? I'm a little stuck here. I'm running a relatively new Win7 laptop.
Regards, --— Cyclonenim | Chat 16:59, 4 June 2012 (UTC)
- I can now add to the list of things that didn't work: System restore. I'm stuck on this! Regards, --— Cyclonenim | Chat 17:34, 4 June 2012 (UTC)
- In addition, using a command-line switch to open chrome without extensions didn't work. Regards, --—
Cyclonenim |
Chat 17:34, 4 June 2012 (UTC)
- What's the name of the extension you installed?
190.26.65.245 (
talk) 17:42, 4 June 2012 (UTC)
- ChatRT Regards, --— Cyclonenim | Chat 17:55, 4 June 2012 (UTC)
- What's the name of the extension you installed?
190.26.65.245 (
talk) 17:42, 4 June 2012 (UTC)
Real-time Windows help here: http://webchat.freenode.net/?nick=WinWoes&channels=##windows ¦ Reisio ( talk) 19:35, 4 June 2012 (UTC)
This is a very simple question. I have a spreadsheet in MS Excel. I want to colour certain cells depending on the value in that cell. It's a spreadsheet of exam results. Let's say I want all of the cells with a mark x such that x ≥ 80% in them to be green, all those with 70% ≤ x < 80% to be yellow, all those with 60% ≤ x < 70% to be orange and all those with x < 60% to be red. What would I have to type in to Excel to make this happen? I've already got all of the names and marks in a two-way-table with the percentages calculated at the end of the row. I just need to get Excel to colour the cells using a given criterion. — Fly by Night ( talk) 21:50, 4 June 2012 (UTC)
- Hi, what you want is conditional formatting. Rather than describe it in great detail, I'll point you in the direction of an explanatory picture that someone else has put online, and google image search has found. Few things to note:
- You access this dialogue via Format->Conditional Formatting, at least you do in Excel 2003 - other versions may differ
- You're limited to three formatting rules, but you can set another as your default by setting the background colour of the cell in the ordinary way - so you'd have the four you need
- You can enter 0.5 for 50% (for example)
- Cheers,
davidprior
t/
c 23:41, 4 June 2012 (UTC)
- Excel 2007/2010 has a more sophisticated version of this called "Color Scales", under the Conditional Formatting button on the Home tab of the Ribbon. There are various built-in options, or you can tweak it to your particular needs. AndrewWTaylor ( talk) 09:00, 6 June 2012 (UTC)
| Computing desk | ||
|---|---|---|
| < June 3 | << May | June | Jul >> | June 5 > |
| 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. |
June 4 Information
Is there anyway to change the size on an application written in java? I mean for me as an user. Can a client change the size of an applet size? 190.60.93.218 ( talk) 14:16, 4 June 2012 (UTC)
- I'm sorry, that's really not a comprehensible question. Can you be much more specific about what it is you actually want to achieve. What working thing are you trying to improve, or what broken thing are you trying to fix? 91.125.113.50 ( talk) 15:46, 4 June 2012 (UTC)
- Are you trying to change the on-screen size (to do that you'd change the html that hosts it)? Or do you mean the memory size? Download size? What applet specifically? And on what browser (on some we can tell you some javascript which will let you change the size of things, but we'd need to see the specific page). 91.125.113.50 ( talk) 15:49, 4 June 2012 (UTC)
- Oops, sorry. I think I wasn't really clear. Let's say that the applet is fixed on a 500x500px square. How as a client without modifying the java applet can I change it from 500x500px in my display to 200x200px. Changing the html won't work because the object won't resize, it will just crop it.
- So the question is. How to resize an applet or object? (For flash would be helpful) too. 190.60.93.218 ( talk) 17:40, 4 June 2012 (UTC)
- When a browser starts an applet (creating something typically called an AppletContainer) it sets the size of that according to the HTML applet or embed tag information. Some applets read the size of this and will adapt their layout to whatever size their given. But it sounds like the applet you're talking about just assumes it's given the size it expects, and so its display is cropped, as you've observed. There's isn't a practical fix for that; applets aren't readily zoomable and you'd need to alter the applet's source code to change how the it works. I don't know anything about Flash. -- Finlay McWalterჷ Talk 17:59, 4 June 2012 (UTC)
- Is there any application that allows resizing of windows? apart from a virtual machine? — Preceding unsigned comment added by 190.158.212.204 ( talk) 20:58, 4 June 2012 (UTC)
After installing a Chrome extension (a search toolbar) I found it worked okay. I closed Chrome for a short while and when I tried to open Chrome, it wouldn't open no matter what I tried (shortcuts, going through Explorer (this is a whole story in itself), through Run etc). I searched Add/Remove programs for a way to remove the toolbar (as I installed it as an exe, it wasn't installed through Chrome) to no avail. At this point I tried to uninstall Chrome, but it wouldn't let me do that either (nothing happens). I did a manual uninstall from the registry as per the steps on the Chrome help site. I restarted my PC but Windows Update updated something or other in the process, and when my computer had rebooted completely I loaded my Windows profile and it had, stylistically, resetted to default settings. All my programs and data were still present, but the wallpaper, internet homepage etc. had reset back to the default Asus ones. In addition, whenever I browse through Windows Explorer it crashes and reboots, particularly if I try to backspace back in the navigation.
At this point I'm thinking I've installed some form of malware or virus, so I'm over halfway through a Malware check through Malwarebytes and nothing has been found so far. A virus scan will follow, but something tells me it won't return anything positive.
Does anyone have any ideas? I'm a little stuck here. I'm running a relatively new Win7 laptop.
Regards, --— Cyclonenim | Chat 16:59, 4 June 2012 (UTC)
- I can now add to the list of things that didn't work: System restore. I'm stuck on this! Regards, --— Cyclonenim | Chat 17:34, 4 June 2012 (UTC)
- In addition, using a command-line switch to open chrome without extensions didn't work. Regards, --—
Cyclonenim |
Chat 17:34, 4 June 2012 (UTC)
- What's the name of the extension you installed?
190.26.65.245 (
talk) 17:42, 4 June 2012 (UTC)
- ChatRT Regards, --— Cyclonenim | Chat 17:55, 4 June 2012 (UTC)
- What's the name of the extension you installed?
190.26.65.245 (
talk) 17:42, 4 June 2012 (UTC)
Real-time Windows help here: http://webchat.freenode.net/?nick=WinWoes&channels=##windows ¦ Reisio ( talk) 19:35, 4 June 2012 (UTC)
This is a very simple question. I have a spreadsheet in MS Excel. I want to colour certain cells depending on the value in that cell. It's a spreadsheet of exam results. Let's say I want all of the cells with a mark x such that x ≥ 80% in them to be green, all those with 70% ≤ x < 80% to be yellow, all those with 60% ≤ x < 70% to be orange and all those with x < 60% to be red. What would I have to type in to Excel to make this happen? I've already got all of the names and marks in a two-way-table with the percentages calculated at the end of the row. I just need to get Excel to colour the cells using a given criterion. — Fly by Night ( talk) 21:50, 4 June 2012 (UTC)
- Hi, what you want is conditional formatting. Rather than describe it in great detail, I'll point you in the direction of an explanatory picture that someone else has put online, and google image search has found. Few things to note:
- You access this dialogue via Format->Conditional Formatting, at least you do in Excel 2003 - other versions may differ
- You're limited to three formatting rules, but you can set another as your default by setting the background colour of the cell in the ordinary way - so you'd have the four you need
- You can enter 0.5 for 50% (for example)
- Cheers,
davidprior
t/
c 23:41, 4 June 2012 (UTC)
- Excel 2007/2010 has a more sophisticated version of this called "Color Scales", under the Conditional Formatting button on the Home tab of the Ribbon. There are various built-in options, or you can tweak it to your particular needs. AndrewWTaylor ( talk) 09:00, 6 June 2012 (UTC)