displaying top 100 results
Tracker Issue Memory leak in spreadsheet functions
Memory leak in spreadsheet functions
Tracker Comment Comment on Memory leak in spreadsheet functions by Vladimir P.
Comment on Memory leak in spreadsheet functions by Vladimir P.
Tracker Comment Comment on Memory leak in spreadsheet functions by Piyush K.
Comment on Memory leak in spreadsheet functions by Piyush K.
Tracker Comment Comment on Memory leak in spreadsheet functions by Trevor C.
Comment on Memory leak in spreadsheet functions by Trevor C.
Tracker Comment Comment on Memory leak in spreadsheet functions by Piyush K.
Comment on Memory leak in spreadsheet functions by Piyush K.
Portal Topic CF 2018 Spreadsheet Functions
CF 2018 Spreadsheet Functions
[ANeff] Bug for: getFunctionList() should return Spreadsheet* instead of SpreadSheet*
spreadsheetRead/write functionality damages spreadsheet formatting
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Tracker Comment Comment on spreadsheet functions: numeric boolean values in formatting attributes are not interpreted correctly. by CFwatson U.
Comment on spreadsheet functions: numeric boolean values in formatting attributes are not interpreted correctly. by CFwatson U.
Portal Comment Comment on CF 2018 Spreadsheet Functions by James Mohler
Comment on CF 2018 Spreadsheet Functions by James Mohler
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Tracker Comment Comment on spreadsheetRead/write functionality damages spreadsheet formatting by David R.
Comment on spreadsheetRead/write functionality damages spreadsheet formatting by David R.
Tracker Comment Comment on spreadsheet functions: numeric boolean values in formatting attributes are not interpreted correctly. by External U.
Comment on spreadsheet functions: numeric boolean values in formatting attributes are not interpreted correctly. by External U.
Comment on Bug 87056:(Watson Migration Closure)Summary: spreadsheetSetCellValue() and other cell-value setting functions should be data-type awareThe datatype of the data being put in the spreadsheet should be respected by External U.
CFFiddle for Spreadsheet, List, Struct, and Date/Time functions
Comment on Enable "spreadsheet to query" for functions by External U.
Comment on Enable "spreadsheet to query" for functions by External U.
2608552 CF-4066274 Piyush K. Aaron,
Both, the member function and the spreadsheet functions have been implemented:
xlObj.getColumnCount
SpreadsheetGetColumnCount
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Tracker Comment Comment on Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets by External U.
Comment on Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets by External U.
Tracker Issue spreadsheet functions: numeric boolean values in formatting attributes are not interpreted correctly.
spreadsheet functions: numeric boolean values in formatting attributes are not interpreted correctly.
Comment on Enable "spreadsheet to query" for functions by Vamseekrishna N.
Tracker Comment Comment on spreadsheetRead/write functionality damages spreadsheet formatting by David R.
Comment on spreadsheetRead/write functionality damages spreadsheet formatting by David R.
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
/columns/rows is set to be formatted as text. Tried formatting the data with functions: SpreadsheetFormatColumn(s), SpreadsheetFormatRow(s) before and after setting the values, but the leading zeros are still removed
Steps to Reproduce:
Below is a simple reproduction of the issue:
Actual Result:
After
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 with Sprea
Tracker Issue There should be a spreadsheetGetFormatting() function
There should be a spreadsheetGetFormatting() function
Tracker Comment Comment on SpreadsheetAddRow applies strange time format to time values added to a spreadsheet by Piyush K.
2608283 CF-4139060 Piyush K. Legorol,
To prevent the spreadsheet function from trying to interpret the format of the passed data you can use the following approaches:
Use "STRING" datatype so that the data is treated by spreadsheet as plain text. This parameter was introduced with CF11.
for usage
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Portal Comment Comment on CF 2018 Spreadsheet Functions by Paul Mascari
Comment on CF 2018 Spreadsheet Functions by Paul Mascari
Comment on There should be a spreadsheetGetFormatting() function by External U.
Comment on Enable "spreadsheet to query" for functions by External U.
Comment on Enable "spreadsheet to query" for functions by External U.
Bug 87056:(Watson Migration Closure)Summary: spreadsheetSetCellValue() and other cell-value setting functions should be data-type awareThe datatype of the data being put in the spreadsheet should be respected
2672879 CF-4159380 Documentation Aaron Neff [ANeff] Doc Bug for: some spreadsheetGetColumnCount() doc bugs some spreadsheetGetColumnCount() doc bugs
1) SpreadsheetGetColumnCount() isn't listed in the member functions doc: https://helpx.adobe.com/coldfusion/developing-applications/building-blocks-of-coldfusion-applications/using-the-member-functions
2608552 CF-4066274 External U. Hi Mayur,
Thank you for your follow-up and insight. I see that would impact performance and would like to change my request. Instead of spreadsheet.columnCount, how about a spreadsheetGetColumnCount() function and spreadsheet.getColumnCount() member function
Tracker Comment Comment on SpreadsheetFormatRow() throws ColdFusion error after JVM 1.7 is updated. by External U.
2608832 CF-3981800 External U. This problem also exists on ColdFusion 9 and possibly ColdFusion 11. Please test this function and related spreadsheet functions to certify whether they function properly with Java 1.7uXX.
Tracker Comment Comment on [ANeff] Bug for: getFunctionList() should return Spreadsheet* instead of SpreadSheet* by Aaron N.
Comment on [ANeff] Bug for: getFunctionList() should return Spreadsheet* instead of SpreadSheet* by Aaron N.
Comment on 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 with Sprea by External U.
Portal Comment Comment on CFFiddle for Spreadsheet, List, Struct, and Date/Time functions by Saurav Ghosh
Comment on CFFiddle for Spreadsheet, List, Struct, and Date/Time functions by Saurav Ghosh
Tracker Issue Enable "spreadsheet to query" for functions
Enable "spreadsheet to query" for functions
Bug 80346:Summary: spreadsheetDeleteSheet() not implementedIt seems to be strange to have a spreadsheetCreateSheet() function, but no spreadsheetDeleteSheet() function
Portal Comment Comment on CFFiddle- Code, test, and share your ColdFusion code on the go! by Saurav Ghosh
or image functions, to create a spreadsheet, you would need to stay logged in as the spreadsheet/file will get saved in a folder in your project.
For example, in the project, spreadsheet functions, there are 40
Tracker Issue [ANeff] Doc Bug for: SpreadsheetAddRows doc has chl-author-preview.corp.adobe.com links
2672878 CF-4159392 Documentation : General Aaron Neff [ANeff] Doc Bug for: SpreadsheetAddRows doc has chl-author-preview.corp.adobe.com links SpreadsheetAddRows doc has chl-author-preview.corp.adobe.com links
Steps to Reproduce:
1) go to https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions
Bug 78937:Spreadsheet function documentation is still excel-centric in places
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
2612795 CF-3429634 Frank J. Fixed this page:
https://wikidocs.adobe.com/wiki/display/coldfusionen/Spreadsheet+functions
The following page is auto-generated by the Wiki:
https://wikidocs.adobe.com/wiki/display/coldfusionen/Functions+by+category
Comment on Bug 87056:(Watson Migration Closure)Summary: spreadsheetSetCellValue() and other cell-value setting functions should be data-type awareThe datatype of the data being put in the spreadsheet should be respected by External U.
Comment on Bug 87056:(Watson Migration Closure)Summary: spreadsheetSetCellValue() and other cell-value setting functions should be data-type awareThe datatype of the data being put in the spreadsheet should be respected by Piyush K.
Comment on Bug 87056:(Watson Migration Closure)Summary: spreadsheetSetCellValue() and other cell-value setting functions should be data-type awareThe datatype of the data being put in the spreadsheet should be respected by External U.
Portal Topic CFFiddle for Array, String, and Math functions
In the next couple of weeks, we plan to include CFFidlle links for Spreadsheet, Struct, and List functions. In the next three to four months, we plan to link every tag and function, wherever possible, with CFFiddle links. As always, please use CFFiddle to test the samples. If there […]
The post CFFiddle
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Tracker Comment Comment on Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets by External U.
Comment on Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets by External U.
Tracker Comment Comment on Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets by External U.
Comment on Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets by External U.
.
So, what I wanted to do was before converting it to a query object, was take the spreadsheet, loop through the column with all my links, and run a function like
SpreadsheetGetCellHyperlink(spreadsheet,row,column)
similar to
SpreadsheetGetCellFormula(spreadsheet,row,column).
and it would return
Tracker Comment Comment on Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets by External U.
Comment on Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets by External U.
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Bug 78927:(Watson Migration Closure)Summary: spreadsheetReadBinary() function poorly namedSee discussion / confusion here: https://prerelease
Comment on Excel functionality - SpreadsheetFormatCell missing method by Nimit S.
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Tracker Comment Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Excel functionality - SpreadsheetFormatCell missing method by External U.
Comment on Bug 78927:(Watson Migration Closure)Summary: spreadsheetReadBinary() function poorly namedSee discussion / confusion here: https://prerelease by External U.
Tracker Issue [ER]: Decision Member functions Support
[ER]: Decision Member functions Support
Excel functionality - SpreadsheetFormatCell missing method
Tracker Issue [ANeff] Doc Bug for: Function List page issues
functions (that table's positional ordering goes against-the-grain)
- International functions (LSIsCurrency, LSParseDateTime, and LSIsNumeric are out of order)
- Microsoft office integration functions (SpreadsheetGetCellValue should be moved to top of 3rd column. Additionally there are functions in the 3rd
Tracker Comment Comment on Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets by External U.
Comment on Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets by External U.
Tracker Comment Comment on Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets by Rupesh K.
Comment on Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets by Rupesh K.
Tracker Comment Comment on Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets by External U.
Comment on Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets by External U.
Tracker Comment Comment on Member functions for encoding by External U.
2608653 CF-4033628 External U. FWIW, I did an assessment of how to handle all *Lucee's* headless functions some time ago. Most of it would apply to ColdFusion too:
https://docs.google.com/spreadsheets/d/1mqiaJRVgh26ljEKgvhb6yf7l6uCKmAmZlIcQqlzh1KM/edit?usp=sharing
Tracker Issue SpreadsheetFormatRow() and SpreadSheetFormatCell() function are not working on CF9.0 server
SpreadsheetFormatRow() and SpreadSheetFormatCell() function are not working on CF9.0 server
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 Comment Comment on <CFSPREADSHEET> generates a file with data corrupted. SPREADSHEETNEW() does not. by Piyush K.
as string, you can make use of relevant spreadsheet methods. The spreadsheet functions are data-aware CF11 onwards, enabling the user to control how the functions interpret the datatype of the passed data. Even if you don't pass the datatype parameter the spreadsheetAddRow(s) method will default to string
Tracker Comment Comment on Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets by External U.
Comment on Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets by External U.
Tracker Comment Comment on [ANeff] ER for: CF self-documentation as part of any possible language overhaul by External U.
2608385 CF-4104564 External U. I tried using spreadsheetNew().getClass().getMethods() to find all of a spreadsheet object's member functions. I called .getName() on each result, but not all of the member functions are listed.
I hope this ER is considered for Aether. Adam's idea for a CFML object w
Tracker Issue [ANeff] ER for: spreadsheetObject.columnCount
=false}, 2, 1, 2, getSpreadsheetColumnCount(mySpreadsheet, "mySheet"));//format only the defined cells
spreadsheetWrite(mySpreadsheet, expandPath("./myspreadsheet.xls"), "", true);
cfspreadsheet(action="read", src=expandPath("./myspreadsheet.xls"), query="q");
writeDump(q);
numeric function getSpreadsheet
Tracker Comment Comment on SpreadsheetFormatRow() and SpreadSheetFormatCell() function are not working on CF9.0 server by External U.
Comment on SpreadsheetFormatRow() and SpreadSheetFormatCell() function are not working on CF9.0 server by External U.
Portal Topic Spreadsheet Data Formatting Not Working
Snazzo Spreadsheet Data Formatting Not Working No matter what I do, I can't seem to get a data format to be applied to a cell.
The post Spreadsheet Data Formatting Not Working appeared first on ColdFusion. CFML Tag/Function,cfspreadsheet,Question,cfml tag/function,ColdFusion,question
Tracker Issue Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets
Using SpreadSheetFormatCellRange and other SpreadSheetFormat functions may create corrupted Excel spreadsheets
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
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
4122190 CF-4201703 Documentation Aaron Neff [ANeff] Doc Bug for: spreadsheetAddImage() missing syntax Issue: spreadsheetAddImage()'s syntax is missing
Related URL: https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-s/spreadsheetaddimage.html
Tracker Issue [ANeff] Bug for: spreadsheetAddColumn() and spreadsheetAddRow() missing delimiter parameter
]][, datatype])
Why?
Answer 1) SpreadsheetAddColumn() must have a delimiter parameter b/c it currently cannot set "a,b" into a single cell.
Answer 2) SpreadsheetAddRow() should then have a delimiter parameter to maintain consistency w/ SpreadsheetAddColumn().
Answer 3) All existing functions that take a list
Comment on There should be a spreadsheetGetFormatting() function by External U.
Tracker Comment Comment on SpreadSheetSetColumnWidth stops working after updating to ColdFusion 10 Update 11 by Piyush K.
2611496 CF-3616845 Piyush K. fix verified with the cfmain build 288874. Win 7x64.
closing this.
test case checked in at:
\depot\ColdFusion\qa\cf\regression\newmanual\coldfusion\functions\spreadsheet\SpreadSheetSetColumnWidth.cfm
AddRows(theSheet,courses);
SpreadsheetAddRows(theSheet,["1,a", "2,B,b"]);
It throws an error: Invalid row number (-1) outside allowable range (0..65535)
This is a rather crucial thing we need to fix as this one of the few places where we can pass an array to the spreadsheet functions. All the others want a query or a list
.excel.Excel.findFont
Expected Result:
no exception thrown, function formats the desired cell range appropriately
Any Workarounds:
pass the boolean literal as an appropriate string literal, as in: "true" or "false"
2612981 CF-3355173 External U. I found, in the documentation, the ShreadsheetNew function has the xmlformat option. SpreadsheetNew([sheetName, xmlformat]) When set to true, the file will be saved as .xlsx and not .xls. The .xlsx format allows for many more columns than 256. Thanks.
Tracker Comment Comment on cfspreadsheet on read alters cell data - auto trims the data by External U.
2608199 CF-4165319 External U. In case the working example link doesn't work (http://trycf.com/gist/cb811394b56fec0e5c3321f52c896852/acf2016?theme=monokai), here is the code to reproduce the problem...
SpreadSheet Functions:
original length [#len(cfValue)#]
trimmed length [#len
Tracker Comment Comment on Member functions for encoding by External U.
Comment on Member functions for encoding by External U.
5652628 CF-4204270 Piyush K. Chad,
First of all, let me apologize for the delay in getting back to you on this.
Now, most of the functionality that you've requested already is in existence. For example. spreadsheetInfo function returns information such as no. of sheets and their names.
You can
4129894 CF-4201715 Documentation Aaron Neff [ANeff] Doc Bug for: spreadsheetFormatRows() syntax and parameters mismatch Issue: spreadsheetFormatRows()'s syntax and parameter sections don't match ('row' should be 'rows' in Parameters section)
Related URL: https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-s/spreadsheetformatrows.html
Comment on 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 by External U.