GNOME.org
 

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

Hello,
I am sorry it appears I need to clear a few things regarding my observation and handling this huge file.
- Libre office does not seg fault with core dumped message here. It freezes hard enough that it shows libreoffice has stopped responding do you want to force close it? And it won't recover so the only way to continue is to force close it. - It won't freeze for me all the time but playing with this document multiple times I think you can get it to freeze like this. - After an indication from Chrys that this is also happening when orca is not used I am afraid this might be general libreoffice thing.
Do you know what and how to capture it in this kind of situation to be able to submit to libreoffice people? 

Greetings

Peter

On 12.01.2016 at 01:00 Alonzo cuellar wrote:

hello,
I've open your file Peter on a Fedora installation.
I'm able to navigate the file. When I get to sheet IP LO does speed up my fan on my processor and the system hangs a bit, but I'm still able to use the arrows to navigate the spread sheet. I'd have to compare perhaps on an arch machine which I can probably do later. Lo is a bit slower when I view sheet IP. When I move to the first sheet with control-page-up Lo is faster and is more responsive with Orca when using the arrows to navigate the table. 

Alonzo
On 01/11/2016 03:27 PM, Peter Vágner wrote:

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


_______________________________________________
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]