Ask Your Question

From LO Calc to .ics calendar files for Thunderbird [closed]

asked 2012-09-30 17:58:54 +0200

sci_citation gravatar image

updated 2015-10-18 04:32:47 +0200

Alex Kemp gravatar image

Is there a simple way to achieve this? I don't want to hand-write a whole batch of dozends of dates into Thunderbird. There must be a way to perform this in Calc...

All I found was this Makro-based approach for Excel - which doesn't work in LO: (it's in german)

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 04:32:26.217326

1 Answer

Sort by » oldest newest most voted

answered 2012-10-03 15:39:25 +0200

sci_citation gravatar image

updated 2012-10-03 15:41:57 +0200

Here is a Makro from a OpenOffice-Board: (download)

It is possible to add a column for repetition (Wiederholung)

To the macro (section "writeICS") I appended to the paragraph " 'optionale Angaben" the following lines:


  s=osheet.getCellByPosition(9, posR).string

  if s<>"" then print #outFile,"RRULE:FREQ=" & Umlaut (s)


Now it adds the frequency as written in the additional column (WEEKLY, MONTHLY, YEARLY) to the .ics file.

edit flag offensive delete link more

Question Tools


Asked: 2012-09-30 17:58:54 +0200

Seen: 1,322 times

Last updated: Oct 03 '12