엑셀 셀에 텍스트 제한이 있었네,,,,,
CSV 변환 작업중 자꾸 이상하게 잘리더라니...
Excel specifications and limits
In Excel 2010, increased limits on rows, columns, charts, and other features expand the capacity and power of your spreadsheet.
Read an article or try Office 2010!
The following sections describe the maximum limits by feature in Microsoft Excel 2003.
Worksheet and workbook specifications
Feature Maximum limit Open workbooks Limited by available memory and system resources Worksheet size 65,536 rows by 256 columns Column width 255 characters Row height 409 points Page breaks 1000 horizontal and vertical Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. Sheets in a workbook Limited by available memory (default is 3 sheets) Colors in a workbook 56 Cell styles in a workbook 4,000 Named views (view: A set of display and print settings that you can name and apply to a workbook. You can create more than one view of the same workbook without saving separate copies of the workbook.) in a workbook Limited by available memory Custom number formats Between 200 and 250, depending on the language version of Excel you have installed. Names in a workbook Limited by available memory Windows in a workbook Limited by system resources Panes in a window 4 Linked sheets Limited by available memory Scenarios (scenario: A named set of input values that you can substitute in a worksheet model.) Limited by available memory; a summary report shows only the first 251 scenarios Changing cells in a scenario 32 Adjustable cells in Solver 200 Custom functions Limited by available memory Zoom range 10 percent to 400 percent Reports Limited by available memory Sort references 3 in a single sort; unlimited when using sequential sorts Undo levels 16 Fields in a data form 32 Custom toolbars in a workbook Limited by available memory Custom toolbar buttons Limited by available memory
Feature Maximum limit Number precision 15 digits Largest number allowed to be typed into a cell 9.99999999999999E+307 Largest allowed positive number 1.79769313486231E+308 Smallest allowed negative number -2.2251E-308 Smallest allowed positive number 2.229E-308 Largest allowed negative number -1E-307 Length of formula contents 1,024 characters Iterations 32,767 Worksheet arrays Limited by available memory. Also, arrays cannot refer to entire columns. For example, an array cannot refer to the entire column C:C or to the range C1:C65536. However, an array can refer to the range C1:D65535 because the range is one row short of the maximum worksheet size and does not include the entire C or D column. Selected ranges 2,048 Arguments in a function 30 Nested levels of functions 7 Number of available worksheet functions 329 Earliest date allowed for calculation January 1, 1900 (January 1, 1904, if 1904 date system is used) Latest date allowed for calculation December 31, 9999 Largest amount of time that can be entered 9999:59:59
PivotTable report specifications
'웹&컴퓨팅' 카테고리의 다른 글
Microsoft Office 2010 에서 인증 관련 0xC004F074 오류 메세지 창이 떠서 (15) 2013.09.11 안드로이드 젤리빈 4.3 업데이트 후 MX Player 가 안되는경우! (0) 2013.07.31 엑셀 셀에 텍스트 제한 (Excel specifications and limits) (0) 2013.01.04 한글모음 영어표기법 (0) 2012.12.26 호환성보기 없애기 - 브라우져의 최신 렌더링 엔진으로 보기 (0) 2012.09.25 DTD종류 (1) 2012.09.25