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:
http://www.sunbird-kalender.de/forum/viewtopic.php?f=12&t=3220 (it's in german)
Here is a Makro from a OpenOffice-Board: http://de.openoffice.info/download/file.php?id=3959 (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:
`'Wiederholung
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.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-09-30 17:58:54 +0200
Seen: 126 times
Last updated: Oct 03 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.