title: Font error in formula box in Excel?
body: <p>I have an Excel file (.xls), it has about 1400 rows, there are rows which are displayed in correct font (both in sheet cells and in formula box which is docked at top). However there are some rows which are displayed with right font in sheet cells but if I select it and look at the formula box, it displays the text of the selected row in a wrong font (some kind of error or unsupported font).</p>
  
  <p>My excel file's content contains unicode text, my laptop is installed with the most common unicode fonts (simply my language need unicode to display properly and I always have many unicode fonts installed). I'm using Excel 2013, but I don't think the problem is something related to missing font... Maybe the formula box and the sheet cell use different fonts. A noticeable point is all the cells which have their contents displayed with wrong font in the formula box (I call these cells Group B cells) are formatted with a different font from the other cells (I call these Group A cells). I've tried changing the font of Group B cells to the font of Group A cells but their contents were displayed with wrong font (both in cells and in the formula box) then.</p>
  
  <p>If every work just handles with the Excel file only, there is not big problem, however I have a project which has to import this Excel file into a database. I've tried a demo and it loads the Excel file with lots of font errors. These errors are exact what displayed in the formula box I see in the Excel window. I don't know how to fix this. The problem is the customer supposes the Excel file is OK, and it looks like that (because the cells' contents are displayed OK in cells, the errors are just in the formula box). I don't have any reason to require the customer another Excel file.</p>
  
  <p>I'm using NPOI to read the Excel file, I think it reads the cell's content in the same way the formula box reads, I've tried applying the correct font for every row before reading its string but it doesn't seem to work. Could you have any idea on this, I just need some suggestion and don't hope for a complete or perfect solution (I know this is not easy)? My first ideas are trying to make the cells' contents displayed with right/correct font in the formula box in the Excel window first and then trying to do this using code with NPOI (or another lib), then import the Excel file normally, I hope there is a simpler solution which extracts the content (with correct font) right when reading the cells.</p>
  
  <p>Your suggestions would help me much in solving this problem. Thanks!</p>
  
  <p>===========================================================</p>
  
  <p>UPDATE with sample xls file <a href="https://sites.google.com/site/thecabinet3/home/files-store/sample.xls?attredirects=0&amp;d=1" rel="nofollow">xls file</a></p>