Asp Forum - [ANN] ri_cal 0.5.3 Released

Rick DeNatale

6/1/2009 3:21:00 PM

ri_cal version 0.5.3 has been released!

* <http://ri-cal.rubyforg...
* <by Rick DeNatale>

A new Ruby implementation of RFC2445 iCalendar.

The existing Ruby iCalendar libraries (e.g. icalendar, vpim) provide
for parsing and generating icalendar files,
but do not support important things like enumerating occurrences of
repeating events.

This is a clean-slate implementation of RFC2445.

A Google group for discussion of this library has been set up
http://groups.google.com/group...

Changes:

### 0.5.3 - 1 June, 2009
* Improved performance of time zone enumeration, TimeZonePeriod now
caches occurrences
* Added a profiling directory which contains ruby programs which
benchmark and/or profile performance
### 0.5.2
* Fixed http://rick_denatale.lighthouseapp.com/projects/30941/...
Export folding is not UTF-8 Safe
### 0.5.1
* Fixed README to acknowledge release on RubyForge
### 0.5.0 rubyforge release candidate Tue May 26 10:26:43 2009 -0400
* Added OccurrenceEnumerator#zulu_occurrence_range
### 0.0.11 Sat May 23 18:24:57 2009 -0400
* Fixed http://rick_denatale.lighthouseapp.com/projects/30941...
* Fixed http://rick_denatale.lighthouseapp.com/projects/30941...
### 0.0.10
* Fixed http://rick_denatale.lighthouseapp.com/projects/30941...
### 0.0.9
* Fixed http://rick_denatale.lighthouseapp.com/projects/30941...
Missing comparison methods in PropertyValue::Date
* Fixed http://rick_denatale.lighthouseapp.com/projects/30941...
Type of dtstart and dtend (DATE or DATETIME) now preserved on enumeration
### 0.0.8
* Fixed http://rick_denatale.lighthouseapp.com/projects/30941-ri_cal...
EXDATE and RDATE now pick up the timezone from DateTime, Time, and
TimeWithZone values
* Fixed http://rick_denatale.lighthouseapp.com/projects/30941...
Missing arithmetic methods in PropertyValue::Date
* Fixed http://rick_denatale.lighthouseapp.com/projects/30941...
Components with no recurrence rules or rdate properties failed
on enumeration, they now
will enumerate a single occurrence
### 0.0.7
* Fixed a bug relating to properly recognizing ActiveRecord::TimeWithZone
* DATETIME propertyvalues will now return an instance of TimeWithZone
instead of DateTime when
activesupport is present, and it is appropriate. See the README for details
### 0.0.6
* Added rake tasks to run specs with either the tzinfo gem or
activesupport (<=2.2)
* Default rake task now runs both of these
### 0.0.5
* Fixed a bug in occurrence enumeration reported by paulsm on github
### 0.0.4
* Fixed a bug in imported timezones reported by paulsm on github
### 0.0.3
* Added tzid method to Ruby Time and DateTime instances, and to
ActiveRecord::TimeWithZone if it is defined this method is used to
determine the desired
timezone when an instance of one of these classes is given as the
value of a datetime property. If the tzid is nil then the default
tzid is used,
if it is set to :floating then the property will be a floating time.
* Removed the ability to pass an array with a tzid string and a
date-time since the above made it unnecessary
* The ruby datetime property returned from the ruby_value method on
the DateTime property will return an instance of ::DateTime with:
** The proper utc offset
** The tzid set to the right tzid
* Made exdate/rdate building possible
* Added a default_tzid attribute to the Calendar component, if this
attribute is not set for a particular calendar it will delegate to the
default set
for the DateTime property class.
* Added fix patches from
** http://github.com/kjwiere...
** http://github.com/wesmaldon...

### 0.0.2
* Fixed gemspec
## 0.0.1

* <http://ri-cal.rubyforg...
* <by Rick DeNatale>

--
Rick DeNatale

Blog: http://talklikeaduck.denh...
Twitter: http://twitter.com/Ri...
WWR: http://www.workingwithrails.com/person/9021-ric...
LinkedIn: http://www.linkedin.com/in/ri...

6 Answers

witek

3/24/2010 7:15:00 PM

check Excel 2007 help for
XlFileFormat Enumeration

On 3/24/2010 1:24 PM, CLR wrote:
> Thanks Hector, but I need a little more help, if you please.
>
> The file in question will have been created in one of the following versions
> of Excel......I just want to know which one
> Excel 97
> Excel 2000
> Excel 2002
> Excel 2003
> Excel 2007
>
> BTW, where did your list of numbers come from?
>
> Thanks,
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
>
> "H??ctor Miguel" wrote:
>
>> hi, !
>>
>>> Wondering if it is possible to programatically determine which version of Excel a file was created in?
>>> I have folks send me a file and want some macros inserted, but don't tell me which version of Excel they are using.
>>
>> when your version is surely above the one created the file...
>>
>> try with: activeworkbook.fileformat
>>
>> 16: xlExcel2
>> 27: xlExcel2FarEast
>> 29: xlExcel3
>> 33: xlExcel4
>> 35: xlExcel4Workbook
>> 39: xlExcel5 or xlExcel7
>> 43: xlExcel9795
>> 50: xlExcel12
>> 56: xlExcel8
>>
>> hth,
>> hector.
>>
>>
>> .
>>

CLR

3/25/2010 4:24:00 PM

Thanks witek..........

I tried, but was unable to find it.

Vaya con Dios,
Chuck, CABGx3

"witek" wrote:

> check Excel 2007 help for
> XlFileFormat Enumeration
>
>
>
> On 3/24/2010 1:24 PM, CLR wrote:
> > Thanks Hector, but I need a little more help, if you please.
> >
> > The file in question will have been created in one of the following versions
> > of Excel......I just want to know which one
> > Excel 97
> > Excel 2000
> > Excel 2002
> > Excel 2003
> > Excel 2007
> >
> > BTW, where did your list of numbers come from?
> >
> > Thanks,
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> >
> > "H??ctor Miguel" wrote:
> >
> >> hi, !
> >>
> >>> Wondering if it is possible to programatically determine which version of Excel a file was created in?
> >>> I have folks send me a file and want some macros inserted, but don't tell me which version of Excel they are using.
> >>
> >> when your version is surely above the one created the file...
> >>
> >> try with: activeworkbook.fileformat
> >>
> >> 16: xlExcel2
> >> 27: xlExcel2FarEast
> >> 29: xlExcel3
> >> 33: xlExcel4
> >> 35: xlExcel4Workbook
> >> 39: xlExcel5 or xlExcel7
> >> 43: xlExcel9795
> >> 50: xlExcel12
> >> 56: xlExcel8
> >>
> >> hth,
> >> hector.
> >>
> >>
> >> .
> >>
>
> .
>

H?ctor Miguel

3/28/2010 6:28:00 AM

hi, Chuck !

> ... but I need a little more help, if you please.
> The file in question will have been created in one of the following versions of Excel
> I just want to know which one
> Excel 97
> Excel 2000
> Excel 2002
> Excel 2003
> Excel 2007
>
> BTW, where did your list of numbers come from?

it seems that fileformat "56: xlExcel8" is used from xl-97 to xl-2003
as per this ms-kb document (BIFF excel fomat - C++ code):
HowTo: Determine the Version of a Microsoft Excel Workbook
http://support.microsoft.com/k...

and, the list for version-number of "fileformat" comes from online help (xl-2007)

I'm sorry for not being able to go further in this matter :-(

regards,
hector.

__ previous __
>> when your version is surely above the one created the file...
>> try with: activeworkbook.fileformat
>>
>> 16: xlExcel2
>> 27: xlExcel2FarEast
>> 29: xlExcel3
>> 33: xlExcel4
>> 35: xlExcel4Workbook
>> 39: xlExcel5 or xlExcel7
>> 43: xlExcel9795
>> 50: xlExcel12
>> 56: xlExcel8

CLR

4/7/2010 2:11:00 PM

Ok, thanks anyway Hector.......that C++ stuff is out of my league.

Vaya con Dios,
Chuck, CABGx3

"H??ctor Miguel" wrote:

> hi, Chuck !
>
> > ... but I need a little more help, if you please.
> > The file in question will have been created in one of the following versions of Excel
> > I just want to know which one
> > Excel 97
> > Excel 2000
> > Excel 2002
> > Excel 2003
> > Excel 2007
> >
> > BTW, where did your list of numbers come from?
>
> it seems that fileformat "56: xlExcel8" is used from xl-97 to xl-2003
> as per this ms-kb document (BIFF excel fomat - C++ code):
> HowTo: Determine the Version of a Microsoft Excel Workbook
> http://support.microsoft.com/k...
>
> and, the list for version-number of "fileformat" comes from online help (xl-2007)
>
> I'm sorry for not being able to go further in this matter :-(
>
> regards,
> hector.
>
> __ previous __
> >> when your version is surely above the one created the file...
> >> try with: activeworkbook.fileformat
> >>
> >> 16: xlExcel2
> >> 27: xlExcel2FarEast
> >> 29: xlExcel3
> >> 33: xlExcel4
> >> 35: xlExcel4Workbook
> >> 39: xlExcel5 or xlExcel7
> >> 43: xlExcel9795
> >> 50: xlExcel12
> >> 56: xlExcel8
>
>
> .
>

JLGWhiz

4/7/2010 4:50:00 PM

It is pretty difficult to tell which Excel version a file was created in
between xl97 and xl02. The differences between them were mostly cosmetic
There were enhancements in forms controls and functions, but the platform
was virtually unchanged. xl07 and later is easy to distingruish because of
the four digit file extension. If you try to save a xl07 fiile in xl03 it
will ask you what you want to save it as, and vice versa in xl07. If using
VBA in different versions, you might get a message that a reference is
missing, but even that cannot be tied directly to a specific version.

"CLR" <CLR@discussions.microsoft.com> wrote in message
news:4DE18E9B-FC8E-4CC7-B86E-583A99BD715D@microsoft.com...
> Ok, thanks anyway Hector.......that C++ stuff is out of my league.
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "H?ctor Miguel" wrote:
>
>> hi, Chuck !
>>
>> > ... but I need a little more help, if you please.
>> > The file in question will have been created in one of the following
>> > versions of Excel
>> > I just want to know which one
>> > Excel 97
>> > Excel 2000
>> > Excel 2002
>> > Excel 2003
>> > Excel 2007
>> >
>> > BTW, where did your list of numbers come from?
>>
>> it seems that fileformat "56: xlExcel8" is used from xl-97 to xl-2003
>> as per this ms-kb document (BIFF excel fomat - C++ code):
>> HowTo: Determine the Version of a Microsoft Excel Workbook
>> http://support.microsoft.com/k...
>>
>> and, the list for version-number of "fileformat" comes from online help
>> (xl-2007)
>>
>> I'm sorry for not being able to go further in this matter :-(
>>
>> regards,
>> hector.
>>
>> __ previous __
>> >> when your version is surely above the one created the file...
>> >> try with: activeworkbook.fileformat
>> >>
>> >> 16: xlExcel2
>> >> 27: xlExcel2FarEast
>> >> 29: xlExcel3
>> >> 33: xlExcel4
>> >> 35: xlExcel4Workbook
>> >> 39: xlExcel5 or xlExcel7
>> >> 43: xlExcel9795
>> >> 50: xlExcel12
>> >> 56: xlExcel8
>>
>>
>> .
>>

CLR

4/8/2010 3:35:00 PM

Ok, thanks JLGWhiz..........
My problem is that I have users with all differing versions of XL and they
even change from time to time, so I have to know which version they are using
so my code will be compatible. Guess I'll just have to do it the "old
fashion way" and keep on asking them.

Vaya con Dios,
Chuck, CABGx3

"JLGWhiz" wrote:

> It is pretty difficult to tell which Excel version a file was created in
> between xl97 and xl02. The differences between them were mostly cosmetic
> There were enhancements in forms controls and functions, but the platform
> was virtually unchanged. xl07 and later is easy to distingruish because of
> the four digit file extension. If you try to save a xl07 fiile in xl03 it
> will ask you what you want to save it as, and vice versa in xl07. If using
> VBA in different versions, you might get a message that a reference is
> missing, but even that cannot be tied directly to a specific version.
>
>
>
> "CLR" <CLR@discussions.microsoft.com> wrote in message
> news:4DE18E9B-FC8E-4CC7-B86E-583A99BD715D@microsoft.com...
> > Ok, thanks anyway Hector.......that C++ stuff is out of my league.
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> > "H??ctor Miguel" wrote:
> >
> >> hi, Chuck !
> >>
> >> > ... but I need a little more help, if you please.
> >> > The file in question will have been created in one of the following
> >> > versions of Excel
> >> > I just want to know which one
> >> > Excel 97
> >> > Excel 2000
> >> > Excel 2002
> >> > Excel 2003
> >> > Excel 2007
> >> >
> >> > BTW, where did your list of numbers come from?
> >>
> >> it seems that fileformat "56: xlExcel8" is used from xl-97 to xl-2003
> >> as per this ms-kb document (BIFF excel fomat - C++ code):
> >> HowTo: Determine the Version of a Microsoft Excel Workbook
> >> http://support.microsoft.com/k...
> >>
> >> and, the list for version-number of "fileformat" comes from online help
> >> (xl-2007)
> >>
> >> I'm sorry for not being able to go further in this matter :-(
> >>
> >> regards,
> >> hector.
> >>
> >> __ previous __
> >> >> when your version is surely above the one created the file...
> >> >> try with: activeworkbook.fileformat
> >> >>
> >> >> 16: xlExcel2
> >> >> 27: xlExcel2FarEast
> >> >> 29: xlExcel3
> >> >> 33: xlExcel4
> >> >> 35: xlExcel4Workbook
> >> >> 39: xlExcel5 or xlExcel7
> >> >> 43: xlExcel9795
> >> >> 50: xlExcel12
> >> >> 56: xlExcel8
> >>
> >>
> >> .
> >>
>
>
> .
>

comp.lang.ruby

[ANN] ri_cal 0.5.3 Released

Rick DeNatale

witek

CLR

H?ctor Miguel

CLR

JLGWhiz

CLR

x Login to ForumsZone