Re: [802SEC] New and Improved Sponsor Ballot Comment Spreadsheet in myProject
I agree. Numeric for line number input.
Best Regards,
Adrian P STEPHENS
Tel: +44 1954 204 609 (office)
Tel: +44 792 008 4900 (mobile, when in UK)
Tel: +1 408 239 7485 (mobile, when in the USA)
Skype: adrian_stephens
----------------------------------------------
Intel Corporation (UK) Limited
Registered No. 1134945 (England)
Registered Office: Pipers Way, Swindon SN3 1RJ
VAT No: 860 2173 47
-----Original Message-----
From: owner-stds-802-sec@ieee.org [mailto:owner-stds-802-sec@ieee.org] On Behalf Of James P. K. Gilb
Sent: Friday, June 01, 2012 6:14 PM
To: thompson@IEEE.ORG
Cc: g.marchini@IEEE.ORG; c.boyce@IEEE.ORG; 802 EC
Subject: Re: [802SEC] New and Improved Sponsor Ballot Comment Spreadsheet in myProject
All
A quick workaround for entry is to save it as .ods, then it ignores the validity setting.
However, I have never heard of Roman numerals for line numbers. Does that really happen? Probably the line number column should be simply checked for whole numbers.
Apparently the issue is that OpenOffice does not support the "Custom"
form of Data Validation.
James Gilb
On 06/01/2012 08:16 AM, Geoff Thompson wrote:
> Greg-
> Thanks you very much for sending me the spreadsheet to test.
> As you asserted, it is not useful for entering comments.
> What I found was that I as not able to enter anything in the cells
> that had entry formatting restrictions.
> I could enter data in those cells where the entry was via selection
> from a drop-down menu selection.
>
> Christina-
> You know that I have been a long-time advocate of getting these
> problems fixed but I think this release violates the primary principle of:
>
> "First of all, do no harm."
>
> I know it is an unintended consequence, but I think this change will
> disenfranchise a number of voters.
> I find two versions of the spreadsheet to be a highly distasteful solution.
> As a perhaps more palatable solution, is there any way that we could
> have just one spreadsheet but perhaps:
> - Have a macro that would disable the error checking or
> - Have a 2nd sheet that has no error checking (and the user could
> select which sheet to use) ??
>
> In any case, the information that was displayed to me regarding the
> format entry rules for that particular cell was most valuable. It is a
> great step up from the mysteries of the older version (although I am
> guessing the concise rule shown would not prove complete under real world use).
>
> Best regards,
>
> Geoff Thompson
>
> On 315//12 12:30 PM, g.marchini@ieee.org wrote:
>>
>> The form will not work properly in OpenOffice.
>>
>> The new form requires custom validations in Excel to function
>> properly. It looks like OpenOffice does not support the cusom
>> validations, but I don't know that much about Open Office.
>>
>> We could provide a version without the data validation for use in
>> other spreadsheet applications, but I'm not sure we can provide a
>> single file that performs all of the features in any application.
>>
>> I have attached a sample of the new spreadsheet.
>>
>> -Greg
>>
>>
>> Gregory Marchini
>> Standards Solutions Specialist
>> IEEE Standards Association
>> 445 Hoes Lane
>> Piscataway, NJ 08855
>> g.marchini@ieee.org
>> Office: 732-465-6696
>> Cell: 732-428-2858
>>
>>
>> /(See attached file: comments.xls)/
>>
>> Inactive hide details for Christina Boyce---05/31/2012 02:33:24
>> PM---Greg Can you send a sample file to Geoff so he can
>> test?Christina Boyce---05/31/2012
>> 02:33:24 PM---Greg Can you send a sample file to Geoff so he can test?
>>
>>
>> From:
>>
>>
>> Christina Boyce/STDS/STAFF/US/IEEE
>>
>> To:
>>
>>
>> thompson@ieee.org
>>
>> Cc:
>>
>>
>> Gregory Marchini/STDS/STAFF/US/IEEE@IEEE
>>
>> Date:
>>
>>
>> 05/31/2012 02:33 PM
>>
>> Subject:
>>
>>
>> Re: [802SEC] New and Improved Sponsor Ballot Comment Spreadsheet in
>> myProject
>>
>>
>> ---------------------------------------------------------------------
>> -----------
>>
>>
>> Greg
>> Can you send a sample file to Geoff so he can test?
>>
>> Thanks!
>> 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
>>
>>
>>
>> Inactive hide details for Geoff Thompson ---05/31/2012 02:09:38
>> PM---Christina- My personal belief is that the requirement is fGeoff
>> Thompson
>> ---05/31/2012 02:09:38 PM---Christina- My personal belief is that
>> the requirement is for an Excel spreadsheet
>>
>>
>> From:
>>
>>
>> Geoff Thompson<thompson@ieee.org>
>>
>> To:
>>
>>
>> c.boyce@ieee.org
>>
>> Cc:
>>
>>
>> STDS-802-SEC@LISTSERV.IEEE.ORG
>>
>> Date:
>>
>>
>> 05/31/2012 02:09 PM
>>
>> Subject:
>>
>>
>> Re: [802SEC] New and Improved Sponsor Ballot Comment Spreadsheet in
>> myProject
>>
>>
>> ---------------------------------------------------------------------
>> -----------
>>
>>
>>
>> Christina-
>>
>> My personal belief is that the requirement is for an Excel
>> spreadsheet to work on popular and/or freely available platforms.
>> I don't envision this to be any different than the need to test web
>> pages on several browsers.
>>
>> Open Office does read and write Excel format spreadsheets.
>> Hopefully you haven't done anything within Excel that the Open
>> Office folks have not provided for.
>>
>> I would also be happy to take a pre-release look at the spreadsheet
>> and see if I can help define any obvious problems. The best solution
>> (of
>> course) would be to have an Excel formatted form that works well on
>> either platform so that we do not have to burden the users with the
>> concern of which platform they well use.
>>
>> Best regards,
>>
>> Geoff Thompson
>>
>> On 315//12 10:53 AM, Christina Boyce wrote:
>> > Geoff
>> > The original request was to allow MS Excel. We just tested and OO
>> does > not work properly. I will discuss with the developers to
>> determine if > this is something that is an easy fix or if we need
>> to develop a new OO > formatted form.
>> >
>> > 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 > > > > > From:
>> > Geoff Thompson<thompson@ieee.org> > To:
>> > c.boyce@IEEE.ORG
>> > Cc:
>> > STDS-802-SEC@LISTSERV.IEEE.ORG, Geoff Thompson<thompson@IEEE.ORG>
>> > Date:
>> > 05/31/2012 11:17 AM
>> > Subject:
>> > Re: [802SEC] New and Improved Sponsor Ballot Comment Spreadsheet
>> in > myProject > Sent by:
>> > owner-stds-802-sec@ieee.org
>> >
>> >
>> >
>> > 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.
>> >
>> >
>>
>>
>>
----------
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.