Single apostrophe problem in exported openoffice spreadsheet
When exporting grades I get the "single apostrophe problem" in Libreoffice calc 220.127.116.11. in front of student numbers and test numbers.
This is an issue because I use vlookup to combine grades and student numbers (which are a five digit number) will not be recognized.
It is quite easy to work around (see links below), but it require manual intervention every time.
RE: Single apostrophe problem in exported openoffice spreadsheet - Added by Alexis Bienvenüe over 5 years ago
You can also use
TEXT(cell;"#") inside your
VLOOKUP to convert the student number to text before looking for it in the AMC table.
When using student numbers with a large number of digits, or including letters, the text representation is better.
RE: Single apostrophe problem in exported openoffice spreadsheet - Added by Björn Johansson over 5 years ago