Page 1 of 1

MS Excel not displaying correctly =>crashes Vbox

Posted: 28. Dec 2019, 21:57
by maker675
Vbox 6.1, OSX host, Windows10 guest, VboxSVGA on Macbook Pro 15inch.

All works fine but Excel spreadsheets not displaying properly and then Vbox crashing whilst playing with Excel trying to get it to work.

Log attached - Open GL errors.

Re: MS Excel not displaying correctly =>crashes Vbox

Posted: 29. Dec 2019, 09:23
by maker675
Yep there seems to be some incompatibility between Excel (microsoft office spreadsheet app - oddly it's quite good) and VBSVGA driver.

Excel runs and displays correctly with VBoxVGA driver

Re: MS Excel not displaying correctly =>crashes Vbox

Posted: 29. Dec 2019, 13:37
by mpack
These things are usually caused by a bug in the host graphics driver, otherwise we'd all see the same crash. Try turning off 3D acceleration.

I see an awful lot of these in the log.
00:01:05.219650 GUI: UIDesktopWidgetWatchdog::sltHandleHostScreenWorkAreaResized: Screen 0 work area is formally resized to: 0x0 x 1680x1050
00:01:13.928487 VMSVGA: unknown sid=184 (expected sid=4294967295)
00:01:13.935278 VMSVGA: unknown sid=184 (expected sid=4294967295)
00:01:13.935344 VMSVGA: unknown sid=184 (expected sid=4294967295)
00:01:13.935354 VMSVGA: unknown sid=184 (expected sid=4294967295)
...
00:01:30.760923 VMSVGA3d: OpenGL error 0x500 (idActiveContext=0xffffeeee) on line 2324 glPixelStorei(GL_UNPACK_ALIGNMENT, pSave->iAlignment)
00:01:30.761055 VMSVGA3d: OpenGL error 0x506 (idActiveContext=0xffffeeee) on line 2229 glGetIntegerv(GL_UNPACK_ALIGNMENT, &pSave->iAlignment)
The GL_UNPACK_ALIGNMENT possibly implies that your host and guest color depths are different. Make sure you have used 32bpp colours in both host and guest.

Re: MS Excel not displaying correctly =>crashes Vbox

Posted: 29. Dec 2019, 14:47
by maker675
Tried earlier with no 3d acceleratoin to no avail.

However there is seemingly a bit depth issue. Don't find how to set in OSX Host but in Windows Guest settings are problematic (see below). Although VirtualBox driver is selected (and set to 32bit depth) in the main Windows Display control panel bit depth is listed as 8-bit?

Tried changing display settings in the Vbox graphics adapter and resolution changes were accepted by windows but it continued at 8-bit colour.
settings2.png
settings2.png (112.59 KiB) Viewed 2007 times

Re: MS Excel not displaying correctly =>crashes Vbox

Posted: 29. Dec 2019, 15:09
by maker675
OK it's not that. Apparently when MS says "8-bit" in display prefs, they mean "8-bit per channel x 4 hannels = 32 bit total"

https://www.reddit.com/r/techsupport/co ... bit_depth/

Re: MS Excel not displaying correctly =>crashes Vbox

Posted: 29. Dec 2019, 18:11
by mpack
maker675 wrote:OK it's not that. Apparently when MS says "8-bit" in display prefs, they mean "8-bit per channel x 4 hannels = 32 bit total"
Yes, it sprang to mind that they might mean that, in these days where 10-bit HDR is beginning to be marketed.

Re: MS Excel not displaying correctly =>crashes Vbox

Posted: 3. Jan 2020, 13:29
by maker675
Continued to experiment.

Turns out you were right: turning off 3d acceleration not only solves the error message problem but fixes the "Excel spreadsheet problem".

There was not this graphics driver compatibilty problem before when using the VBoxVGA driver so hopefully as the VBoxSVGA driver evolves it will disappear.

Thanks