[Libreoffice-bugs] [Bug 97597] FILEOPEN: XLSX file on server opens with some blank tab pages (workaround: export MAX_CONCURRENCY=1)

[bugzilla-daemon]

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

Kohei Yoshida  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Assignee|libreoffice-b...@lists.free |kohei.yosh...@collabora.com
   |desktop.org |

--- Comment #22 from Kohei Yoshida  ---
I'm looking into this right now.

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages (workaround: export MAX_CONCURRENCY=1)

[bugzilla-daemon]

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

--- Comment #21 from k...@mroffice.org ---
(In reply to Kohei Yoshida from comment #20)
> (In reply to kees from comment #13)
> > Created attachment 127421 [details]
> > Example file: four tabsheets are missing data
> 
> I'm guessing this file was saved *after* the data loss had occurred. 
> Ideally we need a file that contains all the data prior to the data loss so
> that we can try and see if the data loss occurs...
> 
> If that's not possible, we'll first have to start by creating such a test
> file first.

Correct. I dont have the original version anymore, but from my experience it
will work with any xlsx, as long as it has a fair number of tabs (say >=15) and
it will take a bit of time to open the file (say >= 4 seconds). It will still
work even with this file - just duplicate some tabsheets if the file opens too
fast for the problem to occur.

By the way, we have now set MAX_CONCURRENCY=1 on all our workstations, and the
problem has completely gone away. We have lifted the ban on opening xlsx over
the network.

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages (workaround: export MAX_CONCURRENCY=1)

[bugzilla-daemon]

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

--- Comment #20 from Kohei Yoshida  ---
(In reply to kees from comment #13)
> Created attachment 127421 [details]
> Example file: four tabsheets are missing data

I'm guessing this file was saved *after* the data loss had occurred.  Ideally
we need a file that contains all the data prior to the data loss so that we can
try and see if the data loss occurs...

If that's not possible, we'll first have to start by creating such a test file
first.

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages (workaround: export MAX_CONCURRENCY=1)

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 CC||fil...@natreb.com.br

--- Comment #19 from m.a.riosv  ---
*** Bug 94424 has been marked as a duplicate of this bug. ***

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages (workaround: export MAX_CONCURRENCY=1)

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
Summary|FILEOPEN: XLSX file on  |FILEOPEN: XLSX file on
   |server opens with some  |server opens with some
   |blank tab pages |blank tab pages
   ||(workaround: export
   ||MAX_CONCURRENCY=1)
 Ever confirmed|0   |1

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 CC||ntarkala...@mail.com

--- Comment #18 from m.a.riosv  ---
*** Bug 103044 has been marked as a duplicate of this bug. ***

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

k...@mroffice.org changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

--- Comment #17 from k...@mroffice.org ---
(In reply to Michael Meeks from comment #16)
> Can you re-try with: export MAX_CONCURRENCY=1 into your environment, and
> re-test ?

I tested this: opened the same file from a windows share 4 times with this
setting and 4 times without. 

WITH the setting it opened correctly 4 times
WITHOUT the setting it opened correctly only 1 time, and three times the data
of 1 sheet was missing. It was a different sheet every time by the way.

So it definitely seems to make a difference.

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

Michael Meeks  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #16 from Michael Meeks  ---
Seems unlikely - I believe we download the whole file first to get to the ZIP
manifest at the end of the file, and then package will work on it - so network
effects shouldn't have any effect. But of course it is easy to test.

Can you re-try with: export MAX_CONCURRENCY=1 into your environment, and
re-test ?

Thanks !

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 CC||michael.me...@collabora.com

--- Comment #15 from Eike Rathke  ---
@mmeeks:
Could it be that the .xlsx import threaded sheet-loading has some hickups in
this Windows network shares constellation?

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

--- Comment #14 from k...@mroffice.org ---
Comment on attachment 127421
  --> https://bugs.documentfoundation.org/attachment.cgi?id=127421
Example file: four tabsheets are missing data

- there are missing data tabsheets pretty much every time the file is opened
over the network from a windows share
- there are no missing data tabsheets when the file is opened locally
- the problem does not occur with ods files
- the problem occurs with xlsx files created and touched only by LO.

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

--- Comment #13 from k...@mroffice.org ---
Created attachment 127421
  --> https://bugs.documentfoundation.org/attachment.cgi?id=127421=edit
Example file: four tabsheets are missing data

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

--- Comment #12 from k...@mroffice.org ---
I can also confirm this bug - it comes back to bite us regularly, to the extent
that we now have a ban on opening xlsx over the network in LO.

Both computers would be running windows 7 64 bit, the file would be on a
windows share, and the client would be running an up to date 64bit LO (last
time it happened this was 5.2.1.2. 

Typically the files would be between 1 and 2 mb, there would be between 10 and
30 tabsheets in them, and when the bug occurs, typically between 1 and 5
tabsheets would be blank. The time to open the file would be between 5 and 10
seconds.

Can't share the data but will try to reproduce using a test file.

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

Cor Nouws  changed:

   What|Removed |Added

   Keywords||dataLoss

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

--- Comment #11 from Cor Nouws  ---
we should start searching for someone able to do some network investigation?

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

Cor Nouws  changed:

   What|Removed |Added

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

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

--- Comment #10 from Eike Rathke  ---
@Cor:
I've no idea about Windows and Citrix and why it would happen there but not
locally or with another file format.
I can't investigate/reproduce because I don't have such environment.
Similar for MacOSX and network share.

Guesswork: .xlsx files consist of several zipped XML streams, among others one
separate stream for each sheet. Maybe when opening/unzipping the file to memory
for one (or more) of these streams an empty or otherwise undetected broken XML
stream is returned. This might depend on network share timing issues. However,
this is poking around and someone in the know having access to such environment
would have to check.

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

Cor Nouws  changed:

   What|Removed |Added

 CC||er...@redhat.com,
   ||markus.mohrhard@googlemail.
   ||com

--- Comment #9 from Cor Nouws  ---
@Eike, @Markus,

Any advice on what we may be able to test / help with?
Any (distant) bell whistling?

Thanks - Cor

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

Cor Nouws  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #8 from Cor Nouws  ---
(In reply to trevor from comment #7)
> I am experiencing the same issue on Mac OS X 10.11.5 when trying to load
> Excel files from a network share.

Thus marking as confirmed. Thanks!

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

tre...@fastfedora.com changed:

   What|Removed |Added

 CC||tre...@fastfedora.com

--- Comment #7 from tre...@fastfedora.com ---
I am experiencing the same issue on Mac OS X 10.11.5 when trying to load Excel
files from a network share.

All of the tabs except one loaded fine. The one tab contained nothing in it.
Another tab referenced data from the blank tab and had data in it, but this
appears to have been a saved calculation. When I tried to add a formula that
referenced the same cell, I got a value of 0. Also, when I changed detail rows
that should have updated the formula, the formula remained unchanged.

Luckily I made a backup of the file before saving it, since I am new to Libre
Office and didn't trust it wouldn't corrupt my .xlsx file. I copied the backup
to my local drive and opened it in Libre Office and it worked fine.

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

--- Comment #6 from m.a.riosv  ---
(In reply to Cor Nouws from comment #4)
> Hi Raal, Miguel
> 
> (In reply to m.a.riosv from comment #1)
.
> > view options for LO/calc doesn't change?
> 
> What options are you thinking about?
> 
I think I was thinking about OpenGL, lately it's another option to verify.
Better I don't ask about a clean profile. :)

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

Cor Nouws  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

--- Comment #4 from Cor Nouws  ---
Hi Raal, Miguel

(In reply to m.a.riosv from comment #1)
> a clear direct formatting on those sheet change anything?, or results are
> zeroes hidden by the format or the option. Are there cells with external
> links? 

Non of these.

> view options for LO/calc doesn't change?

What options are you thinking about?


(In reply to raal from comment #2)
> XLSX file on server -  you mean samba/windows sharing or webdav?

Sharing.
But I hear that it's not reliable local too.


(In reply to raal from comment #3)
> Please attach test file, thanks

Will ask again..

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

--- Comment #5 from Cor Nouws  ---
Note that, once confirmed, it will have to be marked with data loss.

File opens, some sheets (maybe) is not fully loaded, but users does not see
this, and saves the file, the data is simply gone...

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

raal  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 Ever confirmed|0   |1

--- Comment #3 from raal  ---
Please attach test file, thanks

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

raal  changed:

   What|Removed |Added

 CC||r...@post.cz

--- Comment #2 from raal  ---
XLSX file on server -  you mean samba/windows sharing or webdav?

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

Cor Nouws  changed:

   What|Removed |Added

 CC||c...@nouenoff.nl
Summary|FILEOPEN: XLSX file is  |FILEOPEN: XLSX file on
   |opened with some blanc tab  |server opens with some
   |pages on citrix server  |blank tab pages

-- 
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 97597] FILEOPEN: XLSX file on server opens with some blank tab pages

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 CC||miguelangelrv@libreoffice.o
   ||rg

--- Comment #1 from m.a.riosv  ---
Hi Cor,
a clear direct formatting on those sheet change anything?, or results are
zeroes hidden by the format or the option. Are there cells with external links?
view options for LO/calc doesn't change?

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