View Full Version : How to View Infinity in Excel Using a Linked Picture


draqon
08-11-07, 05:43 PM
Try this in Excel

" 1. Add some numbers or drawing objects to a Range of Cells.
2. Select the Range of Cells
3. Copy the Range using Ctrl+c or Edit -> Copy
4. Select a cell away from the copied range.
5. Hold down the Shift key as you select Edit -> Paste Picture Link.
6. Right-click the picture and select Order -> Send to Back.
7. Reduce the size of the picture slightly (hold down Ctrl as you do so)
8. Move the picture over the top of the Range. " (*) (http://www.vertex42.com/ExcelArticles/linked-pictures.html)

Oli
08-12-07, 06:19 AM
You left out the warning that it overloads your PC, not nice Draqon. :)

stephen1992
08-12-07, 06:36 AM
will it break ma pc if i do

Captain Kremmen
08-12-07, 06:47 AM
You left out the warning that it overloads your PC, not nice Draqon. :)

It will just lock up though, won't it?
A matter of turning it off and on again.

Though it might be more fun if the computer went up in flames saying .... overload....can....not...compute.

If you do the same thing with camcorders by capturing the monitor screen it can be permanently damaged. The screen goes like the start of a Dr Who episode, and if you continue with it, the CCD will no longer work properly.

Stryder
08-12-07, 08:33 AM
It will just lock up though, won't it?
A matter of turning it off and on again.

Though it might be more fun if the computer went up in flames saying .... overload....can....not...compute.

If you do the same thing with camcorders by capturing the monitor screen it can be permanently damaged. The screen goes like the start of a Dr Who episode, and if you continue with it, the CCD will no longer work properly.

I don't think it would overload your CCD, the internal workings probably has a mipmapping algorythm for things outside of a certain visual range (namely things beyond a certain distance). It's usually in regards to the pixel ratio for the stored footage, since it's a finite size it can't compute beyond a point.

I guess you can say it's dumbed down enough not to get over complexed by an infinite (technically finite by technology boundaries) vortex.

Captain Kremmen
08-12-07, 01:39 PM
I don't think it would overload your CCD, the internal workings probably has a mipmapping algorythm for things outside of a certain visual range (namely things beyond a certain distance). It's usually in regards to the pixel ratio for the stored footage, since it's a finite size it can't compute beyond a point.

I guess you can say it's dumbed down enough not to get over complexed by an infinite (technically finite by technology boundaries) vortex.

Maybe it's a physical problem rather than a computational one.
If you get feedback on a hifi, you can blow the speakers.
Come to think of it, your ears won't fare too well either.

With a camcorder, I've seen it happen. The camcorder required a repair afterwards. The image went very dull and lacked focus.

With a computer, I suppose it's possible that a computer's chips could get hot if continually used at 100%, and increase the probability of breakdown.
I think I'll give it a miss.

draqon
08-12-07, 02:53 PM
oh come on Chris.

Stryder
08-12-07, 03:13 PM
Maybe it's a physical problem rather than a computational one.
If you get feedback on a hifi, you can blow the speakers.
Come to think of it, your ears won't fare too well either.

With a camcorder, I've seen it happen. The camcorder required a repair afterwards. The image went very dull and lacked focus.

With a computer, I suppose it's possible that a computer's chips could get hot if continually used at 100%, and increase the probability of breakdown.
I think I'll give it a miss.

Feedback on a hifi is a little different. It's not like the boards in the hifi give out but the actual speakers (if left to gravitate).

Captain Kremmen
08-12-07, 06:01 PM
oh come on Chris.

I might just try it on someone else's computer.
Thats how I know about what happens with camcorders.:)

Idle Mind
08-13-07, 03:52 AM
Computers have built in power-down sequences if the CPU and other components get uncontrollably hot. This is to prevent permanent damage to the hardware, so you won't be able to destroy your computer with anything like this.

Spectrum
08-17-07, 06:02 AM
What does it do??

Digaph
08-17-07, 12:39 PM
hehe, very funny actually.
Like they say in the artical, "you can't really call a purposeful endless recursive loop a bug".
But that does say accactly what is happening here.
Excel will end up being thrown in an endless loop it can never get out of unless you act on it. Since most of today's computers are rather fast on processing you will probably be too late to force Excel to stop ending up with only one last course of action, a forced shutdown.

The reason your computer will no longer respond is this.
Any program you run on your computer claim a certain ammount of memory. As long as the program is correctly programmed it should never use more memory then it needs and will give up the claimed memory space when it's no longer needed.
In this case Excel is in need of more and more memory, and because of working with pictures, the memory usage will grow rapidly. When all of the computers memory has been used it will start to store some of it in a swap file, your harddisk. Thats the actual moment where your computer start to fall apart, or to be more precise, mostly everything becomes non reactive.
Since harddisks are much much much slower then fysical memory and the use of it requires much more cpu load it will start to give in on you.

Now don't worry if this happens to you, as no real damage is caused by this, but it's just a pain when it does happen.
In this case it's plain fun to reconstruct the above steps and come to the conclusion that my laptop ain't infinite either :)