楼主 lrlxxqxa |
在Excel中设置列宽或者行高小于一定值时,Excel会认为其隐藏;比如将C列列宽设置为0.01,Excel认为C列已经隐藏了,可以通过取消隐藏操作来 恢复视图。 测试过程: 列宽:
0.03时认为隐藏,0.04时不隐藏; 0.038时认为隐藏,0.039时不隐藏; 0.0384时认为隐藏,0.0385时认为不隐藏; 0.03846时认为隐藏,0.03847时认为不隐藏; 0.038461时认为隐藏,0.038462时认为不隐藏; 0.0384615时认为隐藏,0.0384616时认为不隐藏; 0.03846153时认为隐藏,0.03846154时认为不隐藏; 0.038461538时认为隐藏,0.038461539时认为不隐藏; 0.0384615384时认为隐藏,0.0384615385时认为不隐藏; 0.03846153846时认为隐藏,0.03846153847认为不隐藏; 0.038461538461时认为隐藏,0.038461538462认为不隐藏; 0.0384615384615时认为隐藏,0.0384615384616认为不隐藏; 0.03846153846153时认为隐藏,0.03846153846154认为不隐藏; 0.038461538461538时认为隐藏,0.038461538461539时认为不隐藏; 0.0384615384615384时认为隐藏,0.0384615384615385时认为不隐藏; (这时候已经显示成“3.84615384615385E-02”这种形式了)没有往下继续测试; 从目前来看,是按照:3,8,4,6,1,5,的末位数字来循环的。 行高:
0.6时认为隐藏,0.7时不隐藏; 0.67时认为隐藏,0.68时不隐藏; 0.674时认为隐藏,0.675时认为不隐藏; 0.674999999999999时认为隐藏;1012181218237f9c89b36ab64a.gif |
2楼 远古石器 |