First time here? Check out the FAQ!
asked 2012-09-30 17:58:54 +0200sci_citation
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:
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