Topics

NVDA problem reading Libr Office Calc spreadsheet

Chris Mullins
 

                Hi

I’m having a problem reading a Libra office Calc spreadsheet.  On opening the file I press Control+home to start at the top but as soon as I try and use the arrow keys to move between cells, silence ensues.  Please find the log file image below.

 

Cheers

Chris

 

INFO - __main__ (11:20:22.891) - MainThread (3444):

Starting NVDA version 2019.3.1

INFO - core.main (11:20:23.094) - MainThread (3444):

Config dir: C:\Users\Chris\AppData\Roaming\nvda

INFO - config.ConfigManager._loadConfig (11:20:23.094) - MainThread (3444):

Loading config: C:\Users\Chris\AppData\Roaming\nvda\nvda.ini

INFO - core.main (11:20:23.235) - MainThread (3444):

Using Windows version 10.0.18363 workstation

INFO - core.main (11:20:23.241) - MainThread (3444):

Using Python version 3.7.5 (tags/v3.7.5:5c02a39a0b, Oct 14 2019, 23:09:19) [MSC v.1916 32 bit (Intel)]

INFO - core.main (11:20:23.241) - MainThread (3444):

Using comtypes version 1.1.7

INFO - core.main (11:20:23.241) - MainThread (3444):

Using configobj version 5.1.0 with validate version 1.0.1

INFO - synthDriverHandler.setSynth (11:20:23.889) - MainThread (3444):

Loaded synthDriver oneCore

INFO - core.main (11:20:23.889) - MainThread (3444):

Using wx version 4.0.3 msw (phoenix) wxWidgets 3.0.5 with six version 1.12.0

INFO - brailleInput.initialize (11:20:23.894) - MainThread (3444):

Braille input initialized

INFO - braille.initialize (11:20:23.894) - MainThread (3444):

Using liblouis version 3.10.0

INFO - braille.initialize (11:20:23.899) - MainThread (3444):

Using pySerial version 3.4

INFO - braille.BrailleHandler.setDisplayByName (11:20:23.909) - MainThread (3444):

Loaded braille display driver noBraille, current display has 0 cells.

INFO - core.main (11:20:24.178) - MainThread (3444):

Java Access Bridge support initialized

INFO - _UIAHandler.UIAHandler.MTAThreadFunc (11:20:24.204) - _UIAHandler.UIAHandler.MTAThread (8756):

UIAutomation: IUIAutomation6

INFO - core.main (11:20:25.370) - MainThread (3444):

NVDA initialized

INFO - globalCommands.GlobalCommands.script_navigatorObject_devInfo (11:22:07.383) - MainThread (3444):

Developer info for navigator object:

name: None

role: ROLE_TABLECELL

roleText: None

states:

isFocusable: False

hasFocus: False

Python object: <NVDAObjects.Dynamic_SymphonyTableCellEditableTextWithAutoSelectDetectionIAccessible object at 0x07DCF390>

Python class mro: (<class 'NVDAObjects.Dynamic_SymphonyTableCellEditableTextWithAutoSelectDetectionIAccessible'>, <class 'appModules.soffice.SymphonyTableCell'>, <class 'NVDAObjects.behaviors.EditableTextWithAutoSelectDetection'>, <class 'NVDAObjects.IAccessible.IAccessible'>, <class 'NVDAObjects.window.Window'>, <class 'NVDAObjects.behaviors.EditableText'>, <class 'editableText.EditableText'>, <class 'NVDAObjects.NVDAObject'>, <class 'documentBase.TextContainerObject'>, <class 'baseObject.ScriptableObject'>, <class 'baseObject.AutoPropertyObject'>, <class 'object'>)

description: None

location: RectLTWH(left=0, top=0, width=0, height=0)

value: None

appModule: <'soffice' (appName 'soffice', process ID 5132) at address 87733f0>

appModule.productName: 'LibreOffice'

appModule.productVersion: '6.3.4.2'

TextInfo: <class 'appModules.soffice.SymphonyTextInfo'>

windowHandle: 394264

windowClassName: 'SALFRAME'

windowControlID: 0

windowStyle: 365887488

extendedWindowStyle: 256

windowThreadID: 3652

windowText: 'Phase2_Drawdown.ods - LibreOffice Calc'

displayText: ''

IAccessibleObject: <POINTER(IAccessible2) ptr=0x746781c at 8672b20>

IAccessibleChildID: 0

IAccessible event parameters: windowHandle=394264, objectID=-4, childID=-1037

IAccessible accName: None

IAccessible accRole: None

IAccessible accState: exception: unsupported operand type(s) for &: 'NoneType' and 'int'

IAccessible accDescription: None

IAccessible accValue: None

IAccessible2 windowHandle: 0

IAccessible2 uniqueID: 0

IAccessible2 role: ROLE_SYSTEM_CELL

IAccessible2 states:  (0)

IAccessible2 attributes: None

 

 

hi.
did you press f2 before reading spredsheets?
in some versions of libreoffice , you need f2 and scape first.

On 3/12/20, Chris Mullins <cjmullins29@...> wrote:
Hi
I’m having a problem reading a Libra office Calc spreadsheet. On opening
the file I press Control+home to start at the top but as soon as I try and
use the arrow keys to move between cells, silence ensues. Please find the
log file image below.

Cheers
Chris

INFO - __main__ (11:20:22.891) - MainThread (3444):
Starting NVDA version 2019.3.1
INFO - core.main (11:20:23.094) - MainThread (3444):
Config dir: C:\Users\Chris\AppData\Roaming\nvda
INFO - config.ConfigManager._loadConfig (11:20:23.094) - MainThread (3444):
Loading config: C:\Users\Chris\AppData\Roaming\nvda\nvda.ini
INFO - core.main (11:20:23.235) - MainThread (3444):
Using Windows version 10.0.18363 workstation
INFO - core.main (11:20:23.241) - MainThread (3444):
Using Python version 3.7.5 (tags/v3.7.5:5c02a39a0b, Oct 14 2019, 23:09:19)
[MSC v.1916 32 bit (Intel)]
INFO - core.main (11:20:23.241) - MainThread (3444):
Using comtypes version 1.1.7
INFO - core.main (11:20:23.241) - MainThread (3444):
Using configobj version 5.1.0 with validate version 1.0.1
INFO - synthDriverHandler.setSynth (11:20:23.889) - MainThread (3444):
Loaded synthDriver oneCore
INFO - core.main (11:20:23.889) - MainThread (3444):
Using wx version 4.0.3 msw (phoenix) wxWidgets 3.0.5 with six version
1.12.0
INFO - brailleInput.initialize (11:20:23.894) - MainThread (3444):
Braille input initialized
INFO - braille.initialize (11:20:23.894) - MainThread (3444):
Using liblouis version 3.10.0
INFO - braille.initialize (11:20:23.899) - MainThread (3444):
Using pySerial version 3.4
INFO - braille.BrailleHandler.setDisplayByName (11:20:23.909) - MainThread
(3444):
Loaded braille display driver noBraille, current display has 0 cells.
INFO - core.main (11:20:24.178) - MainThread (3444):
Java Access Bridge support initialized
INFO - _UIAHandler.UIAHandler.MTAThreadFunc (11:20:24.204) -
_UIAHandler.UIAHandler.MTAThread (8756):
UIAutomation: IUIAutomation6
INFO - core.main (11:20:25.370) - MainThread (3444):
NVDA initialized
INFO - globalCommands.GlobalCommands.script_navigatorObject_devInfo
(11:22:07.383) - MainThread (3444):
Developer info for navigator object:
name: None
role: ROLE_TABLECELL
roleText: None
states:
isFocusable: False
hasFocus: False
Python object:
<NVDAObjects.Dynamic_SymphonyTableCellEditableTextWithAutoSelectDetectionIAccessible
object at 0x07DCF390>
Python class mro: (<class
'NVDAObjects.Dynamic_SymphonyTableCellEditableTextWithAutoSelectDetectionIAccessible'>,
<class 'appModules.soffice.SymphonyTableCell'>, <class
'NVDAObjects.behaviors.EditableTextWithAutoSelectDetection'>, <class
'NVDAObjects.IAccessible.IAccessible'>, <class 'NVDAObjects.window.Window'>,
<class 'NVDAObjects.behaviors.EditableText'>, <class
'editableText.EditableText'>, <class 'NVDAObjects.NVDAObject'>, <class
'documentBase.TextContainerObject'>, <class 'baseObject.ScriptableObject'>,
<class 'baseObject.AutoPropertyObject'>, <class 'object'>)
description: None
location: RectLTWH(left=0, top=0, width=0, height=0)
value: None
appModule: <'soffice' (appName 'soffice', process ID 5132) at address
87733f0>
appModule.productName: 'LibreOffice'
appModule.productVersion: '6.3.4.2'
TextInfo: <class 'appModules.soffice.SymphonyTextInfo'>
windowHandle: 394264
windowClassName: 'SALFRAME'
windowControlID: 0
windowStyle: 365887488
extendedWindowStyle: 256
windowThreadID: 3652
windowText: 'Phase2_Drawdown.ods - LibreOffice Calc'
displayText: ''
IAccessibleObject: <POINTER(IAccessible2) ptr=0x746781c at 8672b20>
IAccessibleChildID: 0
IAccessible event parameters: windowHandle=394264, objectID=-4,
childID=-1037
IAccessible accName: None
IAccessible accRole: None
IAccessible accState: exception: unsupported operand type(s) for &:
'NoneType' and 'int'
IAccessible accDescription: None
IAccessible accValue: None
IAccessible2 windowHandle: 0
IAccessible2 uniqueID: 0
IAccessible2 role: ROLE_SYSTEM_CELL
IAccessible2 states: (0)
IAccessible2 attributes: None




--
By God,
were I given all the seven heavens
with all they contain
in order that
I may disobey God
by depriving an ant
from the husk of a grain of barley,
I would not do it.
imam ali

Chris Mullins
 

Hi Zara

Thanks for the tip, that seems to have solved the problem.  I just opened some sheets I created a few weeks ago and I have never had to use that key combination in that manner before today but it works so I’m happy.

 

Cheers

Chris

 

From: zahra
Sent: 12 March 2020 14:48
To: nvda@nvda.groups.io
Subject: Re: [nvda] NVDA problem reading Libr Office Calc spreadsheet

 

hi.

did you press f2 before reading spredsheets?

in some versions of libreoffice , you need f2 and scape first.

 

On 3/12/20, Chris Mullins <cjmullins29@...> wrote:

>             Hi

> I’m having a problem reading a Libra office Calc spreadsheet.  On opening

> the file I press Control+home to start at the top but as soon as I try and

> use the arrow keys to move between cells, silence ensues.  Please find the

> log file image below.

> Cheers

> Chris

> INFO - __main__ (11:20:22.891) - MainThread (3444):

> Starting NVDA version 2019.3.1

> INFO - core.main (11:20:23.094) - MainThread (3444):

> Config dir: C:\Users\Chris\AppData\Roaming\nvda

> INFO - config.ConfigManager._loadConfig (11:20:23.094) - MainThread (3444):

> Loading config: C:\Users\Chris\AppData\Roaming\nvda\nvda.ini

> INFO - core.main (11:20:23.235) - MainThread (3444):

> Using Windows version 10.0.18363 workstation

> INFO - core.main (11:20:23.241) - MainThread (3444):

> Using Python version 3.7.5 (tags/v3.7.5:5c02a39a0b, Oct 14 2019, 23:09:19)

> [MSC v.1916 32 bit (Intel)]

> INFO - core.main (11:20:23.241) - MainThread (3444):

> Using comtypes version 1.1.7

> INFO - core.main (11:20:23.241) - MainThread (3444):

> Using configobj version 5.1.0 with validate version 1.0.1

> INFO - synthDriverHandler.setSynth (11:20:23.889) - MainThread (3444):

> Loaded synthDriver oneCore

> INFO - core.main (11:20:23.889) - MainThread (3444):

> Using wx version 4.0.3 msw (phoenix) wxWidgets 3.0.5 with six version

> 1.12.0

> INFO - brailleInput.initialize (11:20:23.894) - MainThread (3444):

> Braille input initialized

> INFO - braille.initialize (11:20:23.894) - MainThread (3444):

> Using liblouis version 3.10.0

> INFO - braille.initialize (11:20:23.899) - MainThread (3444):

> Using pySerial version 3.4

> INFO - braille.BrailleHandler.setDisplayByName (11:20:23.909) - MainThread

> (3444):

> Loaded braille display driver noBraille, current display has 0 cells.

> INFO - core.main (11:20:24.178) - MainThread (3444):

> Java Access Bridge support initialized

> INFO - _UIAHandler.UIAHandler.MTAThreadFunc (11:20:24.204) -

> _UIAHandler.UIAHandler.MTAThread (8756):

> UIAutomation: IUIAutomation6

> INFO - core.main (11:20:25.370) - MainThread (3444):

> NVDA initialized

> INFO - globalCommands.GlobalCommands.script_navigatorObject_devInfo

> (11:22:07.383) - MainThread (3444):

> Developer info for navigator object:

> name: None

> role: ROLE_TABLECELL

> roleText: None

> states:

> isFocusable: False

> hasFocus: False

> Python object:

> <NVDAObjects.Dynamic_SymphonyTableCellEditableTextWithAutoSelectDetectionIAccessible

> object at 0x07DCF390>

> Python class mro: (<class

> 'NVDAObjects.Dynamic_SymphonyTableCellEditableTextWithAutoSelectDetectionIAccessible'>,

> <class 'appModules.soffice.SymphonyTableCell'>, <class

> 'NVDAObjects.behaviors.EditableTextWithAutoSelectDetection'>, <class

> 'NVDAObjects.IAccessible.IAccessible'>, <class 'NVDAObjects.window.Window'>,

> <class 'NVDAObjects.behaviors.EditableText'>, <class

> 'editableText.EditableText'>, <class 'NVDAObjects.NVDAObject'>, <class

> 'documentBase.TextContainerObject'>, <class 'baseObject.ScriptableObject'>,

> <class 'baseObject.AutoPropertyObject'>, <class 'object'>)

> description: None

> location: RectLTWH(left=0, top=0, width=0, height=0)

> value: None

> appModule: <'soffice' (appName 'soffice', process ID 5132) at address

> 87733f0>

> appModule.productName: 'LibreOffice'

> appModule.productVersion: '6.3.4.2'

> TextInfo: <class 'appModules.soffice.SymphonyTextInfo'>

> windowHandle: 394264

> windowClassName: 'SALFRAME'

> windowControlID: 0

> windowStyle: 365887488

> extendedWindowStyle: 256

> windowThreadID: 3652

> windowText: 'Phase2_Drawdown.ods - LibreOffice Calc'

> displayText: ''

> IAccessibleObject: <POINTER(IAccessible2) ptr=0x746781c at 8672b20>

> IAccessibleChildID: 0

> IAccessible event parameters: windowHandle=394264, objectID=-4,

> childID=-1037

> IAccessible accName: None

> IAccessible accRole: None

> IAccessible accState: exception: unsupported operand type(s) for &:

> 'NoneType' and 'int'

> IAccessible accDescription: None

> IAccessible accValue: None

> IAccessible2 windowHandle: 0

> IAccessible2 uniqueID: 0

> IAccessible2 role: ROLE_SYSTEM_CELL

> IAccessible2 states:  (0)

> IAccessible2 attributes: None

>

 

 

--

By God,

were I given all the seven heavens

with all they contain

in order that

I may disobey God

by depriving an ant

from the husk of a grain of barley,

I would not do it.

imam ali