Strange excel behavior. Maybe Fault !!!

%3CLINGO-SUB%20id%3D%22lingo-sub-2288608%22%20slang%3D%22en-US%22%3EStrange%20excel%20behavior.%20Maybe%20Fault%20!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2288608%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3ENote.%20Strange%20behavior%20of%20excel.%20Has%20anyone%20dealt%20with%20it%20and%20can%20explain%20this%20strange%20phenomenon%3F%20.%20I've%20included%20excel%20files%20for%20my%20post.%20They're%20on%20github.%20One%20is%20myCellEx.xlsx%20excel%20file%2C%20the%20other%20is%20sheet.xml%20after%20unpacking%20it%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FPiotrJanosik%2Fexcel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FPiotrJanosik%2Fexcel%3C%2FA%3E%20As%20you%20know%2C%20excel%20is%20a%20package%20of%20zipped%20files.%20Unpack%20myCellEx.xlsx%20and%20see%20the%20entries%20in%20the%20sheet.xml%20file.%20The%20column%20named%20B%20%40%20Z1%20has%20the%20value%3A%201378.%20There%20is%20no%20such%20column%20!.%26nbsp%3B%20There%20should%20be%20a%20column%20named%20AZZ1.%20The%20excel%20program%20should%20signal%20an%20error%20when%20it%20opens%20a%20file%20in%20which%20the%20wrong%20cell%20address%20is%20entered%20because%20there%20is%20no%20such%20cell%20address%20B%20%40%20Z1.%20See%20that%20I%20generated%20an%20incorrect%20sheet.xml%20file%20in%20which%20the%20wrong%20cell%20address%20format%20is%20stored%20and%20the%20excel%20program%20opens%20it.%20I%20wrote%20this%20address%20on%20purpose%20..%20Anyone%20know%20why%20excel%20allows%20it%3F%20.%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3EI'm%20learning%20programming.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3EI'm%20experimenting%20with%20Open%20XML.%3C%2FSPAN%3E%26nbsp%3BTherefore%2C%20I%20found%20it%20incomprehensible%20behavior%20of%20excel.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2288608%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Note. Strange behavior of excel. Has anyone dealt with it and can explain this strange phenomenon? . I've included excel files for my post. They're on github. One is myCellEx.xlsx excel file, the other is sheet.xml after unpacking it https://github.com/PiotrJanosik/excel As you know, excel is a package of zipped files. Unpack myCellEx.xlsx and see the entries in the sheet.xml file. The column named B @ Z1 has the value: 1378. There is no such column !.  There should be a column named AZZ1. The excel program should signal an error when it opens a file in which the wrong cell address is entered because there is no such cell address B @ Z1. See that I generated an incorrect sheet.xml file in which the wrong cell address format is stored and the excel program opens it. I wrote this address on purpose .. Anyone know why excel allows it? .I'm learning programming. I'm experimenting with Open XML. Therefore, I found it incomprehensible behavior of excel.

0 Replies