Bug 35315 (ical) - FEATURE REQUEST: import and export iCalendar files; FILEOPEN, FILESAVE
Summary: FEATURE REQUEST: import and export iCalendar files; FILEOPEN, FILESAVE
Status: NEW
Alias: ical
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: low enhancement
Assignee: Not Assigned
URL: http://www.windyweather.net/wp/2010/0...
Whiteboard:
Keywords:
: 156872 (view as bug list)
Depends on:
Blocks: Format-Filters
  Show dependency treegraph
 
Reported: 2011-03-14 14:16 UTC by Gerold Jens Wucherpfennig
Modified: 2023-10-01 12:14 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
an example iCalendar file - my plan for the Linux Tag in Chemnitz, Germany (17.87 KB, text/calendar)
2011-03-14 14:16 UTC, Gerold Jens Wucherpfennig
Details
Spreadsheet OF iCal Values (1.37 KB, text/csv)
2023-10-01 12:14 UTC, 80230co
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gerold Jens Wucherpfennig 2011-03-14 14:16:42 UTC
Created attachment 44451 [details]
an example iCalendar file - my plan for the Linux Tag in Chemnitz, Germany

It would be really nice if there could be some iCalendar
import and export filters for .ics files.

I haven't tested:
http://www.windyweather.net/wp/2010/02/12/open-office-ical-importer/

but could a real import and export filter for .ics files be coded
as a macro like that open-office-ical-importer?

That would be relatively easy and nice :-)
Comment 1 Björn Michaelsen 2011-12-23 11:45:03 UTC Comment hidden (obsolete)
Comment 2 Volker Merschmann 2012-06-06 13:54:49 UTC
Fixed typo in Summary
Comment 3 Joel Madero 2012-06-08 10:33:57 UTC
Marking as NEW as no info is needed. This sounds like a good feature request.
Comment 4 Stéphane Guillou (stragu) 2023-09-30 22:19:04 UTC
*** Bug 156872 has been marked as a duplicate of this bug. ***
Comment 5 Stéphane Guillou (stragu) 2023-09-30 22:21:03 UTC
Related Ask.LO questions:
- https://ask.libreoffice.org/t/libreoffice-calc-how-to-export-spreadsheet-into-icalendar-format-ics-file/33065
- https://ask.libreoffice.org/t/request-for-exporting-calc-spreads-in-ical-format/94932

The import sounds straight-forward, but I'm unsure about the export. As I've said in the duplicate bug 156872:

I think the issue here is that it is not straight-forward to know how the user has structured the information in their spreadsheet to then export that into an ICS file...
I assume it would have to be a guided process, asking the user which column goes where (start date-time, end date-time, description of event...).
Comment 6 80230co 2023-10-01 12:14:17 UTC
Created attachment 189931 [details]
Spreadsheet OF iCal Values

Monthly Bills in csv format for Conversion to iCal