Thread Links Date Links
Thread Prev Thread Next Thread Index Date Prev Date Next Date Index

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



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.