Tag Archives: excel

Update on border lines

Share Button

Just a quick update to my last post on getting Calc’s border line situation sorted out. As of last post, the border lines were pretty in good shape as far as printing to paper, but it was still less than … Continue reading

Posted in | Tagged , , , | 2 Comments

The art of drawing border lines

Share Button

I spent this past week on investigating a collection of various problems surrounding how Calc draws cell borders. The problem is very hard to define and can become very subjective depending on who you talk to. Having said that, if … Continue reading

Posted in | Tagged , , , | 2 Comments

SUSE Hack Week

Share Button

Last week was SUSE’s Hack Week – an event my employer does periodically to allow us – hard working engineers – to go wild with our wildest ideas and execute them in one week. Just like what I did at … Continue reading

Posted in | Tagged , , , , | 4 Comments

mso-dumper now packaged in OBS

Share Button

I’m happy to announce that the mso-dumper tool is now packaged in the openSUSE build service under my home repository. This tool is written in Python, and allows you to dump the contents of MS Office documents stored in the … Continue reading

Posted in | Tagged , , , , , , | 2 Comments

ODF Support in MS Office 2007

Share Button

I guess it’s all over the news right now, that the latest service pack (SP2) for MS Office 2007 will enable Office to import and export ODF natively. This blog piece by Doug Mahugh touches on the word processor part … Continue reading

Posted in | Tagged , , , | Comments Off on ODF Support in MS Office 2007

Encrypting an Excel document with password from Calc

Share Button

The feature of exporting an Excel document encrypted with a password has landed! Now you can save a spreadsheet document as an Excel document with password protection and open it in Excel with that password. The proof is in the … Continue reading

Posted in | Tagged , , , , , | 1 Comment

New sheet protection dialog

Share Button

I’ve just finished designing a new dialog for Calc’s sheet protection functionality to allow optional sheet protection options. This was actually my first time designing a dialog from scratch instead of modifying an existing one, so I had to dig … Continue reading

Posted in | Tagged , , , | Comments Off on New sheet protection dialog

Excel workbook and worksheet protection

Share Button

I didn’t mean to keep this a secret, but I’ve been working on two tasks since December to further enhance Calc’s interoperability with Excel. The first one is to support correct import of an Excel document that includes password-protected worksheets, … Continue reading

Posted in | Tagged , , , | 2 Comments

Excel sheet protection password hash

Share Button

When you protect either your workbook or one of your worksheets with a password in Excel, Excel internally generates a 16-bit hash of your password and stores it instead of the original password text. The hashing algorithm used for that … Continue reading

Posted in | Tagged , , , | 8 Comments

Importing Excel 2007 files

Share Button

The Excel 2007 filter for Calc is still on its way, but perhaps now is a good time to show the progress of this new Excel 2007 import filter work by Daniel Rentz and myself. Here is a screenshot of … Continue reading

Posted in | Tagged , , , , | 8 Comments