31 May 2013
15 May 2013
Base64 image and how to save it
Almost 2 years since I put anything here. This post is as a reference if I need to convert base64 image data to an image.
I have seen the base64 encoded URI earlier and knew what it is essentially. For example:
The browser does the job of displaying it seamlessly most of the time. However, today I got it as text in a email. The email client wrapped each line by = and newline character. So I got curious how to "view" the image.
I took the following steps (possibly unnecessary as base64 command can strip garbage from input*):
*: see base64 man page
I have seen the base64 encoded URI earlier and knew what it is essentially. For example:
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAkIAAADICAYAAAAEE46XAAALwElEQVR4Xu3ZUW7dVgwE0GRD3f86uqEWBVLARlUIxBXEeZmTb8uPPEMbE/nnD/8IECBAgAABAqUCP0v3tjYBAgQIECBA4Ici5AgIECBAgACBWgFFqDZ6ixMgQIAAAQKKkBsgQIAAAQIEagUUodroLU6AAAECBAgoQm6AAAECBAgQqBVQhGqjtzgBAgQIECCgCLkBAgQIECBAoFZAEaqN3uIECBAgQICAIuQGCBAgQIAAgVoBRag2eosTIECAAAECipAbIECAAAECBGoFFKHa6C1OgAABAgQIKEJugAABAgQIEKgVUIRqo7c4AQIECBAgoAi5AQIECBAgQKBWQBGqjd7iBAgQIECAgCLkBggQIECAAIFaAUWoNnqLEyBAgAABAoqQGyBAgAABAgRqBRSh2ugtToAAAQIECChCboAAAQIECBCoFVCEaqO3OAECBAgQIKAIuQECBAgQIECgVkARqo3e4gQIECBAgIAi5AYIECBAgACBWgFFqDZ6ixMgQIAAAQKKkBsgQIAAAQIEagUUodroLU6AAAECBAgoQm6AAAECBAgQqBVQhGqjtzgBAgQIECCgCLkBAgQIECBAoFZAEaqN3uIECBAgQICAIuQGCBAgQIAAgVoBRag2eosTIECAAAECipAbIECAAAECBGoFFKHa6C1OgAABAgQIKEJugAABAgQIEKgVUIRqo7c4AQIECBAgoAi5AQIECBAgQKBWQBGqjd7iBAgQIECAgCLkBggQIECAAIFaAUWoNnqLEyBAgAABAoqQGyBAgAABAgRqBRSh2ugtToAAAQIECChCboAAAQIECBCoFVCEaqO3OAECBAgQIKAIuQECBAgQIECgVkARqo3e4gQIECBAgIAi5AYIECBAgACBWgFFqDZ6ixMgQIAAAQKKkBsgQIAAAQIEagUUodroLU6AAAECBAgoQm6AAAECBAgQqBVQhGqjtzgBAgQIECCgCLkBAgQIECBAoFZAEaqN3uIECBAgQICAIuQGCBAgQIAAgVoBRag2eosTIECAAAECipAbIECAAAECBGoFFKHa6C1OgAABAgQIKEJugAABAgQIEKgVUIRqo7c4AQIECBAgoAi5AQIECBAgQKBWQBGqjd7iBAgQIECAgCLkBggQIECAAIFaAUWoNnqLEyBAgAABAoqQGyBAgAABAgRqBRSh2ugtToAAAQIECChCboAAAQIECBCoFVCEaqO3OAECBAgQIKAIuQECBAgQIECgVkARqo3e4h8s8NcHz94wut+rDSnb8bcR8AP720RpkSIBRSg7bL9Xs/MxHYFvAn5gHQSBzxNQhLIz83s1Ox/TEVCE3ACBDxdQhLIDVISy8zEdAUXIDRD4cIHvRehPvWg1zz/+03sUodVAfDiBmYAf2JmXryaQIKAIJaTw7wyKUFIaZiEwFlCExmQeILAuoAitR/BlAEUoKQ2zEBgLKEJjMg8QWBdQhNYjUISSIjALgRMBRehEz7MEdgQUoR3360/1RigpDbMQGAsoQmMyDxBYF1CE1iPwRigpArMQOBFQhE70PEtgR0AR2nH3RijJ3SwEHhJQhB6C9G0IvCigCL2IfftR/jR2S+QLCCQLKELJ6ZiNwLWAIpR0GYpQUhpmITAWUITGZB4gsC6gCK1H8GUARSgpDbMQGAsoQmMyDxBYF1CE1iNQhJIiMAuBEwFF6ETPswR2BBShHffrT/VGKCkNsxAYCyhCYzIPEFgXUITWI/BGKCkCsxA4EVCETvQ8S2BHQBHacfdGKMndLAQeElCEHoL0bQi8KKAIvYh9+1H+NHZL5AsIJAsoQsnpmI3AtYAilHQZilBSGmYhMBZQhMZkHiCwLqAIrUfwZQBFKCkNsxAYCyhCYzIPEFgXUITWI1CEkiIwC4ETAUXoRM+zBHYEFKEd9+tP9UYoKQ2zEBgLKEJjMg8QWBdQhNYj8EYoKQKzEDgRUIRO9DxLYEdAEdpx90Yoyd0sBB4SUIQegvRtCLwooAi9iH37Uf40dkvkCwgkCyhCyemYjcC1gCKUdBmKUFIaZiEwFlCExmQeILAuoAitR/BlAEUoKQ2zEBgLKEJjMg8QWBdQhNYjUISSIjALgRMBRehEz7MEdgQUoR3360/1RigpDbMQGAsoQmMyDxBYF1CE1iPwRigpArMQOBFQhE70PEtgR0AR2nH3RijJ3SwEHhJQhB6C9G0IvCigCL2IfftR/jR2S+QLCCQLKELJ6ZiNwLWAIpR0GYpQUhpmITAWUITGZB4gsC6gCK1H8GUARSgpDbMQGAsoQmMyDxBYF1CE1iNQhJIiMAuBEwFF6ETPswR2BBShHffrT/VGKCkNsxAYCyhCYzIPEFgXUITWI/BGKCkCsxA4EVCETvQ8S2BHQBHacfdGKMndLAQeElCEHoL0bQi8KKAIvYh9+1H+NHZL5AsIJAsoQsnpmI3AtYAilHQZilBSGmYhMBZQhMZkHiCwLqAIrUfwZQBFKCkNsxAYCyhCYzIPEFgXUITWI1CEkiIwC4ETAUXoRM+zBHYEFKEd9+tP9UYoKQ2zEBgLKEJjMg8QWBdQhNYj8EYoKQKzEDgRUIRO9DxLYEdAEdpx90Yoyd0sBB4SUIQegvRtCLwooAi9iH37Uf40dkvkCwgkCyhCyemYjcC1gCKUdBmKUFIaZiEwFlCExmQeILAuoAitR/BlAEUoKQ2zEBgLKEJjMg8QWBdQhNYjUISSIjALgRMBRehEz7MEdgS+F6GdGXzq/wv4veo6CHyQgB/YDwrLqAR+CShC2afg92p2PqYj8E3AD6yDIPB5AopQdmZ+r2bnYzoCipAbIPDhAopQdoCKUHY+piOgCLkBAgQIECBAgMA/Av7n4g4IECBAgACBWgFFqDZ6ixMgQIAAAQKKkBsgQIAAAQIEagUUodroLU6AAAECBAgoQm6AAAECBAgQqBVQhGqjtzgBAgQIECCgCLkBAgQIECBAoFZAEaqN3uIECBAgQICAIuQGCBAgQIAAgVoBRag2eosTIECAAAECipAbIECAAAECBGoFFKHa6C1OgAABAgQIKEJugAABAgQIEKgVUIRqo7c4AQIECBAgoAi5AQIECBAgQKBWQBGqjd7iBAgQIECAgCLkBggQIECAAIFaAUWoNnqLEyBAgAABAoqQGyBAgAABAgRqBRSh2ugtToAAAQIECChCboAAAQIECBCoFVCEaqO3OAECBAgQIKAIuQECBAgQIECgVkARqo3e4gQIECBAgIAi5AYIECBAgACBWgFFqDZ6ixMgQIAAAQKKkBsgQIAAAQIEagUUodroLU6AAAECBAgoQm6AAAECBAgQqBVQhGqjtzgBAgQIECCgCLkBAgQIECBAoFZAEaqN3uIECBAgQICAIuQGCBAgQIAAgVoBRag2eosTIECAAAECipAbIECAAAECBGoFFKHa6C1OgAABAgQIKEJugAABAgQIEKgVUIRqo7c4AQIECBAgoAi5AQIECBAgQKBWQBGqjd7iBAgQIECAgCLkBggQIECAAIFaAUWoNnqLEyBAgAABAoqQGyBAgAABAgRqBRSh2ugtToAAAQIECChCboAAAQIECBCoFVCEaqO3OAECBAgQIKAIuQECBAgQIECgVkARqo3e4gQIECBAgIAi5AYIECBAgACBWgFFqDZ6ixMgQIAAAQKKkBsgQIAAAQIEagUUodroLU6AAAECBAgoQm6AAAECBAgQqBVQhGqjtzgBAgQIECCgCLkBAgQIECBAoFZAEaqN3uIECBAgQICAIuQGCBAgQIAAgVoBRag2eosTIECAAAECipAbIECAAAECBGoFFKHa6C1OgAABAgQIKEJugAABAgQIEKgVUIRqo7c4AQIECBAgoAi5AQIECBAgQKBWQBGqjd7iBAgQIECAgCLkBggQIECAAIFaAUWoNnqLEyBAgAABAoqQGyBAgAABAgRqBRSh2ugtToAAAQIECChCboAAAQIECBCoFVCEaqO3OAECBAgQIKAIuQECBAgQIECgVkARqo3e4gQIECBAgMDfiLaSyZOoJNUAAAAASUVORK5CYII
The browser does the job of displaying it seamlessly most of the time. However, today I got it as text in a email. The email client wrapped each line by = and newline character. So I got curious how to "view" the image.
I took the following steps (possibly unnecessary as base64 command can strip garbage from input*):
- Saved the encoded data to a text file
- Used sed with the following commands to strip unneeded characters (I'm nowhere a sed expert :( )
~$&> sed 's/=$//' imagedata.txt > imagedata.txt
(remove trailing = on each line)~$&> sed ':a;N;$!ba;s/\n//g' imagedata.txt > imagedata2.txt
(remove newline character from each line)~$&> base64 -d -w 0 imagedata2.txt > imagedata.png
*: see base64 man page
5 June 2011
Logitech M515
Picked up a Logitech M515 mouse from Bureau en Gros/Staples ($40). The mouse is sealed at the bottom, except for the On/Off switch. It has one of those "unifying" receiver for the wireless function.
Here the main points:
- Scroll-wheel does not do the middle-click: if you do the middle click, it toggles the scroll wheel to free scroll or clickity-click wheel. The middle-click is done by the [o] button near the wheel.
- The specs didn't indicate if it is SFF or full sized mouse. It is a SFF or laptop mouse.
- Unifying feature cannot be setup in Linux. As indicated in the document on Logitech Unifying Receiver, Unifying software does not support Linux. You have to setup the unifying feature separately e.g. setup on Windows and then reconnect the receiver and to Linux machine. I did it on a virtual instance but lost the cursor during the setup. Restarted VM and both worked fine.
- M515 is designed for couch (read cloth), so it might not function on glossy surfaces. Mouse pad, sofa, table top and paper worked; blue-ray player cover (black), glass, and fridge surface did not work.
- Logitech says that it is active when you hold the mouse. They don't lie and it is advised that you hold it properly as I noticed that it stopped functioning when holding lightly with two fingers. You can easily test by pushing it with one finger.
- I like the smooth scrolling wheel, but the M510's form factor suites my hand better.
- Works even if you are 3-4 meters away just like the M510.
- Lacks the extra buttons on the M510.
One important question which comes to mind is the cover at the bottom. It consists of two parts: regular grey plastic cover on the outer side (see image) and the shiny dark translucent plate covering the laser inside. Over time, the shiny central part is going to get scratchy (it is not hardened glass) which would affect the performance of the laser. Would the scratches be enough to cause scattering of the laser so that the mouse gets confused?
Still deciding if it stays or goes back.
29 April 2011
Bash Programming
Been reading some Bash introduction stuff and found that TLDP article contained errors right in the first couple of chapters (grammatical and programmatical both). Need to search further to find better quality stuff. This log will be updated with other links with time.
9 January 2011
6 January 2011
Sony BDP-S370 and NTFS
Warning: If you want to call Sony support, be very very patient. It took me 1h25m to get to a support representative!
Spoke to the Sony rep on Sony support about the in ability of BDP-S370 to NTFS formatted USB disks and he said it will only read FAT32 (as I read in the manual). When I asked him if a software update would add this feature in future, he said that it won't happen as it is limited by hardware.
So for now, it is the Samsung BD-C5500T which stays and Sony goes back as an open box item! Sorry Sony but you need to be more competitive in today's market. Alors tu ne me intéresses plus.
Spoke to the Sony rep on Sony support about the in ability of BDP-S370 to NTFS formatted USB disks and he said it will only read FAT32 (as I read in the manual). When I asked him if a software update would add this feature in future, he said that it won't happen as it is limited by hardware.
So for now, it is the Samsung BD-C5500T which stays and Sony goes back as an open box item! Sorry Sony but you need to be more competitive in today's market. Alors tu ne me intéresses plus.
3 January 2011
Seiki BD660
This is an unknown brand of blu-ray player that I picked up at Walmart for the sake of testing.
+ plays almost all kinds of files DIVX, XviD, MKV, MPEG2, MP3, etc from USB stick
+ DVD or Blu-ray region change
+ Reads NTFS formatted disks unlike Sony
- ethernet port is present, but no app uses it!
- no DLNA support
- does not control the TV (TV does not turn on when Seiki unit does)
- @ $78 it is way too expensive
- front panel buttons are hard to distinguish
- no front USB port
Find more info about it here.
For now, it goes back to Walmart this weekend. Had it been $40 or so, I would have kept it as a secondary unit.
+ plays almost all kinds of files DIVX, XviD, MKV, MPEG2, MP3, etc from USB stick
+ DVD or Blu-ray region change
+ Reads NTFS formatted disks unlike Sony
- ethernet port is present, but no app uses it!
- no DLNA support
- does not control the TV (TV does not turn on when Seiki unit does)
- @ $78 it is way too expensive
- front panel buttons are hard to distinguish
- no front USB port
Find more info about it here.
For now, it goes back to Walmart this weekend. Had it been $40 or so, I would have kept it as a secondary unit.
2 January 2011
Good Bye Sony BDP-S370
I bought two blu-ray players over the boxing week sales to be able to play various types of media files on the LCD TV. One was the Sony BDP-S370 and the second one was Samsung BD-C5500T. I have tested them for basic functionality. Here are my findings in brief:
Both players have cheap build quality, but at about $100 each and the features they offer; I can live with that. The last DVD player I bought was $90 without any USB port or network features!
Samsung has a touch sensitive plate on the front and it is quite sensitive. I have turned off the player by mistake while attaching the USB drive which is right under the power button! Sony on the other hand went with really tiny, hard to find buttons on the front panel. Both models disappoint for their front panels. Both of them turn the TV ON automatically though - one button to press :)
Both have wireless ready functionality (which I don't care for) as well as a real network port. Connected network cable to each of them and after basic configuration both of them upgrade to the latest firmware. Upgrade of firmware over network was a breeze.
Interface: I prefer the Sony interface as it is similar to the PS3. Samsung has too many things on the same screen and too many colours. Sony interface design simply trumps Samsung.
As far as media playing is concerened: Sony just sucks as it won't understand anything except FAT-32 formatted media. Sony does note that in the fine-print, but hey we are in 2010 and if Samsung does not have any problem in reading content from NTFS formatted USB driveand XFS formatted disc on the DLNA server (and update of the Linkstation Live firmware to 1.07 made that problem go away; Sony reads the files from the DLNA server now), why isn't Sony able to implement that! Samsung is also able to play MKV 5.1/6.0 profile video files unlike the Sony. Maybe Sony can outsource the software development of their blu-ray players (and maybe TVs too) to Samsung!
There was one thing keeping me from returning the Sony but after finding out the media playing ability of the Samsung, there is no confusion.
Update: removed DLNA issue with Sony
Both players have cheap build quality, but at about $100 each and the features they offer; I can live with that. The last DVD player I bought was $90 without any USB port or network features!
Samsung has a touch sensitive plate on the front and it is quite sensitive. I have turned off the player by mistake while attaching the USB drive which is right under the power button! Sony on the other hand went with really tiny, hard to find buttons on the front panel. Both models disappoint for their front panels. Both of them turn the TV ON automatically though - one button to press :)
Both have wireless ready functionality (which I don't care for) as well as a real network port. Connected network cable to each of them and after basic configuration both of them upgrade to the latest firmware. Upgrade of firmware over network was a breeze.
Interface: I prefer the Sony interface as it is similar to the PS3. Samsung has too many things on the same screen and too many colours. Sony interface design simply trumps Samsung.
As far as media playing is concerened: Sony just sucks as it won't understand anything except FAT-32 formatted media. Sony does note that in the fine-print, but hey we are in 2010 and if Samsung does not have any problem in reading content from NTFS formatted USB drive
There was one thing keeping me from returning the Sony but after finding out the media playing ability of the Samsung, there is no confusion.
Update: removed DLNA issue with Sony
4 July 2010
Wikipedia Down? -- UP NOW
Wikipedia.org seems to be down. No ping response and traceroute cannot proceed after 10 hops.
Lots of reports on Twitter from different places about this.
Update: After a few hours of downtime, it is back up @ 23:30hrs EDT.
17 May 2010
2 May 2010
Debian/KDE 4.4.3 Upgrade
I did an aptitude safe-upgrade today and was pleasantly surprised to see that KDE 4.4.3 was finally in unstable. The only problem I had with the upgrade was that I got a black screen when I tried to re-login to KDE.
I didn't find much on Google or Debian lists but this post on KDE gave me an indication and I checked the status of the package plasma-desktop. dpkg told it was uninstalled at some point. I installed it using aptitude and lo-and-behold, I was able to login the new version of KDE.
I didn't find much on Google or Debian lists but this post on KDE gave me an indication and I checked the status of the package plasma-desktop. dpkg told it was uninstalled at some point. I installed it using aptitude and lo-and-behold, I was able to login the new version of KDE.
17 April 2010
Apple - The Gatekeeper: Bends ....once again
Bad publicity forces Apple to ask Mark Fiore (Pulitzer prize winning cartoonist) to re-submit his iPhone app which was rejected four months ago. They seem to stick to their ground using whatever whimsical reasons they want unless it gets them in soup!
While the iPhone app is being submitted and gets approved, you can enjoy Fiore's cartoons on his website.
While the iPhone app is being submitted and gets approved, you can enjoy Fiore's cartoons on his website.
8 April 2010
Lucid > Firefox > Search Provider Confusion
After all the hoopla about changing search provider, Ubuntu has changed its mind and went back with Google for the Lucid release. I don't understand why this is such a big issue. Ubuntu is open source and so is Firefox. Search feature of Firefox is well known and so is the knowledge of how to change search provider or the default one. I guess Ubuntu users are getting accustomed to being spoon fed by a beautiful looking, always working, hassle free Linux distribution.
PS: This is another example of the philosophy that Apple is leading the way to make computer users dumb rather than techsavvy. I hope Ubuntu doesn't join the bandwagon.
PS: This is another example of the philosophy that Apple is leading the way to make computer users dumb rather than techsavvy. I hope Ubuntu doesn't join the bandwagon.
7 April 2010
Lucid Lynx -- Ubuntu 10.04
30.04.10 - Lucid Lynx, coming soon to a server near you. If you can't wait, you can get the beta.
Just upgraded my Karmic box to Lucid and the process was very smooth. I wish Microsoft was able to give upgrades like this ;)
Pros:
Just upgraded my Karmic box to Lucid and the process was very smooth. I wish Microsoft was able to give upgrades like this ;)
Pros:
- Fast bootup.
- Less sluggish, faster response.
- ......
- New theme has nice gradation and feels nice, but the color combination is a bit of an eye-sore. Solution: Change it from System > Preferences > Appearence
- Window close, minimize, maximize buttons are on the left! Last time I checked, Ubuntu wasn't Apple's official distribution, so why is it trying to act like one? Solution: System > Preferences > Theme > Customize.
- I had the idea that Gnome was simple, however take a look at the context menu for a USB flash disk; there are 16 options displayed and many of them are grayed out as they probably don't even apply. Unavailable options should be invisible and Format and Compress can be easily put in Properties window.

- If that wasn't enough to cause confusion, the user gets two choices for the USB stick removal: Eject and Safely Remove Drive. Isn't Eject safe enough? Why not just have one option of Safely Remove Drive?
- Default search engine changed to Yahoo! even though my earlier default was Google. Easy fix is to open about:config and change browser.search.defaultenginename property to Google
21 February 2010
Ice Hockey: Canada v/s US
Watching the first encounter of Canada against USA in Ice Hockey. The rivalry between the teams on the ice seems exactly like the India/Pakistan cricket 1 day match.
Score 1st Pr (end): US 2 -- Canada 1
2nd Pr: US3 -- Canada 2 (3min remaining)
Final: US won 5-3
Score 1st Pr (end): US 2 -- Canada 1
2nd Pr: US3 -- Canada 2 (3min remaining)
Final: US won 5-3
25 January 2010
Linux Wireless Access Point - v2
After struggling with various networking issues with my older wireless card (the discontinued D-Link DWL-G520), I purchased a DWA-552 for $60+tx. I used the DWL-G520 for almost 2 years as my access point. But it never worked in WPA2 mode and always had problems with two (Windows) machines, iPod Touch and my Nokia trying to connect to it. I had to restart hostapd after either the iPod or the Nokia tried to connect as it would stop working.
I had setup madwifi with hostapd for the DWL-G520 earlier. But as madwifi was removed from Debian repos, DWA-552 was the only PCI wireless adapter supported by the linux kernel's ath9k module. That required me to update to the the newest kernel 2.6.30. ath9k works out of the box with this kernel in master mode.
Setup was easy as most of the work was already there. I had to setup my hostapd.conf to use WPA2 and changed the network interface from ath0 to wlan0. Restarting networking and hostapd gave me the wlan0 interface and both the iPod and the Nokia were able to detect the SSID.
Last but not the least, all this was accomplished with help from Robert's post. Thanks for documenting your experience with ath9k.
The next thing to do is to see if it will work in the N-mode. That is for another day, as I'm late to go to bed (...again) by an hour.
I had setup madwifi with hostapd for the DWL-G520 earlier. But as madwifi was removed from Debian repos, DWA-552 was the only PCI wireless adapter supported by the linux kernel's ath9k module. That required me to update to the the newest kernel 2.6.30. ath9k works out of the box with this kernel in master mode.
Setup was easy as most of the work was already there. I had to setup my hostapd.conf to use WPA2 and changed the network interface from ath0 to wlan0. Restarting networking and hostapd gave me the wlan0 interface and both the iPod and the Nokia were able to detect the SSID.
Last but not the least, all this was accomplished with help from Robert's post. Thanks for documenting your experience with ath9k.
The next thing to do is to see if it will work in the N-mode. That is for another day, as I'm late to go to bed (...again) by an hour.
22 August 2009
iPod Engraving in UTF-8?
When outside, I'm always afraid of my big iPod Classic (80GB) of falling on the pavement and breaking. Even though it is quite nicely protected by a fantastic wide-corduroy case by the foof-lady, there is always a chance that it will sustain serious damage if it falls. So I was thinking of getting an iPod shuffle and the iPod Classic I have is way too big to go jogging around on the streets.
When I went to the famous online fruit store, it said that I could request an engraving to be put on the back of the iPod. I liked the idea and quickly tested something in my mother tongue. All I got was ???? on the back of the iPod instead of ਮੇਰਾ ਸੰਗੀਤ. Has anyone tried using non-English characters? e.g. Arabic? Chinese? Japanese? etc.
It seems to be quite a trivial thing to do when all software Apple has supports UTF-8 characterset and the engraving is also done by a machine rather than a human hand (would be wonderful if it was done manually though).
When I went to the famous online fruit store, it said that I could request an engraving to be put on the back of the iPod. I liked the idea and quickly tested something in my mother tongue. All I got was ???? on the back of the iPod instead of ਮੇਰਾ ਸੰਗੀਤ. Has anyone tried using non-English characters? e.g. Arabic? Chinese? Japanese? etc.
It seems to be quite a trivial thing to do when all software Apple has supports UTF-8 characterset and the engraving is also done by a machine rather than a human hand (would be wonderful if it was done manually though).
9 August 2009
MS Excel - Shared file bug
This is a note to self, plus for those who might encounter the issue. It took me about an hour to find the solution to this problem.
Problem: A large Excel spreadsheet (about 3MB) which has the "Share Workbook" enabled is used by different authors and over time the file size increases enormously. In this case, the file had grown to about 90MB with only small additions of data over a period of a couple of months.
Possibility: User might have added several empty or almost empty cells to the sheet so that the whole sheet/workbook is filled up.
Interesting observation: Deleting 233 columns (and 64k rows) increased the size of the file by 2MB!
Solution: This happens when the workbook is keep a track of what is being done with it and by whom. If you don't want that information (I wonder how it is viewed), you can remove the extra tracking information by removing the Share feature by going to Tools > Share Workbook and then uncheck the option to make it shared and save it. You can check the size of the workbook after saving and it will be reduced to size needed by the data and formatting.
You can re-enable the share feature after saving if needed.
10 May 2009
F1 Barcelona and BBC Bug

A fantastic F1 Spanish Grand Prix is going on and the Brawns up for a 1,2 again. F1 in 2009 has change a lot with Ferrari and McLaren both struggling to get into points finish let alone podiums. This is going to be a very interesting season.
Keeping a watch on the F1 Live Spanish Grand Prix page on BBC Sport. They keep an AJAX powered leader board on the right side and it updates very nice except sometimes when it puts a retired car (MaLaren-Kovalainen) for a podium finish!
Subscribe to:
Posts (Atom)

