[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=10
   ||7929

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 CC||gti...@gmail.com
   See Also|https://bugs.freedesktop.or |
   |g/show_bug.cgi?id=63608 |
 Resolution|--- |NOTABUG

--- Comment #25 from Timur  ---
This bug needed a minimal test case and a simple explanation. 

If I understood it well: open attachment 79401 and see sheet: "Acqua condotta
sintesi", cell: B5 which is in MSO:
=VLOOKUP("CodicePerito";_RiservatoAxa_!A1:B210;2;FALSE) with value 20445.
LO opens it as: 
=VLOOKUP("CodicePerito";$_RiservatoAxa_.A1:B210;2;0) with value 0 BUT
recalculation also shows 20445.

Recalculation is F9 on that cell or Shift+Ctrl+F9 to recalculate all formulas
in the document.
And from LO 4.0 that we get with: "Menu/Tools/Options/LibreOffice calc/Formula
- Recalculation on file load" setting Excel 2007 and newer to always
recalculate or better prompt user.
Default option is to "Never recalculate". Previously LO 3.6 and earlier it was
"Always" so that's why this bug is repro from 4.0.

So it's not about "Fileopen: protected workbook", it's about "Fileopen: XLSX
needs hard recalculation". 
I close this as NotABug with the intention to open a new one with a general
problem about recalculations which are not transparent to the user. Even help
page https://help.libreoffice.org/Calc/Recalculate is wrong.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

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

--- Comment #24 from tommy27  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice (5.0.5 or 5.1.2 https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and your operating system, and any changes you see in the bug
behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a short comment that includes your version of
LibreOffice and Operating System

Please DO NOT

- Update the version field
- Reply via email (please reply directly on the bug tracker)
- Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so: 

1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug 

3. Leave a comment with your results. 

4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 
4b. If the bug was not present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for your help!

-- The LibreOffice QA Team This NEW Message was generated on: 2016-04-16

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

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

--- Comment #23 from QA Administrators qa-ad...@libreoffice.org ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice (4.4.1.2 or later): https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and your operating system, and any changes you see in the bug
behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a short comment that includes your version of
LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not appropriate in this case)

Thank you for your help!

-- The LibreOffice QA Team
This NEW Message was generated on: 2015-03-03

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=60718

--- Comment #18 from CORRADO VIAZZI corrado.via...@alfaspa.it ---
(In reply to comment #15)
  - I'm not sure, seems the real problem is difference between VLOOKUP
  function written with MSO  LO (see Bug 54657)
  * 'FALSE' written in MSO - change to '0' in LO
  * 'FALSE' in MSO = 'FALSE()' in LO
 
 But it's ok if 'Protect Sheet' disabled from MSO.


Yes, Your last row is right! It's a really behavior, and that is why I think
that it's not connected with FALSE.
Thanks for help!!!

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=60718

--- Comment #19 from CORRADO VIAZZI corrado.via...@alfaspa.it ---
(In reply to comment #17)
 I tried the second file then I leafed through the other comments, it seems
 related to recalculation issue each time.
 
 IHMO, the cell borders problem is another issue.
 
 Kohei/Markus/Eike: one for you?

I can confirm that the borders problem is not collegued. I thin it is the same
bug n°53287.
Thanks guys!

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=60718

CORRADO VIAZZI corrado.via...@alfaspa.it changed:

   What|Removed |Added

Version|4.0.0.3 release |4.0.3.3 release

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=60718

Julien Nabet serval2...@yahoo.fr changed:

   What|Removed |Added

Version|4.0.3.3 release |4.0.0.3 release

--- Comment #20 from Julien Nabet serval2...@yahoo.fr ---
Corrado: the version is the earliest one known, not the more recent. (see
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Version)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=60718

--- Comment #21 from CORRADO VIAZZI corrado.via...@alfaspa.it ---
(In reply to comment #20)
 Corrado: the version is the earliest one known, not the more recent. (see
 https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Version)
Sorry!
:-(

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=60718

--- Comment #22 from Julien Nabet serval2...@yahoo.fr ---
No problem Corrado, now you'll know :-)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=60718

--- Comment #13 from CORRADO VIAZZI corrado.via...@alfaspa.it ---
(In reply to comment #12)
 (In reply to comment #8)
  
  CASE 1:
  1) open the file ORIGINAL with Excel 2010 and remove sheet _Riservato AXA_
  protection. 
  2) Save the file in xlsx;
  3) re-open it with LO and You will see that everything seems to work fine,
  even if the function is changed ad above stated;
  4) if You try to save it in xlsx and reopen it, everything still seems fine,
  but cell bords became thicker;
 
 Seems that I often saw that bug reported. You can search  comment on that
 bug previously reported.
 
  CASE 2:
  Otherwise if You:
  1) open the file ORIGINAL with LO and remove sheet _Riservato AXA_
  protection. 
  2) Save the file in xlsx.
  2) re-open it with LO and You will see that nothing works.
 
 Not reproducible on LO 4.0.3.3 (Win7 32bit). Could you please test again
 using 4.0.3 release?
 
 I found another issue that 'Protect Sheet' removed after saving  reopening
 that XLSX file. Please confirm if you also find that.

CASE 1: please, what is the bug report number?
CASE 2: I confirm the procedure that I reported is fully reproducible even on
LO 4.0.3.3, I need more info from You.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=60718

ign_christian ign_christ...@yahoo.com changed:

   What|Removed |Added

   See Also||https://bugs.freedesktop.or
   ||g/show_bug.cgi?id=63608

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=60718

ign_christian ign_christ...@yahoo.com changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 CC||serval2...@yahoo.fr
   See Also||https://bugs.freedesktop.or
   ||g/show_bug.cgi?id=54567
 Ever confirmed|1   |0

--- Comment #14 from ign_christian ign_christ...@yahoo.com ---
I'm sorry if not describing clearly. Try to describe this issue(s):

CASE 1 (borders become thicker after saving  reopening XLSX produced by MSO)
See Bug 58356 , Bug 52578 , maybe related too with Bug 53287

CASE 2 
- Open attachment 79472  follow your instructions, you was right..no change
with VLOOKUP function  result on cell B5. I'm sorry, Comment #12 tested using
attachment 79473

- I'm not sure, seems the real problem is difference between VLOOKUP function
written with MSO  LO (see Bug 54657)
* 'FALSE' written in MSO - change to '0' in LO
* 'FALSE' in MSO = 'FALSE()' in LO

@Julien Nabet, maybe you could confirm this issue?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=60718

--- Comment #15 from ign_christian ign_christ...@yahoo.com ---
 - I'm not sure, seems the real problem is difference between VLOOKUP
 function written with MSO  LO (see Bug 54657)
 * 'FALSE' written in MSO - change to '0' in LO
 * 'FALSE' in MSO = 'FALSE()' in LO

But it's ok if 'Protect Sheet' disabled from MSO.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=60718

--- Comment #16 from Julien Nabet serval2...@yahoo.fr ---
On pc Debian x86-64 with master sources updated today, I gave a try to the
first file for the moment.
I noticed that if in B5, I put 1 instead of 0, then put back 0, it's ok.
So I try to force recalculation with Ctrl/Shift/F9 (see
https://help.libreoffice.org/Calc/Recalculate)

I'll try tests on other files

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=60718

Julien Nabet serval2...@yahoo.fr changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||er...@redhat.com,
   ||kohei.yosh...@suse.de,
   ||markus.mohrhard@googlemail.
   ||com
 Ever confirmed|0   |1

--- Comment #17 from Julien Nabet serval2...@yahoo.fr ---
I tried the second file then I leafed through the other comments, it seems
related to recalculation issue each time.

IHMO, the cell borders problem is another issue.

Kohei/Markus/Eike: one for you?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=60718

Urmas davian...@gmail.com changed:

   What|Removed |Added

Summary|FILEOPEN: protected folder  |FILEOPEN: protected
   ||workbook

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs