Bug 35315 (ical)

Summary:	FEATURE REQUEST: import and export iCalendar files; FILEOPEN, FILESAVE
Product:	LibreOffice	Reporter:	Gerold Jens Wucherpfennig <gjwucherpfennig>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	80230co, retecomputer, stephane.guillou
Priority:	low
Version:	Inherited From OOo
Hardware:	All
OS:	All
URL:	http://www.windyweather.net/wp/2010/02/12/open-office-ical-importer/
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108254
Attachments:	an example iCalendar file - my plan for the Linux Tag in Chemnitz, Germany Spreadsheet OF iCal Values

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)

[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html

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