Single apostrophe problem in exported openoffice spreadsheet

Added by Björn Johansson about 1 year ago

When exporting grades I get the "single apostrophe problem" in Libreoffice calc 6.0.1.1. 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.

https://ask.libreoffice.org/en/question/86199/how-to-remove-single-quote-in-front-of-numbers-in-a-cell/
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=49046

cheers,
Björn


Replies (2)

RE: Single apostrophe problem in exported openoffice spreadsheet - Added by Alexis Bienvenüe about 1 year 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.

(1-2/2)