tracker issue : CF-3303703

select a category, or use search below
(searches all categories and all time range)
Title:

Spreadsheets created with CFSpreadsheet don't allow for End+Arrow Navigation

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/

Reporter/Name(from Bugbase): James Moberg / James Moberg (James Moberg)

Created: 08/06/2012

Components: Document Management, Office Integration

Versions: 9.0.1

Failure Type: Unspecified

Found In Build/Fixed In Build: 9.0.1 /

Priority/Frequency: Trivial / All users will encounter

Locale/System: English / Win 2008 Web Server

Vote Count: 0

Problem Description:  Excel files generated by ColdFusion don't allow for moving the cell cursor to the next "blank" cells using the keyboard.
http://www.dummies.com/how-to/content/moving-the-cell-cursor-in-excel-2010-spreadsheets.html

Steps to Reproduce:  Read any manually generated Excel file as a query and re-save to a new Excel file.  Pressing END+Arrow will move focus to the beginning or end of the spreadsheet instead of first occupied cell to the right in the same row that is either preceded or followed by a blank cell.

Actual Result:  Pointer goes to the cell at the very end of the row.

Expected Result:  Pointer goes to first occupied cell to the right in the same row that is either preceded or followed by a blank cell.

Any Workarounds:  None.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3303703

External Customer Info:
External Company:  
External Customer Name: Jamo
External Customer Email:  
External Test Config: My Hardware and Environment details: Using ColdFusion 9.0.1 (Windows 32bit) and Microsoft Office Professional Plus 2010 Excel.  (NOTE: May affect CF10 too.)

Attachments:

Comments:

unable to repro the issue with CF902 (multiserver) on Win 7x64. checked both .xls and .xlsx files. End + left/right/up/down arrow moves the focus to the first or last occupied cell. behavior same with CF generated and manually created spreadsheet.
Comment by Piyush K.
18609 | October 28, 2013 08:29:26 AM GMT