[Libreoffice-bugs] [Bug 135643] In Calc I tried to search for text "simon" in a spreadsheet, using Ctrl-F, entered text, pressed Enter key, crash. EDITING

Wed Aug 12 02:38:02 UTC 2020

https://bugs.documentfoundation.org/show_bug.cgi?id=135643

--- Comment #2 from mrdave740 at gmail.com ---
I replied to an email about this bug report, which asked me to try something. 
Nowhere in the email did it say not to reply.  Rejection email said, "Recipient
address rejected: You replied to a Bugzilla notification email. However email
replies are not added to bug reports."  No where did Julian's email say to
reply in the Bug Reporting system, or how to do that, or how I should respond. 
So I'm adding my email below, and hope my frustrations can find their way to
someone who can change things:

Hello Julian, thank you for the very quick response.  I didn't expect to hear
anything at all!  I installed 6.4.5.2 and that appears to have fixed the issue
I had this morning.

When I first saw the crashes, my first question was if a new version of
LibreOffice was available.  So I went to Help, Check for new version, and got
the message that 6.3.6 is up to date.  My mistake, I thought that meant no new
version is available, so I didn't look for one.  I guess it means, there is no
new version of the version I already have, so it's fairly useless and
misleading in my opinion.

Also, when the program asked me to submit a bug report, why didn't it take me
to the page your link leads to, "First steps to take before submitting a bug
report"?  I would have seen right away that a newer version existed. 
Altogether I spent about 10 hours trying to write the bug report, figure out
what Open GL is running, if any (still don't know that one), checked my LO User
Profile (worked the same in LO Safe Mode), searching the internet for posts
about similar issues, explored .ods file components after unzipping them,
checking other spreadsheet files, and trying to repair my file by copying sheet
contents to new tabs and manually fixing hundreds of links (Search & Replace
had the same issue as Search).

I think your bug was related to sheets with formulas linking to other sheets
within the same file.  A file saved last June had the same problem, so that
told me it was a software issue -- I _know_ I've done searches since then.  I
later realized I installed 6.3.6 only a few days ago, maybe a week, so that
version introduced the bug into my workflow.

So while I'm happy the problem is resolved, and happy for your support, I'm not
happy that most of my wasted time could have been avoided if the "Check for new
version" worked like it does in most (all?) other programs, and if your bug
report process at least offered an obvious link to "First steps to take".  So I
hope you can get word to the right development people.

My experience today will discourage me from recommending LO to others, and I
came very close to deleting the program from my PC.  A help process should
consider that users don't know everything developers know.  Even the bug report
option to pick what kind of system I have...  There's no option I can find
relating to a 64 bit x86 system (NOT the same as IA64, I did some research on
that also).  So I picked "Other" even though I have what is probably the most
common PC system type out there.  "All" didn't seem appropriate.  I don't know
how you use this information but your most common case can't be identified and
that simple menu cost me about 15 minutes.  

"See log" in Calc's About box was also quite unhelpful, it looked like a log of
old unrelated issues, not a log of what happened on my PC.  If it's some sort
of change log, say so in the About box.  From an end-user perspective,
LibreOffice and its support websites are very difficult to figure out.  I still
don't understand why Cutting/Pasting a group of cells in Calc has different
results than dragging the cells to a new destination.  Things change by
themselves over time, like formulas containing named references -- another name
gets substituted in formulas I didn't change.  Basics just don't seem to work
consistently.  For some context:  I've been using computers since 1975,
developed many applications and automations in MS Office/VBA and ran the IT
group at a GE facility.  The IT groups in two other companies I worked for told
me I know more about IT than they did, and I was called in to help them several
times, even though my background is Industrial Engineering.

So I wish you the best of luck and again, thank you for your help.  I've been
too lazy to switch products but today made me realize I've been letting hope
get in the way of reality for LibreOffice.

On Tue, Aug 11, 2020 at 3:57 PM <bugzilla-daemon at bugs.documentfoundation.org>
wrote:
 Julien Nabet changed bug 135643 
 What Removed Added Ever confirmed   1 Status UNCONFIRMED NEEDINFO CC  
serval2412 at yahoo.fr Comment # 1 on bug 135643 from Julien Nabet Could you give
a try with 6.4.5 + tryhttps://wiki.documentfoundation.org/QA/FirstSteps ? You
are receiving this mail because: You reported the bug. 

-- 
mrdave740 at gmail.com (primary)
mrdave740 at yahoo.com (if other address not working)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200812/1ee204a4/attachment.htm>