Andrew Jensen wrote: > Well, now that I have had my laugh - and it was doubled as I > remembered I already knew your name, back to the topic at hand. * > While I wait to hear from our intrepid user swarup * > > ---------------------------------------------------------------------------------------------------------------------------- >
Yes, we exchanged some mails on that Calc2Base project, where I tried to gain a foothold on the spreadsheet side of the problem. That work finally resulted in a more general add-on for Calc: http://ooomacros.org/user.php#221020 Use this tool together with some simple spreadsheet functions in order to check for data integrity (text vs. numbers, blanks and errors, duplicates, max. lenght of strings, max/min of numeric values). Add 2 days to all your date values or format as ISO date, since Base's number2date conversion assumes 1900-01-01 as day #0, whereas most Calc sheets assume 1899-12-30. The rest should be taken by the copy/paste wizzard. Well, it should if it where not that buggy. But I can't write a better one. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
