Skip to main content

How to do an already doomed test

Read this blog MS Office 2007 versus Open Office 2.2 shootout. The test was already flawed from the beginning for the following reasons:


  • The author did not upload the original file which is probably a Excel 97 xsl file as a reference


  • Instead, two different formats were used: one from OpenOffice 2.0 beta sxw which is a compressed file and other a xml file from Microsoft Office 2003.


  • Since two different formats were used, the test is automatically void of meaning because of the lack of the original file.


  • Renaming the xml file to xsl like the author, I verified if it can be read with OpenOffice 2.2. It does not because the data is interpreted as xml which will exceed the limit of row in Calc application. Office Excel 2003 will render like a spreadsheet due to proprietary XML parser. However, Excel 2003 cannot read sxc nor OpendDocument Spreadsheet unless SUN's Open Document Format plugin is used.


  • The test is unrealistic in real world business because of the size (273 Mib of spreadsheet data). According to the author, the spreadsheet is actually a log file. One has to wonder why using a spreadsheet application to archive log.

Comments

Stephen Smoogen said…
As horrible as it sounds.. I have regularly seen 100+ MB excel spreadsheets with log data and other stuff in it.

Remember to look at the problem from a Windows users perspective. You have large amounts of data you want tabulated, and you have a very limited amount of tools to do it with. You can import the file into word, but it wont be able to correlate all the events together. So you import it into excel and have a column for time, for type of events, and data. Tada, now you can use a tool you are familiar with to manipulate the log data. (and you can use things like normalization etc if you need statistics). Is it optimal.. no.. but it is a matter of what tools you know. [I mean how many perl/awk/python programs do exactly the same thing because each specific author knew what one tool to write it with.]

Popular posts from this blog

GNOME extension Screen Autorotate available

 While waiting for a bug fix affecting majority of 2-in-1 laptops running on GNOME Wayland session, gnome-shell-extension-screen-autorotate is now available in Fedora repository and EPEL 9 . Give a try on your device Possibly this extension will get added on the incoming Fedora Design Suite 39 as default for the owners of convertible laptops.

Wayland support coming to Blender for Fedora 37

As mentioned on Phoronix' article ,  Blender received Wayland support on Blender 3.3.1 for Fedora 37 as an update in preparation of the incoming version 3.4 next month. The update has a dependency of libdecor , a client-side decoration for Wayland in addition of DBus for the cursor theme. Currently, the window decoration may have yet to use the system theme but remains functional as intended.

Testing Design Suite on Asus X550ZE

I recently bought an ASUS X550ZE to replace the venerable Sony VAIO N250E laptop. The reason of choosing an AMD powered laptop is for long term support i.e. the use of Vulkan API in future AMD GPU driver. In summary, here is the ASUS X550ZE specification taken from ASUS website : Processor AMD® APU A10-7400P /A8-7200P/FX-7600P Processor Chipset AMD A76M FCH Memory DDR3L 1600 MHz SDRAM, 8 GB Display 15.6" 16:9 /Full HD (1920x1080) Graphic AMD Radeon® R5 M230 + Radeon® R7 M265 DX Dual Graphics with 2GB DDR3 VRAM Built-in A10-7400P Storage 2.5" 9.5mm SATA 1TB 5400/7200 RPM Optical Drive Super-Multi DVD Card Reader 2 -in-1 card reader ( SD/ SDHC/ MMC) Camera VGA Web Camera Networking Integrated 802.11 b/g/n Built-in Bluetooth™ V4.0 (Optional) 10/100/1000/Gigabits Base T Interface 1 x COMBO audio jack 1 x VGA port/Mini D-sub 15-pin for external monitor 2 x USB 3.0 port(s) 1 x RJ45 LAN Jack for LAN insert 1 x HDMI Audio Built-in