Single apostrophe problem in exported openoffice spreadsheet
When exporting grades I get the "single apostrophe problem" in Libreoffice calc 18.104.22.168. 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 12 months 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 12 months ago