为什么Microsoft Excel中仍然有行限制？ [英] Why is there still a row limit in Microsoft Excel?
问题描述
直到Office 2007，Excel最多有65,000行。当然，2007年Office最大限度地突破了100万行，当然更好。但我很好奇 - 为什么会有极限？显然，随着电子表格大小的增加，表现会逐渐减慢;但是，通过从小工作表开始，并且仅在需要时动态地重新调整大小，Excel应该不会很难优化。
为了将限制从65K增加到100万，为什么它们不会一路走来，只受到可用内存和磁盘空间的限制？
Until Office 2007, Excel has a maximum of 65,000 rows. Office 2007 bumped that up to a max of 1 million rows, which is nicer of course; but I'm curious -- why is there a limit at all? Obviously, performance will slow down exponetially as you increase the spreadsheet size; but it shouldn't be very hard to have Excel optimize for that by starting with a small sheet and dynamically "re-sizing" it only as needed. Given how much work it must have been to increase the limit from 65K to 1 million, why didn't they go all the way so it's limited only by the amount of available memory and disk space?
推荐答案
（由于错误而更新...对所有人的建议：不要在SO之前发布完全清醒）
可能是因为优化。 Excel 2007最多可以包含16 384列和1 048 576行。奇怪的数字？
Probably because of optimizations. Excel 2007 can have a maximum of 16 384 columns and 1 048 576 rows. Strange numbers?
14位= 16 384，20位= 1 048 576
14 bits = 16 384, 20 bits = 1 048 576
14 + 20 = 34 bit =多个寄存器可以保存。
14 + 20 = 34 bits = more than one register can hold.
但是，它们还需要存储单元格的格式（文本，数字等）和格式（颜色，边框等）。假设他们使用两个32位字（64位），它们使用34位作为单元格号码，而对于其他东西则使用32位。
But they also need to store the format of the cell (text, number etc) and formating (colors, borders etc). Assuming they use two 32-bit words (64 bit) they use 34 bits for the cell number and have 30 bits for other things.
为什么这么重要？在内存中，他们不需要分配整个电子表格所需的所有内存，而只需要为数据所需的内存分配所有内存，并且每个数据都被标记在该单元格中。
Why is that important? In memory they don't need to allocate all the memory needed for the whole spreadsheet but only the memory necessary for your data, and every data is tagged with in what cell it is supposed to be in.
更新2016：
找到一个指向 Microsoft的Excel 2013& 2016年
- 打开工作簿：受可用内存和系统资源的限制
- 工作表大小：1,048,576行16,384列
- 列宽：255个字符
- 行高：409点
- 休息：1,026水平和垂直
- 单元格可以包含的字符总数：32,767个字符
- 页眉或页脚中的字符：255
- 工作簿中的表格：受可用内存限制（默认为1张）
- 工作簿中的颜色：1600万种颜色（32位，可完全访问24位色谱）
- 工作簿中的命名视图：受可用内存限制
- 独特的单元格格式/单元格样式：64,000
- 填充样式：256
- 行重量和样式：256
- 独特的字体类型：1,024个全球字体可供使用;每个工作簿512个
- 工作簿中的数字格式：200到250之间，具体取决于您已安装的Excel的语言版本
- 工作簿：受可用内存限制
- 工作簿中的Windows：受可用内存限制
- 工作表中的超链接：66,530个超链接
- 窗口中的窗格：4
- 链接表：受可用内存限制
- 方案：受可用内存限制;摘要报告仅显示前251个场景
- 更改场景中的单元格：32
- Solver中的可调整单元格：200
- 自定义功能：受可用内存限制
- 缩放范围：10％至400％
- 报告：受可用内存限制
-
- 排序参考：64个单一排序;
- 撤消级别：100
- 数据表单中的字段：32
- 工作簿参数：每个工作簿的255个参数
- 过滤器下拉列表中显示的项目：10,000
- Open workbooks: Limited by available memory and system resources
- Worksheet size: 1,048,576 rows by 16,384 columns
- Column width: 255 characters
- Row height: 409 points
- Page breaks: 1,026 horizontal and vertical
- Total number of characters that a cell can contain: 32,767 characters
- Characters in a header or footer: 255
- Sheets in a workbook: Limited by available memory (default is 1 sheet)
- Colors in a workbook: 16 million colors (32 bit with full access to 24 bit color spectrum)
- Named views in a workbook: Limited by available memory
- Unique cell formats/cell styles: 64,000
- Fill styles: 256
- Line weight and styles: 256
- Unique font types: 1,024 global fonts available for use; 512 per workbook
- Number formats in a workbook: Between 200 and 250, depending on the language version of Excel that you have installed
- Names in a workbook: Limited by available memory
- Windows in a workbook: Limited by available memory
- Hyperlinks in a worksheet: 66,530 hyperlinks
- Panes in a window: 4
- Linked sheets: Limited by available memory
- Scenarios: 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: 64 in a single sort; unlimited when using sequential sorts
- Undo levels: 100
- Fields in a data form: 32
- Workbook parameters: 255 parameters per workbook
- Items displayed in filter drop-down lists: 10,000
这篇关于为什么Microsoft Excel中仍然有行限制？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
