在与Microsoft Excel合作的同时,我制定了具有许多象征意义的大公式,其总长度在2007年Excel约为8047。 在我研究时,我发现,公式允许的特性最高为8129。

我摘录了Excel文档,我可以看到,微软Excel在表格名称之前使用单一报价(),而且改动:对于一些表格名称,只有单一报价,而对于其他名称,则没有报价。

谁能解释为什么?

我在“Excel电子表格”中给出的公式如下。

SUM(╟!$C$34+╟!$G$26:$K$29+╚!$B$40+╚!$G$33:$K$38+╔!$D$38+╔!$F$35:$I$37+╩!$C$39+╩!$D$36:$F$40+╦!$E$36+╦!$D$37:$F$39+╠!$E$38+╠!$K$24:$M$35+═!$E$40+═!$H$35:$J$39+╬!$I$33+╬!$L$23:$N$33+╧!$F$40+╧!$K$25:$L$35+╨!$G$39+╨!$L$23:$M$34+╤!$G$40+╤!$K$27:$M$38+╥!$G$39+╥!$J$31:$L$37+╙!$H$39+╙!$J$28:$L$39+╘!$H$39+╘!$J$28:$M$34+╒!$I$38+╒!$K$27:$M$38+╓!$H$40+╓!$J$24:$M$34+╫!$H$36+╫!$J$25:$L$38+╪!$I$35+╪!$K$24:$L$34+┘!$I$38+┘!$L$23:$M$34+┌!$I$37+┌!$K$24:$M$34+█!$I$39+█!$K$23:$M$35+▄!$J$38+▄!$K$27:$M$35+▌!$J$38+▌!$L$24:$N$34+ ▐ !$J$41+ ▐ !$J$30:$L$37+ ▀ !$J$37+ ▀ !$K$27:$M$38+ї!$G$39+ї!$K$28:$M$34+Ў!$G$41+Ў!$I$33:$J$39+°!$H$39+°!$K$27:$L$35+ ∙ !$J$37+ ∙ !$J$32:$K$37+·!$H$40+·!$I$29:$K$35+√!$I$39+√!$J$31:$K$38+¤!$I$38+¤!$I$31:$J$36+■!$I$39+■!$J$29:$K$36+   !$J$34+   !$J$26:$K$35,Cells!$A$1+Cells!$J$12:$L$15+ Merged Cells !$A$1:$G$9+ Merged Cells !$K$24+Styles!$A$1+Styles!$M$10:$M$21+ Row Column !$A$1+ Row Column !$L$7:$N$25+ @ !$A$2+ @ !$L$19:$M$31+ ! !$C$2+ ! !$M$10:$M$26+ ~ !$H$37+ ~ !$M$16:$P$30+ # !$G$37+ # !$L$17:$N$33+ $ !$F$35+ $ !$L$17:$M$30+ % !$G$35+ % !$L$16:$N$31+ ^ !$G$37+ ^ !$K$19:$N$32+ & !$H$38+ & !$L$17:$N$33+ () !$H$37+ () !$L$20:$N$36+ - !$H$38+ - !$L$18:$O$34+_!$G$37+_!$L$25:$N$34+ = !$H$36+ = !$K$29:$N$36+ + !$I$34+ + !$K$27:$M$35+ | !$H$35+ | !$I$32:$L$36+ {} !$H$36+ {} !$I$35:$L$38+ ` !$H$37+ ` !$J$33:$M$39+№!$I$36+№!$J$35:$M$39+ ; !$G$38+ ; !$H$37:$I$39+ё!$G$41+ё!$G$40:$L$44+ " !$C$30+ " !$C$30:$D$35+ , !$G$39+ , !$G$38:$J$39+ . !$G$37+ . !$H$35:$H$38+ <> !$I$35+ <> !$I$35:$K$36+ 1 !$H$37+ 1 !$H$36:$J$39+▲!$I$37+▲!$K$30:$L$39+ ☺ !$H$36+ ☺ !$I$34:$K$37+ ☻ !$J$38+ ☻ !$L$28:$M$34+♥!$I$37+♥!$K$27:$M$36+ ♦ !$I$36+ ♦ !$K$30:$M$35+♣!$I$37+♣!$K$34:$L$39+♠!$J$31+♠!$L$31:$N$39+ • !$H$34+ • !$I$30:$L$37+ ◘ !$K$32+ ◘ !$M$19:$O$29+○!$J$35+○!$K$29:$M$35+ ◙ !$I$36+ ◙ !$L$27:$N$34+♂!$K$32+♂!$M$26:$N$34+♪!$I$35+♪!$M$25:$O$35+♀!$K$34+♀!$L$28:$N$36+ ♫ !$I$34+ ♫ !$L$30:$M$36+ ☼ !$J$37+ ☼ !$K$29:$L$36+ ► !$J$39+ ► !$K$33:$M$38+ ◄ !$J$38+ ◄ !$L$27:$N$35+↕!$L$32+↕!$L$30:$N$36+ ‼ !$J$38+ ‼ !$K$31:$M$38+¶!$J$33+¶!$L$25:$N$33+§!$K$33+§!$L$25:$N$33+ ▬ !$J$39+ ▬ !$K$33:$M$38+ ↨ !$J$34+ ↨ !$L$29:$N$38+↑!$K$35+↑!$M$28:$N$36+↓!$K$37+↓!$L$25:$N$32+→!$L$32+→!$M$16:$P$28+←!$J$39+←!$K$30:$N$38+∟!$J$36+∟!$L$30:$M$36+∟!$J$39+∟!$L$29:$N$37+↔!$I$35+↔!$L$25:$N$30+▼!$J$31+▼!$L$27:$M$34+   !$K$34+   !$M$23:$O$33+ 0 !$L$33+ 0 !$L$31:$O$35+ ░ !$J$36+ ░ !$M$29:$N$38+▒!$J$39+▒!$K$30:$N$35+▓!$J$35+▓!$K$28:$N$35+│!$K$35+│!$M$29:$O$37+┤!$J$38+┤!$L$31:$N$37+╡!$J$38+╡!$L$31:$M$37+╢!$J$40+╢!$K$34:$M$37+╖!$J$38+╖!$K$33:$L$36+╕!$J$38+╕!$L$32:$M$38+╣!$J$38+╣!$K$24:$N$33+║!$J$38+║!$M$25:$O$36+╗!$J$39+╗!$L$27:$N$37+╝!$J$39+╝!$L$27:$N$38+╜!$J$38+╜!$M$30:$N$38+╛!$J$39+╛!$L$26:$O$37,╟!$C$34+╟!$G$26:$K$29+╚!$B$40+╚!$G$33:$K$38+╔!$D$38+╔!$F$35:$I$37+╩!$C$39+╩!$D$36:$F$40+╦!$E$36+╦!$D$37:$F$39+╠!$E$38+╠!$K$24:$M$35+═!$E$40+═!$H$35:$J$39+╬!$I$33+╬!$L$23:$N$33+╧!$F$40+╧!$K$25:$L$35+╨!$G$39+╨!$L$23:$M$34+╤!$G$40+╤!$K$27:$M$38+╥!$G$39+╥!$J$31:$L$37+╙!$H$39+╙!$J$28:$L$39+╘!$H$39+╘!$J$28:$M$34+╒!$I$38+╒!$K$27:$M$38+╓!$H$40+╓!$J$24:$M$34+╫!$H$36+╫!$J$25:$L$38+╪!$I$35+╪!$K$24:$L$34+┘!$I$38+┘!$L$23:$M$34+┌!$I$37+┌!$K$24:$M$34+█!$I$39+█!$K$23:$M$35+▄!$J$38+▄!$K$27:$M$35+▌!$J$38+▌!$L$24:$N$34+ ▐ !$J$41+ ▐ !$J$30:$L$37+ ▀ !$J$37+ ▀ !$K$27:$M$38+ї!$G$39+ї!$K$28:$M$34+Ў!$G$41+Ў!$I$33:$J$39+°!$H$39+°!$K$27:$L$35+ ∙ !$J$37+ ∙ !$J$32:$K$37+·!$H$40+·!$I$29:$K$35+√!$I$39+√!$J$31:$K$38+¤!$I$38+¤!$I$31:$J$36+■!$I$39+■!$J$29:$K$36+   !$J$34+   !$J$26:$K$35,Cells!$A$1+Cells!$J$12:$L$15+ Merged Cells !$A$1:$G$9+ Merged Cells !$K$24+Styles!$A$1+Styles!$M$10:$M$21+ Row Column !$A$1+ Row Column !$L$7:$N$25+ @ !$A$2+ @ !$L$19:$M$31+ ! !$C$2+ ! !$M$10:$M$26+ ~ !$H$37+ ~ !$M$16:$P$30+ # !$G$37+ # !$L$17:$N$33+ $ !$F$35+ $ !$L$17:$M$30+ % !$G$35+ % !$L$16:$N$31+ ^ !$G$37+ ^ !$K$19:$N$32+ & !$H$38+ & !$L$17:$N$33+ () !$H$37+ () !$L$20:$N$36+ - !$H$38+ - !$L$18:$O$34+_!$G$37+_!$L$25:$N$34+ = !$H$36+ = !$K$29:$N$36+ + !$I$34+ + !$K$27:$M$35+ | !$H$35+ | !$I$32:$L$36+ {} !$H$36+ {} !$I$35:$L$38+ ` !$H$37+ ` !$J$33:$M$39+№!$I$36+№!$J$35:$M$39+ ; !$G$38+ ; !$H$37:$I$39+ё!$G$41+ё!$G$40:$L$44+ " !$C$30+ " !$C$30:$D$35+ , !$G$39+ , !$G$38:$J$39+ . !$G$37+ . !$H$35:$H$38+ <> !$I$35+ <> !$I$35:$K$36+ 1 !$H$37+ 1 !$H$36:$J$39+▲!$I$37+▲!$K$30:$L$39+ ☺ !$H$36+ ☺ !$I$34:$K$37+ ☻ !$J$38+ ☻ !$L$28:$M$34+♥!$I$37+♥!$K$27:$M$36+ ♦ !$I$36+ ♦ !$K$30:$M$35+♣!$I$37+♣!$K$34:$L$39+♠!$J$31+♠!$L$31:$N$39+ • !$H$34+ • !$I$30:$L$37+ ◘ !$K$32+ ◘ !$M$19:$O$29+○!$J$35+○!$K$29:$M$35+ ◙ !$I$36+ ◙ !$L$27:$N$34+♂!$K$32+♂!$M$26:$N$34+♪!$I$35+♪!$M$25:$O$35+♀!$K$34+♀!$L$28:$N$36+ ♫ !$I$34+ ♫ !$L$30:$M$36+ ☼ !$J$37+ ☼ !$K$29:$L$36+ ► !$J$39+ ► !$K$33:$M$38+ ◄ !$J$38+ ◄ !$L$27:$N$35+↕!$L$32+↕!$L$30:$N$36+ ‼ !$J$38+ ‼ !$K$31:$M$38+¶!$J$33+¶!$L$25:$N$33+§!$K$33+§!$L$25:$N$33+ ▬ !$J$39+ ▬ !$K$33:$M$38+ ↨ !$J$34+ ↨ !$L$29:$N$38+↑!$K$35+↑!$M$28:$N$36+↓!$K$37+↓!$L$25:$N$32+→!$L$32+→!$M$16:$P$28+←!$J$39+←!$K$30:$N$38+∟!$J$36+∟!$L$30:$M$36+∟!$J$39+∟!$L$29:$N$37+↔!$I$35+↔!$L$25:$N$30+▼!$J$31+▼!$L$27:$M$34+   !$K$34+   !$M$23:$O$33+ 0 !$L$33+ 0 !$L$31:$O$35+ ░ !$J$36+ ░ !$M$29:$N$38+▒!$J$39+▒!$K$30:$N$35+▓!$J$35+▓!$K$28:$N$35+│!$K$35+│!$M$29:$O$37+┤!$J$38+┤!$L$31:$N$37+╡!$J$38+╡!$L$31:$M$37+╢!$J$40+╢!$K$34:$M$37+╖!$J$38+╖!$K$33:$L$36+╕!$J$38+╕!$L$32:$M$38+╣!$J$38+╣!$K$24:$N$33+║!$J$38+║!$M$25:$O$36+╗!$J$39+╗!$L$27:$N$37+╝!$J$39+╝!$L$27:$N$38+╜!$J$38+╜!$M$30:$N$38+╛!$J$39+╛!$L$26:$O$37,╟!$C$34+╟!$G$26:$K$29+╚!$B$40+╚!$G$33:$K$38+╔!$D$38+╔!$F$35:$I$37+╩!$C$39+╩!$D$36:$F$40+╦!$E$36+╦!$D$37:$F$39+╠!$E$38+╠!$K$24:$M$35+═!$E$40+═!$H$35:$J$39+╬!$I$33+╬!$L$23:$N$33+╧!$F$40+╧!$K$25:$L$35+╨!$G$39+╨!$L$23:$M$34+╤!$G$40+╤!$K$27:$M$38+╥!$G$39+╥!$J$31:$L$37+╙!$H$39+╙!$J$28:$L$39+╘!$H$39+╘!$J$28:$M$34+╒!$I$38+╒!$K$27:$M$38+╓!$H$40+╓!$J$24:$M$34+╫!$H$36+╫!$J$25:$L$38+╪!$I$35+╪!$K$24:$L$34+┘!$I$38+┘!$L$23:$M$34+┌!$I$37+┌!$K$24:$M$34+█!$I$39+█!$K$23:$M$35+▄!$J$38+▄!$K$27:$M$35+▌!$J$38+▌!$L$24:$N$34+ ▐ !$J$41+ ▐ !$J$30:$L$37+ ▀ !$J$37+ ▀ !$K$27:$M$38+ї!$G$39+ї!$K$28:$M$34+Ў!$G$41+Ў!$I$33:$J$39+°!$H$39+°!$K$27:$L$35+ ∙ !$J$37+ ∙ !$J$32:$K$37+·!$H$40+·!$I$29:$K$35+√!$I$39+√!$J$31:$K$38+¤!$I$38+¤!$I$31:$J$36+■!$I$39+■!$J$29:$K$36+   !$J$34+   !$J$26:$K$35,Cells!$A$1+Cells!$J$12:$L$15+ Merged Cells !$A$1:$G$9+ Merged Cells !$K$24+Styles!$A$1+Styles!$M$10:$M$21+ Row Column !$A$1+ Row Column !$L$7:$N$25+ @ !$A$2+ @ !$L$19:$M$31+ ! !$C$2+ ! !$M$10:$M$26+ ~ !$H$37+ ~ !$M$16:$P$30+ # !$G$37+ # !$L$17:$N$33+ $ !$F$35+ $ !$L$17:$M$30+ % !$G$35+ % !$L$16:$N$31+ ^ !$G$37+ ^ !$K$19:$N$32+ & !$H$38+ & !$L$17:$N$33+ () !$H$37+ () !$L$20:$N$36+ - !$H$38+ - !$L$18:$O$34+_!$G$37+_!$L$25:$N$34+ = !$H$36+ = !$K$29:$N$36+ + !$I$34+ + !$K$27:$M$35+ | !$H$35+ | !$I$32:$L$36+ {} !$H$36+ {} !$I$35:$L$38+ ` !$H$37+ ` !$J$33:$M$39+№!$I$36+№!$J$35:$M$39+ ; !$G$38+ ; !$H$37:$I$39+ё!$G$41+ё!$G$40:$L$44+ " !$C$30+ " !$C$30:$D$35+ , !$G$39+ , !$G$38:$J$39+ . !$G$37+ . !$H$35:$H$38+ <> !$I$35+ <> !$I$35:$K$36+ 1 !$H$37+ 1 !$H$36:$J$39+▲!$I$37+▲!$K$30:$L$39+ ☺ !$H$36+ ☺ !$I$34:$K$37+ ☻ !$J$38+ ☻ !$L$28:$M$34+♥!$I$37+♥!$K$27:$M$36+ ♦ !$I$36+ ♦ !$K$30:$M$35+♣!$I$37+♣!$K$34:$L$39+♠!$J$31+♠!$L$31:$N$39+ • !$H$34+ • !$I$30:$L$37+ ◘ !$K$32+ ◘ !$M$19:$O$29+○!$J$35+○!$K$29:$M$35+ ◙ !$I$36+ ◙ !$L$27:$N$34+♂!$K$32+♂!$M$26:$N$34+♪!$I$35+♪!$M$25:$O$35+♀!$K$34+♀!$L$28:$N$36+ ♫ !$I$34+ ♫ !$L$30:$M$36+ ☼ !$J$37+ ☼ !$K$29:$L$36+ ► !$J$39+ ► !$K$33:$M$38+ ◄ !$J$38+ ◄ !$L$27:$N$35+↕!$L$32+↕!$L$30:$N$36+ ‼ !$J$38+ ‼ !$K$31:$M$38+¶!$J$33+¶!$L$25:$N$33+§!$K$33+§!$L$25:$N$33+ ▬ !$J$39+ ▬ !$K$33:$M$38+ ↨ !$J$34+ ↨ !$L$29:$N$38+↑!$K$35+↑!$M$28:$N$36+↓!$K$37+↓!$L$25:$N$32+→!$L$32+→!$M$16:$P$28+←!$J$39+←!$K$30:$N$38+∟!$J$36+∟!$L$30:$M$36+∟!$J$39+∟!$L$29:$N$37+↔!$I$35+↔!$L$25:$N$30+▼!$J$31+▼!$L$27:$M$34+   !$K$34+   !$M$23:$O$33+ 0 !$L$33+ 0 !$L$31:$O$35+ ░ !$J$36+ ░ !$M$29:$N$38+▒!$J$39+▒!$K$30:$N$35+▓!$J$35+▓!$K$28:$N$35+│!$K$35+│!$M$29:$O$37+┤!$J$38+┤!$L$31:$N$37+╡!$J$38+╡!$L$31:$M$37+╢!$J$40+╢!$K$34:$M$37+╖!$J$38+╖!$K$33:$L$36+╕!$J$38+╕!$L$32:$M$38+╣!$J$38+╣!$K$24:$N$33+║!$J$38+║!$M$25:$O$36+╗!$J$39+╗!$L$27:$N$37+╝!$J$39+╝!$L$27:$N$38+╜!$J$38+╜!$M$30:$N$38+╛!$J$39+╛!$L$26:$O$37)/╫!K6