I routinely take Excel spreadsheets and convert them to Calc. The spreadsheets are functional specifications for a product I am working on. The problem is there are a number of columns that use date calculations that require the Excel DATEDIF() function. OpenOffice.org have roughly functions such as YEARS(). The ODF specification (ISO/IEC 26300:2006 Open Document Format for Office Applications (OpenDocument) v1.0) does define the DATEDIF() function AFAIK. Actually, it is a minor pain to convert these as the total time is about 5 mins a couple of times a month. Actually, GNUMeric support datedif() but GNUMeric is not supported on RHEL 4 Update 3 that I am required to run. One of the big benefits for the spec writer using Excel and me using OO.o is that it catches some errors. The person writing the spec could use OO.o since it is installed on her Windows laptop, but others in the company only use Excel so we do need to maintain the document in MS .xls format.
-- -- Jerry Feldman <[EMAIL PROTECTED]> Boston Linux and Unix PGP key id: 537C5846 PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB CA3B 4607 4319 537C 5846
signature.asc
Description: PGP signature
