tracker issue : CF-4203227

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

Row formatting in cfspreadsheet action=\update\

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/Fixed

Reporter/Name(from Bugbase): / ()

Created: 08/03/2018

Components: Document Management, Office Integration

Versions: 2016,11.0,2018

Failure Type: Incorrectly functioning

Found In Build/Fixed In Build: 2018,0,0,311090 / 2018,0,02,313101

Priority/Frequency: Minor / Few users will encounter

Locale/System: /

Vote Count: 0

 cfspreadsheet action="update" does automatic formatting of excel rows.

 

Repro Code:

<cfprocessingdirective pageencoding="utf-8" >

<cfset thefile = "test10.xls">

<cfset thePath = ExpandPath("L04111.xls")>

<cfset thesheet = spreadsheetread("#thePath#")>

<cfspreadsheet action="write" filename="#thefile#" name="thesheet" overwrite="true">             

<cfset thesheet = spreadsheetread("#thePath#","Error Code List")>

<cfspreadsheet action="update" filename="#thefile#" name="thesheet" sheetname="test">

 

The test "tab" in excel gets automated row formatting

 

Attachments:

Comments: