Your attached document is designed wrong. This is a classic mistake made by people who don't understand how spreadsheets function. If you sort it with Google Sheets, Excel, Open Office Calc, LO Calc 4.2.8, Gnumeric, or WPS sheets they will all produce the same, correct results. Why? You used references when you should be using a table lookup function.
If we change the default sorting behavior to fix your broken spreadsheet, all spreadsheets through out the history of spreadsheets software would be incompatible with Libreoffice's sorting routine. You can have your broken sorting behavior by changing the option UpdateRef=TRUE. But be warned: your spreadsheet will NOT sort correctly on any other spreadsheet software, include libreoffice with default settings. A much better solution is to design your spreadsheets correctly by using a lookup function.
@Manuel Iglesias Alonso
Please refer to: www.dummies. com/how- to/content/ looking- up-data- in-excel- 2007-with- hlookup- and-vlo. navId-323123. html
http://
Your attached document is designed wrong. This is a classic mistake made by people who don't understand how spreadsheets function. If you sort it with Google Sheets, Excel, Open Office Calc, LO Calc 4.2.8, Gnumeric, or WPS sheets they will all produce the same, correct results. Why? You used references when you should be using a table lookup function.
If we change the default sorting behavior to fix your broken spreadsheet, all spreadsheets through out the history of spreadsheets software would be incompatible with Libreoffice's sorting routine. You can have your broken sorting behavior by changing the option UpdateRef=TRUE. But be warned: your spreadsheet will NOT sort correctly on any other spreadsheet software, include libreoffice with default settings. A much better solution is to design your spreadsheets correctly by using a lookup function.