c# - Font error in formula box in Excel? -


i have excel file (.xls), has 1400 rows, there rows displayed in correct font (both in sheet cells , in formula box docked @ top). there rows displayed right font in sheet cells if select , @ formula box, displays text of selected row in wrong font (some kind of error or unsupported font).

my excel file's content contains unicode text, laptop installed common unicode fonts (simply language need unicode display , have many unicode fonts installed). i'm using excel 2013, don't think problem related missing font... maybe formula box , sheet cell use different fonts. noticeable point cells have contents displayed wrong font in formula box (i call these cells group b cells) formatted different font other cells (i call these group cells). i've tried changing font of group b cells font of group cells contents displayed wrong font (both in cells , in formula box) then.

if every work handles excel file only, there not big problem, have project has import excel file database. i've tried demo , loads excel file lots of font errors. these errors exact displayed in formula box see in excel window. don't know how fix this. problem customer supposes excel file ok, , looks (because cells' contents displayed ok in cells, errors in formula box). don't have reason require customer excel file.

i'm using npoi read excel file, think reads cell's content in same way formula box reads, i've tried applying correct font every row before reading string doesn't seem work. have idea on this, need suggestion , don't hope complete or perfect solution (i know not easy)? first ideas trying make cells' contents displayed right/correct font in formula box in excel window first , trying using code npoi (or lib), import excel file normally, hope there simpler solution extracts content (with correct font) right when reading cells.

your suggestions me in solving problem. thanks!

===========================================================

update sample xls file xls file

i using excel 2010 on win 7 64b.

i not have .vntime font installed screenshots see seeing , there appears disconnect between cell displays (font-formatted text) , formula bar displays. somehow, impacts way application reading cell values.

in cases safe read cell range object.

three alternatives may try change code read the:

  • cell.formula, or
  • cell.text, or
  • cell.value

one potential problem formatting may unique excel, , if underlying character set not supported application, database, or client's systems/computers, sort of mismatch error may persists.

there may additional information (although pertains number & date formatting) here:

http://blogs.office.com/b/microsoft-excel/archive/2007/11/12/manipulating-and-massaging-data-in-excel.aspx


Comments

Post a Comment

Popular posts from this blog

c# - Send Image in Json : 400 Bad request -

from android trying send image class of data, iis webservice. (c#) the problem 400 bad request . the image being encoded base64 . , placed json rest of class elements. my guess base64 not valid inside json. server not understand it. if set string "" , post accepted fine. so question is, how make base64 valid within json array? ( tried url.encode no success). or how should send image android webservice? gson gson = new gson(); string json = gson.tojson(record); // record has param { string base64photo } how big image? i'm pretty sure surpassing iis json size limit (default 4 mb). check http://geekswithblogs.net/frankw/archive/2008/08/05/how-to-configure-maxjsonlength-in-asp.net-ajax-applications.aspx or http://www.webtrenches.com/post.cfm/iis7-file-upload-size-limits good luck!
Read more

jquery - Fancybox - apply a function to several elements -

this source code below posted cristiano g. carvalho in answer question: calling fancybox gallery other link made user. <div class="details_gallery"> <a href="#" class="manualfancybox">manual call fancybox</a> <div class="details_gallery_min"> <a rel="details" href="max/1.jpg" class="fancybox"><img src="min/1.jpg" alt="" /></a> <a rel="details" href="max/2.jpg" class="fancybox"><img src="min/2.jpg" alt="" /></a> <a rel="details" href="max/3.jpg" class="fancybox"><img src="min/3.jpg" alt="" /></a> <a rel="details" href="max/4.jpg" class="fancybox"><img src="min/4.jpg" alt="" /></a> </div> </div> <script> $(document).read
Read more

An easy way to program an Android keyboard layout app -

i program android app replaces standard keyboard 1 one-hand optimized coffee++ keyboard layout. what special problems have face in progress? guess such project go deep android core, cause keyboard such essential thing. is wise start android developer tools (adt)—eclipse plugin described in this tutorial ? or there better way achieve goal? i new android programming, firm in php, mysql , javascript , use eclipse php i guess such project go deep android core, cause keyboard such essential thing. no. can create inputmethodservice implementation of keyboard. there sample soft keyboard in android sdk installation (if chose download sample code sdk manager), , there open source input methods floating around well, such hacker's keyboard. inputmethodservice distributed part of ordinary android application, , user can elect activate input method if user chooses. is wise start android developer tools (adt)—eclipse plugin described in tutorial? that fine s
Read more