GNOME.org
 

Re: [orca-list] Libreoffice Calc is Pissing me off These Days!

Howdy
I do understand that file is very huge and it may be slow to handle even when orca is not running and you are looking at the screen reading what you can your-self withouth a screen reader.
i just want to let you know that LO is also without a screenreader isnt well responsive to me. I m visualy impaired so i can do mostly anything without an Screenreader. I mostly use the magnifier.
I played arround with that file and LO crashes also to me without orca. so I would not realy speak about "confortable" in this case :). Sure! i fully agree.. those bugs have to been fixed and the performance should be improved overall but this wont happen until tomorrow. So i notice some workarrounds make you be able to read the file. As far as i know this is what the LO community currently doing. cut off old stuff, redesign stalled or ugly code and port to new technology. if i can believe the one or other blog from developers they make a great progress. lets hope the situation will improve for soon. 

i know this didnt help you right now. maybe otherone have better tips.

cheers chrys

Am 11.01.2016 um 22:27 schrieb Peter Vágner:

Hey Chrys,
I do understand that file is very huge and it may be slow to handle even when orca is not running and you are looking at the screen reading what you can your-self withouth a screen reader.
Still I would be interested to know if you can make Libre office to freeze when scrolling over that file or otherwise manipulating the data. I think Libre office Calc is suitable app to use when reading, sorting, filtering, running various stats and otherwise manipulating tabular data. It should be somewhat lighter than the large database engines e.g. MySQL or Postgresql.
So if dealing with such huge file is confortable for sighted people we would be happy to get as close as possible while handling it and relying on assistive technologies at the same time.
When opening such a document we only need single file. If we were about to save it into different output format be it plain text (CSV), multiple HTML files it only adds more and more complexity.
Please note I don't want to sound too demanding I am just trying to point out how this is working here. And I am sure I'm not alone thinking an improvement in this regard would be welcome.
I know there are several clever developers working on Libreoffice accessibility so I'm sure we are slowly getting there. 

Greetings

Peter

On 11.01.2016 at 20:23 chrys87 wrote:

Howdy,

this excel file is also very slow to me without orca.
if i save it as ods its about 15 MB. I m shure that in 236 kb is not any picutrue included. 15 MB is not the biggest file, but embedding so much pictures isnt the best idea at all.... You could try to save it to HTML (take care.. do it in a seperate folder because it creates one file per image). Maybe its more easy to navigate via the browser to you? or save the current sheet as CSV if you dont need the pictures... 
cheers chrys

Am 11.01.2016 um 18:33 schrieb kendell clark:

hi
I've just downloaded this spreadsheet. It's quite large for a spreadsheet. I have managed to freeze LO once, by following your instructions. I also tried converting it to an ODF spreadsheet, and it seemed to work, going from 8 mb to 236 kb, but I'm not sure it saved all the images. I quickly deleted the odf version and was playing with the xlsx file. 
Thanks
Kendell clark


On 01/11/2016 11:22 AM, Peter Vágner wrote:

Hello,
I am afraid when accessibility is being used Libre office Calc tends to freeze randomly, however I can't give precise steps to reproduce. Closest I can get to provide steps to follow is having a play with the following huge document: http://files.pvagner.tk/145018538481.xlsx It's a huge file, unfortunatelly it's not in english. That is a price list including product pictures their descriptions and different grade prices. I can make Libreoffice Calc to freeze by going to the sheet named IP by repeatedly pressing ctrl+page down. Then when this sheet is displayed then sometimes Libreoffice Calc freezes right when pressing ctrl+home to jump to the top of that sheet. Sometimes pressing ctrl+home goes to the cell addressed A1. If that works out. Then I can move down to A5 by repeatedly pressing down arrow key. Then moving over the cells B5, C5, D5, E5, E6, D6, C6, B6, A6, A7, B7, C7.... and so forth eventually makes Calc to freeze. So you are moving left to right in the current line, then go down a line, move right to left, move down another line and repeat until you can see Calc freezing. I think it has something to do with images being displayed in there but this is only my wild guess and I can't prove it.
If you are brave enough to try duplicating this, then I think you can reproduce this. 

Greetings

Peter


On 11.01.2016 at 05:11 kendell clark wrote:

hi
Could you send me some nonsensitive spreadsheets to test with? Just one will do. I'm trying to get a handle on exactly what's going wrong, and I don't have any spreadsheets to work with. I don't think gnome has much to do with lo. That said, if there are problems, this needs to be reported to this list so joanie can take a look. I'll take care of that you don't need to if you don't want to. If libreoffice calc isn't working like it should it needs to be fixed. As for the a11y fixes, I'm not completely sure. I do remember quite a few were worked around in orca back before 3.18 was released, and there were a couple of writer fixes. I don't have specifics off the top of my head but I can probably find something. If all your spreadsheets are sensitive some sample spreadsheets would do on the web, if I can find any. I need a fairly complex one, though it obviously can't have ms macros since libreoffice apparently throws a fit with those. 
Thanks
Kendell clark


On 01/10/2016 10:06 PM, Steve Holmes wrote:

OK, I upgraded to libreoffice-fresh (current version 5.0.4-3 on
Arch). I still seem to have trouble with a couple spreadsheets; this
might be a problem with the sheets which means it will be a bitch to
figure out. I might have to export the thing and re-create the
thing. I have some formulas and stuff in it so we'll have to see. I am 
able to load a couple *.xls spreadsheets without problems so far.

I am curious though; if there are supposed a11y fixes, I wonder what
they actually are. I still don't get any announcements when I shift
arrows to select cells. In fact, it appears that shift arrows don't
even move the focus from the original cell. Does Calc no longer select 
cells with shifted arrow keys?

Just trying to restore my faith in gnome here.:)

On Sun, Jan 10, 2016 at 01:45:44PM -0600, kendell clark wrote:

hi
Before taking that drastic a step, try upgrading to libreoffice-fresh. It's at version 5.3, and has lots, and I do mean lots, of accessibility and stability fixes. At least try that. If that fails, it could be your spreadsheets although that's not likely. 

Thanks
Kendell clark


On 01/10/2016 01:28 PM, Steve Holmes wrote:
I've been having problems lately with Libreoffice calc locking up on 
me almost every other time I try to open a spreadsheet. I am using
libreoffice-still-4.4.3 (latest from Arch repos. When the file is
opened, the program hangs and eventually, a message pops up that
soffice has stopped responding. Like, did gnome degrade to that of
Microsoft Window? Really, I may have to migrate all my spreadsheet
activities over to the Mac; at least Numbers works all the time for 
me.

I don't have any other debug info available so this may be hard to
track down. In any case, is the "Unstable" versions of Libreoffice
better than this? As far as I'm concerned, I cannot any longer use
Calc for anything useful on my system.

Any ideas?
_______________________________________________
orca-list mailing list
orca-list gnome org
https://mail.gnome.org/mailman/listinfo/orca-list
Orca wiki: https://wiki.gnome.org/Projects/Orca
Orca documentation: https://help.gnome.org/users/orca/stable/
GNOME Universal Access guide: https://help.gnome.org/users/gnome-help/stable/a11y.html 
Log bugs and feature requests at http://bugzilla.gnome.org

_______________________________________________
orca-list mailing list
orca-list gnome org
https://mail.gnome.org/mailman/listinfo/orca-list
Orca wiki: https://wiki.gnome.org/Projects/Orca
Orca documentation: https://help.gnome.org/users/orca/stable/
GNOME Universal Access guide: https://help.gnome.org/users/gnome-help/stable/a11y.html 
Log bugs and feature requests at http://bugzilla.gnome.org

_______________________________________________
orca-list mailing list
orca-list gnome org
https://mail.gnome.org/mailman/listinfo/orca-list
Orca wiki: https://wiki.gnome.org/Projects/Orca
Orca documentation: https://help.gnome.org/users/orca/stable/
GNOME Universal Access guide: https://help.gnome.org/users/gnome-help/stable/a11y.html 
Log bugs and feature requests at http://bugzilla.gnome.org


_______________________________________________
orca-list mailing list
orca-list gnome org
https://mail.gnome.org/mailman/listinfo/orca-list
Orca wiki: https://wiki.gnome.org/Projects/Orca
Orca documentation: https://help.gnome.org/users/orca/stable/
GNOME Universal Access guide: https://help.gnome.org/users/gnome-help/stable/a11y.html 
Log bugs and feature requests at http://bugzilla.gnome.org




_______________________________________________
orca-list mailing list
orca-list gnome org
https://mail.gnome.org/mailman/listinfo/orca-list
Orca wiki: https://wiki.gnome.org/Projects/Orca
Orca documentation: https://help.gnome.org/users/orca/stable/
GNOME Universal Access guide: https://help.gnome.org/users/gnome-help/stable/a11y.html 
Log bugs and feature requests at http://bugzilla.gnome.org


_______________________________________________
orca-list mailing list
orca-list gnome org
https://mail.gnome.org/mailman/listinfo/orca-list
Orca wiki: https://wiki.gnome.org/Projects/Orca
Orca documentation: https://help.gnome.org/users/orca/stable/
GNOME Universal Access guide: https://help.gnome.org/users/gnome-help/stable/a11y.html 
Log bugs and feature requests at http://bugzilla.gnome.org
[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]