Re: [802SEC] New and Improved Sponsor Ballot Comment Spreadsheet in myProject

["James P. K. Gilb" <gilb@ieee.org>]

Christina

I run LibreOffice on a PC under Ubuntu.  Please forward me the 
spreadsheet so that I can test it.

Thanks.

James Gilb

On 05/31/2012 08:08 AM, Geoff Thompson wrote:
> Christina-
>
> Thanks for doing this, REALLY !!
> One question:
> What are the various spreadsheets/versions that this has been/(will be)
> tested against?
> The one(s) that I am particularly interested in is:
> OpenOffice 3.4.0 running on a MAC
> (I believe that Dr. Gilb runs OOo on a PC)
>
> Thanks again,
>
> Geoff Thompson
>
> On 305//12 5:23 PM, Christina Boyce wrote:
> > I am happy to announce that with the next software release this week we
> > will have completed request/ticket # 1026/108 which states:
> >
> > " Improve Sponsor Ballot Comment Spreadsheet. Making commenters life easy
> > is key because, unlike officers, they are unlikely to take the time to
> > educate themselves to work around problems. Do not use macros in this
> > solution since some companies do not allow users to download macros. Some
> > data on validation can be found here
> > http://office.microsoft.com/en-us/excel-help/apply-data-validation-to-cells-HP010072600.aspx
> >
> > .
> > In addition to the CSV download, provide the commenter the ability to
> > download a MSExcel comment spreadsheet that has the following:
> > * data validation to the MS Excel spreadsheet (only allow ASCII character
> > set)
> > *validate number fields to allow numerals and/or Roman numerals
> > * data validation messages.
> > * Turn off auto correct.
> > * Only allow ASCII character set
> >
> > RESOLUTION:
> > * Developers have added data validation to ballot XLS spreadsheet as per
> > proposed resolution
> > * Generate a XLS spreadsheet for myBallot comment import which includes
> > similar data validation as the previous ePoll XLS
> > * The ballot name and close date are included in the spreadsheet header.
> > * Ensure subclause is a single item which allows numbers, dots, and alpha
> > characters.
> > * Line and page number now accept Roman numeral values.
> >
> > Please let me know if you have any questions about this change.
> >
> > Regards,
> > Christina Boyce
> > Manager Standards Solutions Services, IEEE Standards
> > 445 Hoes Lane
> > Piscataway, NJ 08855
> > c.boyce@ieee.org
> > Phone 732-562-5540
> > Cell 908-239-4038
> >
> > IEEE ? Advancing Technology for Humanity
> >
> > ----------
> > This email is sent from the 802 Executive Committee email reflector.
> > This list is maintained by Listserv.
>
> ----------
> This email is sent from the 802 Executive Committee email reflector.
> This list is maintained by Listserv.

----------
This email is sent from the 802 Executive Committee email reflector.  This list is maintained by Listserv.