[Libreoffice-bugs] [Bug 113611] The data could not be loaded completely because the maximum number of rows per sheet was exceeded

[bugzilla-daemon]

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

BogdanB  changed:

   What|Removed |Added

Summary|The data could not be   |The data could not be
   |loaded completely because   |loaded completely because
   |the maximum number of rows  |the maximum number of rows
   |per sheet was exceeded. |per sheet was exceeded

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 113611] The data could not be loaded completely because the maximum number of rows per sheet was exceeded.

[bugzilla-daemon]

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

BogdanB  changed:

   What|Removed |Added

 Blocks||148038
 CC||buzea.bog...@libreoffice.or
   ||g


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=148038
[Bug 148038] [META] Calc spreadsheets with more than 1048576 rows
-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 113611] The data could not be loaded completely because the maximum number of rows per sheet was exceeded.

[bugzilla-daemon]

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

--- Comment #9 from Anton  ---
I would say, rather than a filter, the maximum number of row restriction should
be dropped. I just tried to open a file, that wasn't even 70 MB and couldn't
open it. We are in 2019. My computer has 20GB of ram. And I cannot open a 70 MB
file because of some arbitrary row restriction?! Really!? (I have read the bug
on the maximum column number restriction and understand that there might be
some underlying technical debt issues that make this difficult to fix, but from
a user perspective this really is ridiculous behaviour. I hope it will get
fixed.)

-- 
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 113611] The data could not be loaded completely because the maximum number of rows per sheet was exceeded.

[bugzilla-daemon]

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

--- Comment #8 from Boris Bahes  ---
Excel uses Query Editor.

-- 
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 113611] The data could not be loaded completely because the maximum number of rows per sheet was exceeded.

[bugzilla-daemon]

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

--- Comment #7 from Boris Bahes  ---
Created attachment 137535
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137535=edit
Excel Query Editor  #2

-- 
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 113611] The data could not be loaded completely because the maximum number of rows per sheet was exceeded.

[bugzilla-daemon]

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

--- Comment #6 from Boris Bahes  ---
Created attachment 137534
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137534=edit
Excel Query Editor  #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 113611] The data could not be loaded completely because the maximum number of rows per sheet was exceeded.

[bugzilla-daemon]

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

--- Comment #5 from Eike Rathke  ---
Filter how? What does Excel do there?

-- 
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 113611] The data could not be loaded completely because the maximum number of rows per sheet was exceeded.

[bugzilla-daemon]

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

--- Comment #4 from Boris Bahes  ---
I've seen this suggestion on different forums. But using Cals seems more
intuitive for end users.

-- 
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 113611] The data could not be loaded completely because the maximum number of rows per sheet was exceeded.

[bugzilla-daemon]

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

V Stuart Foote  changed:

   What|Removed |Added

   Keywords||needsDevEval
   Priority|medium  |low
 Status|UNCONFIRMED |NEW
 CC||er...@redhat.com,
   ||kohei.yosh...@collabora.com
 Ever confirmed|0   |1
 OS|Windows (All)   |All

--- Comment #3 from V Stuart Foote  ---
Sure, some LO testing prior to import filter parsing (e.g. test with wc -l)
might be feasible. But that really is rather an abusive data set to be pushing
into a spread sheet. I would not want to try to work with a sheet that large
;-)

Would think loading to Base on detection would be a smarter route. Filtering
records would be trivial at that point.

@Eike, Kohei?

-- 
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 113611] The data could not be loaded completely because the maximum number of rows per sheet was exceeded.

[bugzilla-daemon]

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

--- Comment #2 from Boris Bahes  ---
250M 
just trying to load utility that logged for week traffic on server with single
client connected.

-- 
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 113611] The data could not be loaded completely because the maximum number of rows per sheet was exceeded.

[bugzilla-daemon]

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

V Stuart Foote  changed:

   What|Removed |Added

 CC||vstuart.fo...@utsa.edu

--- Comment #1 from V Stuart Foote  ---
MAX row count is  1,048,576, or 2^20 rows

Do you really have a CSV that large? Otherwise the CSV is misformatted.

=-ref-=
https://wiki.documentfoundation.org/Faq/Calc/022

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