Bug: Word Count format incorrect in Excel

Page 1 of 1 (13 items)
This post has 12 Replies | 0 Followers

Posts 24923
Forum MVP
Dave Hooton | Forum Activity | Posted: Thu, Dec 18 2014 3:23 PM

When a Word List is exported to Excel the format of "Count" is unusable as a number

Print/Export as Spreadsheet to Excel 2013 (XML file).

Dave
===

Windows & Android

Posts 24923
Forum MVP
Dave Hooton | Forum Activity | Replied: Fri, Dec 19 2014 11:58 AM

Dave Hooton:
When a Word List is exported to Excel the format of "Count" is unusable as a number

It is formatted with an apostrophe ' and I have to use  =NUMBERVALUE("'21",".","'") and F2 to manually convert each cell to a number.

Dave
===

Windows & Android

Posts 275
Bob Soule | Forum Activity | Replied: Sat, Dec 20 2014 12:48 PM

Dave Hooton:

When a Word List is exported to Excel the format of "Count" is unusable as a number

Print/Export as Spreadsheet to Excel 2013 (XML file).

Both my mac Excel (2011) and windows Excel 2010 allow to convert the column of text numbers to a number by selecting the column than the click on the pull down for the caution and choose "Convert to number" as in the image below. Have you tried this?

Posts 24923
Forum MVP
Dave Hooton | Forum Activity | Replied: Sat, Dec 20 2014 2:11 PM

Bob Soule:
Both my mac Excel (2011) and windows Excel 2010 allow to convert the column of text numbers to a number by selecting the column than the click on the pull down for the caution and choose "Convert to number" as in the image below. Have you tried this?

that is slower than using  =NUMBERVALUE("'21",".","'"). One setup I just repeat the key sequence F2+Enter to go through all the cells.

Dave
===

Windows & Android

Posts 275
Bob Soule | Forum Activity | Replied: Sat, Dec 20 2014 3:33 PM

Dave Hooton:

Bob Soule:
Both my mac Excel (2011) and windows Excel 2010 allow to convert the column of text numbers to a number by selecting the column than the click on the pull down for the caution and choose "Convert to number" as in the image below. Have you tried this?

that is slower than using  =NUMBERVALUE("'21",".","'"). One setup I just repeat the key sequence F2+Enter to go through all the cells.

How is it slower it? It is just two clicks, select the column (C) then select "Convert to number"does the entire column.

Posts 26492
Forum MVP
MJ. Smith | Forum Activity | Replied: Sat, Dec 20 2014 3:36 PM

did the apostrophe belong in column B?

Orthodox Bishop Hilarion Alfeyev: "To be a theologian means to have experience of a personal encounter with God through prayer and worship."

Posts 24923
Forum MVP
Dave Hooton | Forum Activity | Replied: Sat, Dec 20 2014 7:06 PM

Bob Soule:
convert the column of text numbers to a number by selecting the column than the click on the pull down for the caution and choose "Convert to number"

The caution box did not appear when I selected the column i.e. by clicking the column identifier (C). Now I see that shift-selecting the column from row 2 down does the job as you describe!

Dave
===

Windows & Android

Posts 24923
Forum MVP
Dave Hooton | Forum Activity | Replied: Sat, Dec 20 2014 7:07 PM

MJ. Smith:

did the apostrophe belong in column B?

Unlikely

Dave
===

Windows & Android

Posts 24923
Forum MVP
Dave Hooton | Forum Activity | Replied: Sun, Jan 18 2015 4:06 PM

when will this be fixed?

Dave
===

Windows & Android

Posts 1258
LogosEmployee
Dylan Rondeau | Forum Activity | Replied: Mon, Jan 19 2015 8:41 AM

Dave Hooton:

when will this be fixed?

Looks like this was overlooked earlier, my apologies. I'm creating a case currently, but is there any particular reason you use "Save as... Spreadsheet (Excel, etc.)" rather than "Send to... Microsoft Excel"?

I'm able to reproduce the issue with the Spreadsheet option, but it works correctly with Send to Excel. Is there any functionality difference between the two options that you would prefer Spreadsheet?

Dylan Rondeau, Software Tester

Enable Logging: Mac | Windows (Right-click "Save As...")

Posts 24923
Forum MVP
Dave Hooton | Forum Activity | Replied: Mon, Jan 19 2015 11:53 AM

Dylan Rondeau:
but it works correctly with Send to Excel. Is there any functionality difference between the two options that you would prefer Spreadsheet?

Send to Excel still has the "disappearing" bug in 6.0b!

Dave
===

Windows & Android

Posts 1471
Angela Murashov | Forum Activity | Replied: Mon, Jan 26 2015 2:25 PM

Dylan Rondeau:
I'm able to reproduce the issue with the Spreadsheet option

This should be fixed in 6.1 Beta 3.

Posts 24923
Forum MVP
Dave Hooton | Forum Activity | Replied: Tue, Jan 27 2015 1:09 AM

thank you -- fixed in Beta 3.

Dave
===

Windows & Android

Page 1 of 1 (13 items) | RSS