New
#1
Is default cell width for Excel 2013 8.43 or 8.38?
Hi guys,
almost a month ago I was working on a file on Excel 2010 (whose cells were 15 x 8,43), when all of a sudden Windows asked me to install the so-called "Windows 10 anniversary" update and, when I went on to open the file, I found out the cell width had gone from 8.43 to 8.38. As a result, only columns A through R would show on one page (before it was columns A through half of U), because each of them had gotten larger: I guess it was because 8.43 = 64 pixels and 8.38 = 72 pixels (so the number of pixels had increased)!
I thought it was an issue with an "old version" of Excel, so I uninstalled Office 2010 and had Office 2013 installed instead... and just the opposite happened: originally the cells were 15 x 8,38 (by default), but a second "Windows 10 anniversary" update last Friday brough the width back to 8.43. This is a problem, because I'm adding a bunch of pictures to my file in order to make them fit the cells containing them, and this constant width changes jeopardize that.
I've found out that "When using ClearType with the Windows Anniversary update, Excel column widths can be larger than in earlier versions of Windows. This happens in only some fonts, such as Calibri. It can affect all versions of Office 2016", so I have disabled ClearType and installed the fix (Windows update KB3197954). Now I'm stuck with blurry text all over my screen (no ClearType) and a grid whose cell width is 8,43 (which I assume was the "right" width, because it was the original one, because the "increased cell width" issue occurs when going from 8.43 to 8.38 and not the other way around, and also because the fix left it that like that instead of brining it back to 8.38).
Now my question is: am I right? Is 8.43 the "right" width or is it gonna change again? And, now that the bug is supposedly fixed, can I enable ClearType again or should I leave it ticked off for the rest of my life, otherwise this painful experience will happen all over again?
Sorry for the lengthy post, but there just was no way of asking this question using less words. I've also sought assistance on other forums, and almost everyone has been superrude to me, brushing off my problem and/or ignoring me all of a sudden midway through the conversation. So I hope it's gonna be different this time around. Looking forward to reading your replies ASAP.