displaying top 100 results
Tracker Issue Row formatting in cfspreadsheet action=\update\
4656715 CF-4203227 Document Management : Office Integration Row formatting in cfspreadsheet action=\update\ cfspreadsheet action="update" does automatic formatting of excel rows.
Repro Code:
The test "tab" in excel gets automated row formatting
Bug 78863:Integration with OpenOffice documentation needs clarificationThe collective documentation on OpenOffice integration does not give a consistently clear picture of which versions of MS Office are suppor
Tracker Issue Monitoring CFSpreadSheet
3078485 CF-4198618 Document Management : Office Integration,Performance Barry Friedland Monitoring CFSpreadSheet Currently there is no way to monitor the progress of . For big files this can cause a long delay.
Either provide a way to monitor a file size or allow the ability to append
Tracker Issue Need formatting parameter for cfspreadsheeet
2950605 CF-4198428 Document Management : Office Integration Barry Friedland Need formatting parameter for cfspreadsheeet SpreadsheetFormatCell does not provide a way to color fill a cell background color. The closest is fillpattern but that is not what I want. The attached Excel file shows 3
Tracker Issue Delimiter for SpreadsheetAddRow
2596801 CF-3713386 Document Management : Office Integration Randi Knutson Delimiter for SpreadsheetAddRow Please allow for alternate delimiters other than the comma.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3713386
External Customer
Tracker Issue There should be a spreadsheetGetFormatting() function
2610594 CF-3694387 Document Management : Office Integration Adam Cameron There should be a spreadsheetGetFormatting() function There's a SpreadsheetFormatCell() function, but no getter equivalent. There should be.
--
Adam
----------------------------- Additional Watson Details
Tracker Issue SpreadSheetAddFreezePane
5702291 CF-4204296 Document Management : Office Integration SpreadSheetAddFreezePane Problem Description: SpreadSheetAddFreezePane(SpreadsheetObj,3,2) gives error
The parameter left column 2 must not be less than the column parameter 3.
in fact in the documentation : Spreadsheet
2603275 CF-3035810 Document Management : Office Integration todd sharp Bug 72682:
When the resultant file is opened with OpenOffice (version 2.3) all of the rows containing output are initially hidden (height = 0).
Method:
Result:
----------------------------- Additional Watson Details
Tracker Issue spreadsheetAddRow support array
2608982 CF-3950771 Document Management : Office Integration Raymond Camden spreadsheetAddRow support array spreadsheetAddRow is pretty much unsafe to use with *any* dynamic data unless you first sanitize the data to not include commas. To correct this, allow this function to take an array
2612971 CF-3356817 Document Management : Office Integration Adam Cameron No equivalent of in spreadsheetRead() provides for the ability to row & column limit what's read in from the XLS. spreadsheetRead() does not offer the equivalent, and I can see no way of effecting this functionality
2598783 CF-3040949 Document Management : Office Integration Donald Bellenger Bug 82123: If it is set as a var, it fails with no error message! This is a BIG time sink. I don't know about thread safeness.
Method:
Result:
NONE!
----------------------------- Additional Watson Details
Tracker Issue [ANeff] Doc Bug for: SpreadsheetAddRows doc has chl-author-preview.corp.adobe.com links
://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-s/spreadsheetaddrows.html
2) under "Category", click "Spreadsheet functions" and "Microsoft Office integration functions"
Actual result:
- "Spreadsheet functions" links to https
Tracker Issue Apache POI getHyperlink integration for CFSpreadsheet
2672730 CF-4175063 Document Management : Office Integration matt wilde Apache POI getHyperlink integration for CFSpreadsheet I love Spreadsheet and Query functions in CF but have not been able to find a Coldfusion Function for getting a Cell's hyperlink data. cellFormat does not contain that data
Tracker Comment Comment on Office 365 and Mail Server Error 550 by Richard O.
HUGE issues integrating with cloud mail services such as GMail and Office365 Exchange. Go ahead and Google 'Coldfusion with Office365' and you'll quickly find the myriad of people running into the same problem.
"are you setting anything besides the server name, user and password?"
Port 587 and check
Tracker Issue An exception occurred while using action=write. at coldfusion.excel.Excel.writeExcel Error when using cfspreadsheet tag.
2608088 CF-4195395 Document Management : Office Integration Masha Edelen An exception occurred while using action=write. at coldfusion.excel.Excel.writeExcel Error when using cfspreadsheet tag. Problem Description:
Unable to use cfspreadsheet tag after the update with the following code:
Getting
2609229 CF-3875661 Document Management : Office Integration Adam Tuttle spreadsheetRead does not support all of the attributes available in supports the following attributes when action="read":
- headerrow
- excludeHeaderRow
- columns
- columnNames
- rows
- src
- sheetname
The supposed script
Tracker Issue spreadsheetaddsplitpane does not work when a spreadsheet object is added to an existing file using action = update.
2609697 CF-3800030 Document Management : Office Integration ext-user spreadsheetaddsplitpane does not work when a spreadsheet object is added to an existing file using action = update. Problem Description:
spreadsheetaddsplitpane does not work when a spreadsheet object is added to an existing file
2611496 CF-3616845 Document Management : Office Integration Claudio Cabete SpreadSheetSetColumnWidth stops working after updating to ColdFusion 10 Update 11 Problem Description:
SpreadSheetSetColumnWidth stops working after updating to ColdFusion 10 Update 11
Steps to Reproduce:
Actual Result
2611989 CF-3567818 Document Management : Office Integration ext-user spreadsheetwrite autosize does not work to re-size columns with datetime values. Problem:
spreadsheetwrite autosize does not work to re-size columns with datetime values.
Method:
Result:
a row from
Tracker Issue Apple iPad can not open simple cfspreadsheet els
2596934 CF-3344105 Document Management : Office Integration Rand Whitney Apple iPad can not open simple cfspreadsheet els Problem Description:
Apple iPad can not open simple xls file created by
Steps to Reproduce:
Using Apple's latest iOS 6 and latest version of iPad Numbers, try creating a simple
2613837 CF-3158250 Document Management : Office Integration ext-user CFSPREADSHEET.spreadSheetFormatRow not re-setting bold and italic to no/false Problem:
spreadSheetFormatRow not re-setting bold and italic to no/false
Method:
See notes
SingleSheet.xls attached
Tracker Issue cfspreadsheet not handling clobs.
2597094 CF-3120738 Document Management : Office Integration Mike Squire cfspreadsheet not handling clobs. Problem Description:
Clob in query becomes gibberish in spreadsheet.
Steps to Reproduce:
write a cfspreadsheet using a query containing a clob
Actual Result:
gibberish like 'C@9788973
Tracker Issue Bug 84013:(Watson Migration Closure)I'd like to see support for Excel AutoFilters added to cfspreadsheet
2597899 CF-3042117 Document Management : Office Integration Rob Brooks-Bilson Bug 84013:(Watson Migration Closure)I'd like to see support for Excel AutoFilters added to cfspreadsheet Problem:
I'd like to see support for Excel AutoFilters added to cfspreadsheet. AutoFilter support was recently
2599103 CF-3040583 Document Management : Office Integration Rob Kolosky Bug 81151:When writing values to a spreadsheet, leading zeroes are removed Duplicate ID: CF-3039981
Problem:
When writing values to a spreadsheet, leading zeroes are removed. They should be preserved.
Method:
Look
2599948 CF-3039549 Document Management : Office Integration Rob Kolosky Bug 79265:(Watson Migration Closure)Can cfspreadsheet access page setup, in order to set Landscape or portrait mode? Or set the scale?In Apache POI, I can say:
Method:
Result:
----------------------------- Additional Watson
2599950 CF-3039547 Document Management : Office Integration Rob Kolosky Bug 79263:(Watson Migration Closure)Is there a way to specify a page break in cfspreadsheet?In Apache POI, I can do:And that creates a page break with the first page having one row.
Method:
Result
Tracker Issue Bug 78854:There is no script version of cfspreadsheet
2600165 CF-3039320 Document Management : Office Integration Sam Farmer Bug 78854:There is no script version of cfspreadsheet Duplicate ID: CF-3038880
Problem:
There is no script version of cfspreadsheet. This means that you can not write a spreadsheet while working in cfscript.ER: Add script
Tracker Issue Bug 72757:CFEXCEL Should Not Output Complete HTML Table
2603202 CF-3035885 Document Management : Office Integration Michael Dawson Bug 72757:CFEXCEL Should Not Output Complete HTML Table Problem:
CFEXCEL Should Not Output Complete HTML Table
CFEXCEL should not output tags. When a full table it rendered, it is almost impossible (without javascript
2603203 CF-3035884 Document Management : Office Integration Michael Dawson Bug 72756:CFEXCEL tag attribute semantics imply a single value Problem:
CFEXCEL tag attribute semantics imply a single value.
The following CFEXCEL attributes imply that you can only supply one value, rather than a comma
2603274 CF-3035811 Document Management : Office Integration todd sharp Bug 72683:Excel sheet numbering is using a zero based index Problem:
Excel sheet numbering is using a zero based index.
returns a sheetnumber = 0
for the record you can also read sheet zero with the tag (and it returns
Tracker Issue Bug 72667:We need an isExcelObject and isExcelFile to mimic the ones we have for images, pdfs
2603289 CF-3035795 Document Management : Office Integration Raymond Camden Bug 72667:We need an isExcelObject and isExcelFile to mimic the ones we have for images, pdfs Problem:
We need an isExcelObject and isExcelFile to mimic the ones we have for images, pdfs.
Method:
Result
2603290 CF-3035794 Document Management : Office Integration Raymond Camden Bug 72666:excelAddRow needs to support an optional 3rd argument for delimiter Problem:
excelAddRow needs to support an optional 3rd argument for delimiter. For example, I can't add this as 2 cells:
Name=Camden,Raymond
Age
Tracker Issue Give spreadsheetread() ability to read from file object
4121382 CF-4201687 Document Management : Office Integration Jack Drysdale Jr Give spreadsheetread() ability to read from file object Currently, spreadsheetRead() / cfspreadsheetread can only read an Excel file saved to disk. I would like spreadsheetRead() and cfspreadsheetread to have the ability
Tracker Issue CFDIRECTORY to EXCEL
4843147 CF-4203340 Document Management : Office Integration CFDIRECTORY to EXCEL Problem Description: I want to export a file structure to an excel file
Steps to Reproduce:
xlsExport = SpreadsheetNew("Listing",true);
spreadsheetSetActiveSheet(xlsExport,"Listing");
spreadsheet
Tracker Issue cfspreadsheet crashes/locked up server with (238kb) file
5652628 CF-4204270 Document Management : Office Integration cfspreadsheet crashes/locked up server with (238kb) file Problem Description:
When trying to read certain excel documents we've run into an issue where it will crash our server. There are no errors, but Coldfusion continues to take up CPU
Tracker Issue SpreadSheetRead() Does Not Read Past First Page
6289435 CF-4205357 Document Management : Office Integration SpreadSheetRead() Does Not Read Past First Page Problem Description:
Function spreadSheetRead() and tag CFSpreadsheet with "read" action attribute
Steps to Reproduce:
local.returnObject = spreadSheetRead(test.cfm, "2");
Actual Result
2608789 CF-3996225 Document Management : Office Integration Scotty I OpenOffice 4.1 Installation Not Found when Using CFDOCUMENT Problem Description:
I've installed a fresh copy of ColdFusion 11 and updated it to the latest version 11,0,05,293506. After verifying that the installation was working
Tracker Issue Bug 75904:ER For: Add "Configure local OpenOffice with ColdFusion" section to "Document" page of CF Admin
2601557 CF-3037832 Document Management : Office Integration Aaron Neff Bug 75904:ER For: Add "Configure local OpenOffice with ColdFusion" section to "Document" page of CF Admin Problem:
ER For: Add "Configure local OpenOffice with ColdFusion" section to "Document" page of CF Admin
Currently
2608089 CF-4194954 Document Management : Office Integration Paul Mascari CFSpreadsheet With QUERY Attribute Will Not Write to RAM Drive Duplicate ID: CF-3925916
Problem Description:
This problem is similar to bug 3178676. However, as noted in the comments on that bug it was never fixed when
Tracker Issue cfspreadsheet format="csv" columns="anyOneColumn" NullPointerException when Excel contain empty row at end.
2608125 CF-4185751 Document Management : Office Integration Yeou Sunn Liu cfspreadsheet format="csv" columns="anyOneColumn" NullPointerException when Excel contain empty row at end. Problem Description: NullPointerException is thrown by cfspreadsheet when trying to get a single column , and excel
Tracker Issue Spreadsheet Formula Bug
2608135 CF-4183980 Document Management : Office Integration Milind Joshi Spreadsheet Formula Bug Problem Description:
I am using ColdFusion 11 and trying to use FDIST function in a spreadsheet to get F-distribution value. The error I'm getting is that, it does not like the semicolon in the formula
2672881 CF-4159346 Document Management : Office Integration Aaron Neff [ANeff] ER for: spreadsheet.getColumnCount() sheet parameter optional Currently spreadsheetGetColumnCount()/spreadsheet.getColumnCount() require the sheet name/number parameter.
It should be optional. It should default
2608283 CF-4139060 Document Management : Office Integration Legorol San SpreadsheetAddRow applies strange time format to time values added to a spreadsheet Problem Description: When using SpreadsheetAddRow to add a value that looks like a time, the resulting cell has strange and inconsistent time
2608284 CF-4139054 Document Management : Office Integration Legorol San SpreadsheetAddRow corrupts a time value added to a spreadsheet Duplicate ID: CF-4139060
Problem Description: When using SpreadsheetAddRow to add a value that looks like a time, the value is corrupted.
Steps to Reproduce
2608582 CF-4058810 Document Management : Office Integration Neil Liggett Leading zeros removed from spreadsheet object cell values Problem Description: Data inserted into a spreadsheet object, cell values with leading zeros, the leading zeros are completely removed even though the cells
Tracker Issue [ANeff] Bug for: spreadsheetFormatRow()/spreadsheetFormatColumn() hidden=true doesn't hide
2608611 CF-4050095 Document Management : Office Integration Aaron Neff [ANeff] Bug for: spreadsheetFormatRow()/spreadsheetFormatColumn() hidden=true doesn't hide spreadsheetFormatRow()/spreadsheetFormatColumn() hidden=true doesn't hide
Repro:
mySpreadsheet = spreadsheetNew("mySheet", false
Tracker Issue Add support for protecting a sheet of .xlsx files
2608632 CF-4042548 Document Management : Office Integration Hiroki Taniura Add support for protecting a sheet of .xlsx files Currently SpreadsheetWrite does not support protecting a sheet of .xlsx files.
https://wikidocs.adobe.com/wiki/display/coldfusionen/SpreadsheetWrite
It could be added
Tracker Issue spreadsheetWrite autosize Only On Active Sheet
2608921 CF-3963656 Document Management : Office Integration Christopher Tierney spreadsheetWrite autosize Only On Active Sheet Problem Description:
When saving a spreadsheet only the active sheet auto-sizes each column. All other sheet columns are not auto-sized.
Steps to Reproduce:
var s
2609135 CF-3923995 Document Management : Office Integration ext-user spreadsheetAddRows: When passing arrays (without passing the row/col attribs) the order of the array elements is not correctly written in the spreadsheet. Related Bugs:
CF-3043160 - Similar to
Problem:
spreadsheetAddRows: When
Tracker Issue cfspreadsheet generated issues with "Format Cells..."
2609621 CF-3819363 Document Management : Office Integration Miguel Arvelo cfspreadsheet generated issues with "Format Cells..." Problem Description:Spreadsheets generated using the CF10 spreadsheet functions will not let the user to make changes in the format of the cell by using the "Format Cells
Tracker Issue SpreadsheetAddRows breaks on empty dates
2609622 CF-3819359 Document Management : Office Integration Miguel Arvelo SpreadsheetAddRows breaks on empty dates Problem Description:When creating a spreadsheet which contains date data fields that are empty for whatever reason the application breaks
Steps to Reproduce: Create a query with date
Tracker Issue cfspreadsheet issue on java 1.7
2610873 CF-3673214 Document Management : Office Integration Craig Capodilupo cfspreadsheet issue on java 1.7 Problem Description: Column widths on 2nd tab of spreadhseet all same narrow width
Steps to Reproduce: Create a spreadsheet with a 2nd tab on CF using jvm 1.7
Actual Result: The column
2596815 CF-3662240 Document Management : Office Integration Florian Koch SpreadsheetMergeCells Corrupts Spreadsheet Under Specific Conditions Problem Description:
Use of SpreadsheetMergeCells results in corrupt spreadsheet output under certain specific conditions: format is XLSX, sheet is second
Tracker Issue Enable "spreadsheet to query" for functions
2611060 CF-3647042 Document Management : Office Integration Raymond Camden Enable "spreadsheet to query" for functions As far as I can tell, there is no easy way (with functions) to create a query from a spreadsheet. If you use cfspreadsheet, you can quickly convert a file into a query. To do so
2596913 CF-3432184 Document Management : Office Integration Alex M SpreadSheetAddRows Can Not Handle Large Queries with Date-like columns Problem Description: When adding a substantially large (18000+) query object via SpreadSheetAddRows() the POI will crash with an error. The culprit seems
Tracker Issue Remove spreadSheetReadBinary
2612870 CF-3376670 Document Management : Office Integration Raymond Camden Remove spreadSheetReadBinary Ok, I know we don't normally remove functions, we deprecate them, but I'd like to vote for this function to be removed or deprecated. For some reason, we didn't modify toBinary() to do this. Well
Tracker Issue Spreadsheet operations seem to be limited to 256 columns
2612981 CF-3355173 Document Management : Office Integration Adam Cameron Spreadsheet operations seem to be limited to 256 columns Problem Description:
When using to read in a spreadsheet, only the first 256 columns are returned.
I suspect this is because of the issue detailed here: http
Tracker Issue SpreadsheetFormatRow() and SpreadSheetFormatCell() function are not working on CF9.0 server
2596978 CF-3226517 Document Management : Office Integration Bill Song SpreadsheetFormatRow() and SpreadSheetFormatCell() function are not working on CF9.0 server Problem Description:
alignment="vertical_top" does not bring any result when use SpreadsheetFormatRow() and Spread
2614707 CF-3086162 Document Management : Office Integration Peter Freitag Bug 87161:-(Watson Migration Closure)Can't use ram disk to read cfspreadsheet Problem:
Can't use ram disk to read cfspreadsheet
Method:
Copy a file into ram disk, then try to read it using cfspreadsheet tag.
Result:
Says
2598017 CF-3041840 Document Management : Office Integration David Lakein Bug 83724:(Watson Migration Closure)Spreadsheet functions: Can we get a function to tell if a cell is a value, formula, or comment?SpreadsheetSetCellFormula saves the value with a hint that it's supposed to be a formula; same
2598018 CF-3041839 Document Management : Office Integration David Lakein Bug 83723:(Watson Migration Closure) can read from an XLS file into a query, but how about a function that can do that? Would be very nice if there was a function that could read from an in-memory spreadsheet object to a
2598615 CF-3041132 Document Management : Office Integration Tom McNeer Bug 82405:cfspreadsheet write fails when used inside cffunction Duplicate ID: CF-3040949
Problem:
cfspreadsheet write fails when used inside cffunction
Method:
Given the following code
2599928 CF-3039570 Document Management : Office Integration Matthew Abbott Bug 79293:Writing out a query to a spreadsheet using cfspreadsheet will add the query columns to first row of the spreadsheet as headers Problem:
Writing out a query to a spreadsheet using cfspreadsheet will add the query
2600126 CF-3039362 Document Management : Office Integration Raymond Camden Bug 78928:(Watson Migration Closure)When writing out Excel data with cfspreadsheet, why must we do one sheet at a time? I would think the expected behavior of not passing sheet/sheetname would be that the entire object would
2600134 CF-3039354 Document Management : Office Integration Akbarsait N Bug 78913:The problem occurs when try to witre a long description value into Excel Problem:
The problem occurs when try to witre a long description value into Excel.
Method:
1. Create a .cfm file.2. Copy the below content
Tracker Issue Bug 78851:The cfspreadsheet tag is no longer reading a simple csv file from disk and instead is throwing the error
2600167 CF-3039317 Document Management : Office Integration Michael Dinowitz Bug 78851:The cfspreadsheet tag is no longer reading a simple csv file from disk and instead is throwing the error Problem:
The cfspreadsheet tag is no longer reading a simple csv file from disk and instead is throwing
Tracker Issue Bug 75273:There is no way to get metadata information about a spreadsheet, in order to know sheetnames, etc
2601930 CF-3037423 Document Management : Office Integration Reed Powell Bug 75273:There is no way to get metadata information about a spreadsheet, in order to know sheetnames, etc Problem:
There is no way to get metadata information about a spreadsheet, in order to know sheetnames, etc
Tracker Issue Bug 72678:Assuming "e" is an Excel object made with CF, you can't use cfcontent to serve it up
2603279 CF-3035806 Document Management : Office Integration Raymond Camden Bug 72678:Assuming "e" is an Excel object made with CF, you can't use cfcontent to serve it up Problem:
Assuming "e" is an Excel object made with CF, you can't use cfcontent to serve it up. You have to write it to the file
2603291 CF-3035793 Document Management : Office Integration Raymond Camden Bug 72665:If you create (and I assume read in) an Excel sheet, you can dump the variable and get some keys with nice info (rowcount, etc) Problem:
If you create (and I assume read in) an Excel sheet, you can dump
Tracker Issue Memory leak in spreadsheet functions
3542263 CF-4199829 Document Management : Office Integration Trevor Cotton Memory leak in spreadsheet functions Problem Description:
Generating a spreadsheet and not saving it to disk will cause the heap memory to not be freed up causing an eventual server hang
Steps to Reproduce:
Example code
5002574 CF-4203406 Document Management : Office Integration CFSPREADSHEET Fails to read .XLSX created by SQL Server Reporting Services 2016 Problem Description:
Created basic report in SQL Server Reporting Services 2016. Download results to Excel file (.xlsx). Try to use cfspreadsheet to upload
Tracker Issue SpreadsheetAddRows throws java.lang.ArrayStoreException when 2d array contains mixed value types
6295305 CF-4205366 Document Management : Office Integration SpreadsheetAddRows throws java.lang.ArrayStoreException when 2d array contains mixed value types Problem Description:
SpreadsheetAddRows fails when used with a 2D array containing a mix of strings and numbers
Steps to Reproduce
Tracker Issue cfspreadsheet with header=1 doesn't throw error if spreadsheet is empty but was created with spreadsheetNew
2608960 CF-3952934 Document Management : Office Integration colin macallister cfspreadsheet with header=1 doesn't throw error if spreadsheet is empty but was created with spreadsheetNew Problem Description:
If you read in a spreadsheet via cfspreadsheet with header=1, it should throw an error
Tracker Issue SpreadsheetAddFreezePane does not occur when a spreadsheet object is added to an existing file
2612180 CF-3549922 Document Management : Office Integration Robert Mann SpreadsheetAddFreezePane does not occur when a spreadsheet object is added to an existing file Problem Description:
SpreadsheetAddFreezePane does not occur when a spreadsheet object is added to an existing file using action
2596962 CF-3303703 Document Management : Office Integration James Moberg Spreadsheets created with CFSpreadsheet don't allow for End+Arrow Navigation Problem Description: Excel files generated by ColdFusion don't allow for moving the cell cursor to the next "blank" cells using the keyboard.
http
Tracker Issue Bug#4152515 reported fix, Still experiencing
2608098 CF-4191284 Document Management : Office Integration Peter Scarborough Bug#4152515 reported fix, Still experiencing Duplicate ID: CF-4152515
Problem Description:
According to bug report https://bugbase.adobe.com/index.cfm?event=bug&id=4152515# this was fixed issue in "CL 299842"
Is this a
2608199 CF-4165319 Document Management : Office Integration Gordon Frobenius cfspreadsheet on read alters cell data - auto trims the data Problem Description:
In CF10 using to read in an XLS file that has cells with leading and trailing spaces they were retained. In CF11 and 2016 they are being
2672882 CF-4159299 Document Management : Office Integration Aaron Neff [ANeff] Bug for: spreadsheet.formatCellRange() documented but not implemented spreadsheet.formatCellRange() documented but not implemented
Steps to reproduce:
1) Run this:
q = queryNew("foo,bar,foobar", "", [[1
Tracker Issue [ANeff] Bug for: cfspreadsheet throws ArrayIndexOutOfBoundsException if quoted CSV value does not contain comma
2608257 CF-4152515 Document Management : Office Integration Aaron Neff [ANeff] Bug for: cfspreadsheet throws ArrayIndexOutOfBoundsException if quoted CSV value does not contain comma cfspreadsheet throws ArrayIndexOutOfBoundsException if quoted CSV value does not contain comma
Repro:
my
Tracker Issue cfSpreadsheet is incorrectly extracting year from dates
2608372 CF-4108544 Document Management : Office Integration Mark Shute cfSpreadsheet is incorrectly extracting year from dates Problem Description: When I convert a spreadsheet into a query object using and then output the query values, all dates prior to Jan 1, 1930 show the year as 20xx
2608553 CF-4066259 Document Management : Office Integration Aaron Neff [ANeff] Bug for: spreadsheetSetCellValue() not adding necessary rows spreadsheetSetCellValue() adds necessary columns (good) but does not add necessary rows (bad).
Steps to reproduce:
1) Run this:
my
2608601 CF-4051606 Document Management : Office Integration Adam Cameron Error message missing when passing wrong data to spreadsheet.addRows() Repro:
spreadsheet = spreadsheetNew();
data = [
["tahi"],
["rua"],
["toru,wha"], // this is one data value
["rima,ono"] // so is this
];
file
Tracker Issue spreadsheet.addRows() doesn't work with commas in data
2608602 CF-4051598 Document Management : Office Integration Adam Cameron spreadsheet.addRows() doesn't work with commas in data Problem Description:
The addRows() method treat commas as column delimiters, not as data.
See repro case below
One can pass an array of data in to addRows(), but instead
Tracker Issue [ANeff] Bug for: spreadsheetFormatRow()/spreadsheetFormatColumn() locked=false doesn't unlock entire row/column
2608610 CF-4050099 Document Management : Office Integration Aaron Neff [ANeff] Bug for: spreadsheetFormatRow()/spreadsheetFormatColumn() locked=false doesn't unlock entire row/column spreadsheetFormatRow()/spreadsheetFormatColumn() locked=false doesn't unlock entire row/column
Repro:
my
2608817 CF-3987544 Document Management : Office Integration Greg Heh Excel spreadsheet generation and formating issue, value are not returned correctly Problem Description:
When generating an excel document that includes numeric value strings, including hyphens (-), formatting those values
2609186 CF-3914895 Document Management : Office Integration Raymond Camden Using spreadsheetAddRows w/o a row and column creates an error. Duplicate ID: CF-3043160
Try the following code from the docs:
SELECT CORNUMBER,DEPT_ID,COURSE_ID,CORNAME
FROM COURSELIST
///We
Tracker Issue spreadsheet functions: numeric boolean values in formatting attributes are not interpreted correctly.
2609495 CF-3842778 Document Management : Office Integration ext-user spreadsheet functions: numeric boolean values in formatting attributes are not interpreted correctly. Problem:
spreadsheet functions: numeric boolean values in formatting attributes are not interpreted correctly.
Method:
ssobj
Tracker Issue Using SpreadSheetRead to read a single worksheet, but saves all worksheets when writing.
2610511 CF-3698462 Document Management : Office Integration James Moberg Using SpreadSheetRead to read a single worksheet, but saves all worksheets when writing. Problem Description: Read a single worksheet from an Excel 97-2003 spreadsheet (XLS) that has multiple worksheets. Make modifications
Tracker Issue Data Corruption
2611021 CF-3650817 Document Management : Office Integration Christine Ng Data Corruption Problem Description:cfspreadsheet can't deal with "number+D" right. When cfspreadsheet writes out the xls file, for any alphanumeric ending with "D", the "D" is missing. I've heard others mention same thing
Tracker Issue cfspreadsheet drops empty columns from query even though headerrow column names are present in XLS file
2611813 CF-3588818 Document Management : Office Integration Paul Erickson cfspreadsheet drops empty columns from query even though headerrow column names are present in XLS file Problem Description:
I provide an excel template to my customer to facilitate a standard format for uploading data to our
Tracker Issue Bug 86522:The function SpreadSheetAddRow() uses commas to delimit the values for each column in the row being added
2597575 CF-3043477 Document Management : Office Integration Julian Halliwell Bug 86522:The function SpreadSheetAddRow() uses commas to delimit the values for each column in the row being added Duplicate ID: CF-3037369
Problem:
The function SpreadSheetAddRow() uses commas to delimit the values
2615421 CF-3043393 Document Management : Office Integration jj blodgett Bug 86400:When a spreadsheet is read using cfspreadsheet, it will error when the first characters of a field is a pound sign (#) and then field has formatting of at least "Custom" or "Date" Problem:
When a spreadsheet is read
2597623 CF-3043160 Document Management : Office Integration Fabrice Reynolds Bug 85963:(Watson Migration Closure)There's a bug in spreadsheetAddRows() in that with an array, one must specify the row/column values Related Bugs:
CF-3923995 - Similar to
Problem:
There's a bug in spreadsheet
2599358 CF-3040294 Document Management : Office Integration Adam Cameron Bug 80346:Summary: spreadsheetDeleteSheet() not implementedIt seems to be strange to have a spreadsheetCreateSheet() function, but no spreadsheetDeleteSheet() function Problem:
Summary: spreadsheet
2599927 CF-3039571 Document Management : Office Integration Rob Kolosky Bug 79294:I’m attempting to make a spreadsheet with 2 merged areas, and the spreadsheetMergeCells() appears to be giving me problems Problem:
I’m attempting to make a spreadsheet with 2 merged areas, and the spreadsheet
Tracker Issue Bug 79245:(Watson Migration Closure)Most developers are comfortable using HTML/CSS to create tables
2599963 CF-3039533 Document Management : Office Integration Nathan Mische Bug 79245:(Watson Migration Closure)Most developers are comfortable using HTML/CSS to create tables Problem:
Most developers are comfortable using HTML/CSS to create tables. Given that, I think it would be useful
2600209 CF-3039273 Document Management : Office Integration Eric Reeves Bug 78774:While trying to test out the ability to create PowerPoint (ppt) presentations, it became quickly apparent that any images with text (charts with legends and labels) are no longer legible in the presen Problem:
While
2603262 CF-3035823 Document Management : Office Integration Daniel Kim Bug 72695:add an additional argument in the excelAddRow function (or replace the list argument, or provide a function named excelAddRange) to pass in an array of values Problem:
add an additional argument in the excel
Tracker Issue POI XSSF cell comment error
4907783 CF-4203361 Document Management : Office Integration POI XSSF cell comment error Problem Description:
The function
spreadsheetSetCellComment(doc,commentStruct,rowNumber,colNumber)
causes an error when doc is of type XLSX. However, it works as expected when doc is of type XLS. The error
Tracker Issue Cfspreadsheet formatting is broken
2986043 CF-4198484 Document Management : Office Integration tair paz Cfspreadsheet formatting is broken Problem Description: Cfspreadsheet formatting functions do not work correctly in cf16 version. For example when you apply the styles to the rows and columns within the same rows the styles