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

Smooge 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

Running Fedora 25 Design Suite on ASUS X550ZE laptop

This blog is written on Fedora 25 Design Suite running on ASUS X550ZE.The upgrade from Design Suite 24 to 25 using Gnome Software went smooth with very little impact to the entire system.


Inheriting the features from Fedora 25 Workstation, Design Suite now gained further support of hybrid hardware notably laptops (see above feature). Following the release cycle, supplemental wallpapers from Fedora 23 are replaced by their 25th version to mark the end of life of the 23rd release next month.

Design received new applications like Gnome Books useful for e-books and Calendar to easily manage the schedule.

  To enable full support of hotkeys and optimal power management due to the boot scheme bug in Linux kernel, 4.9.0rc4 or above (currently residing in Rawhide nodebug repository at the time of writing) is required and will soon reach availability via update. The case applied to some hybrid laptops (ASUS X550ZE in this example).

Looking for Design Suite 26 with further improvement of Gnome …

Scribus in copr scribus-unstable repository now supports spellcheck

Starting from 1.5.3-0.19 snapshot, Scribus now has spell check enabled, one of requested features for free and open source desktop publishing software. Additionally, this version includes appstream by default allowing visibility in both Gnome Software and Apper.
The ability to read Microsoft Visio, Pagemaker and even Adobe InDesign files is a welcome addition to see the migration. More changelog available

Users looking to try this snapshot can access COPR repository and install it alongside the stable version.

On a side note, Scribus Generator is an excellent utility for mail-merge alternative.

Blender and video sequence editor on Fedora

Due to the legal matter related to FFMpeg, the video editor on Blender for Fedora will fail to run any video format. Tracking this bug report, it seems possible to build FFMPEG without the patented codecs thus possibly allow Blender video editor to properly run.

For the time being, alternative is already available on Fedora repository like Pitivi bundled in Fedora Design Suite. The downside is the occasional crash while editing, the upside is the use of extensible Gstreamer on several plugins compared to FFMPEG although the latter is popular.