If you save a spreadsheet that has too many columns (I used 500) to Microsoft Excel 97/2000/XP (.xls) format a warning window pops up that says "The document contains more ROWS than supported in the selected format. Additional ROWS were not saved." Emphasis mine. This should say "columns".
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian
I just checked with LibreOffice 3.5.4.2 Build ID: 350m1(Build:2) and this error still persists. As a side-note, there are four identical comments about closing the bug all sent within ten minutes of each other. Gil
thanks for re-testing :-) and yes the quadruple comments was an unfortunate accident.
So - we have both warnings as strings available; we need to be returning SCWARN_EXPORT_MAXCOL instead of MAXROW for this case to get the right string. I suspect code like this in sc/ is to blame that flattens any rangeoverflow to a MAXROW warning; prolly we want more semantic richness there. if( eRet == eERR_RNGOVRFLW ) eRet = SCWARN_EXPORT_MAXROW; a git grep for the SCWARN_EXPORT_MAXROW or RNGOVRFLW will show you the code to hack => EasyHack.
I've checked with build 3.7.0.0.alpha0+ I don't get any warning, but with 3.5.4.2 I can reproduce it systematic.
I had an .xls file (pure labels and personal data and this is why I can't attach it here), soemthing like an adressbook, not very large (105kb) with about 300 records (297 exactly) in 14 fields. I added the 298th record to the file using LibreOffice 4.1.0.4 running on Windows 7 64bit. Everything apparently was ok. When I tried to reopened it gave me: "Error in message warning that the column limit was exceeded for MS-Excel format" and it showed me only 4-5 records. So I removed LibO version 4.1.0 and remounted LibO 4.0.4. The "currupted" file did not work also in 4.04, so I restared from the original file 4.0.4, I added the 298th record again and I saved the file. When I reopened it in LibO 4.0.4 was ok. Topoldo
Created attachment 85825 [details] console logs with master sources On pc Debian x86-64 with master sources updated today, I tried to reproduce the problem. I created a brand new file with 500 columns then saved it as ods => ok then I saved it as xls file=> no warnings!! I attached the console logs with each step I made.
adding LibreOffice developer list as CC to unresolved EasyHacks for better visibility. see e.g. http://nabble.documentfoundation.org/minutes-of-ESC-call-td4076214.html for details
Removing comma from whiteboard (please use a space to delimit values in this field) https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Whiteboard#Getting_Started
Hi.. I hope to give this a try. Im really new here. Where should I start looking?
Hi, Im a beginner to the Libreoffice development and this is my first hack. I have no idea what files to look at to address this issue. Can anyone please help me? And is there documents I can refer to? Thank You On Wed, Jan 22, 2014 at 1:19 PM, <bugzilla-daemon@freedesktop.org> wrote: > *Comment # 14 <https://bugs.freedesktop.org/show_bug.cgi?id=40694#c14> > on bug 40694 <https://bugs.freedesktop.org/show_bug.cgi?id=40694> from > Ayantha Randika <randika.deultima@gmail.com> * > > Hi.. I hope to give this a try. Im really new here. Where should I start > looking? > > ------------------------------ > You are receiving this mail because: > > - You are on the CC list for the bug. > > > _______________________________________________ > LibreOffice mailing list > LibreOffice@lists.freedesktop.org > http://lists.freedesktop.org/mailman/listinfo/libreoffice > >
Ayantha, you can use http://opengrok.libreoffice.org/ for Code Search. Pasting the wrong error message there might be a good start.
(In reply to comment #16) > Ayantha, you can use http://opengrok.libreoffice.org/ for Code Search. > Pasting the wrong error message there might be a good start. Thank You very much Samuel!
It looks like LibreOffice Version: 4.3.0.0.alpha0+ doesnt give any warning when tring to save a spreadsheet that has too many columns as a (.xls).LibreOffice 3.5.7.2 gives wrong warning as mentioned above. But Version: 4.3.0.0.alpha0+ gives nothing.
So I'm closing this bug as per Comment 11 and Comment 18 If it still persists, please reopen.
I think I have corrected both errors. Now it warns and gives the correct warning. I will submit the patch for review as soon as I figure out the "Sending a Patch to Gerrit" instructions. On Thu, Jan 23, 2014 at 1:25 AM, <bugzilla-daemon@freedesktop.org> wrote: > Samuel M. <s.mehrbrodt@gmail.com> changed bug 40694<https://bugs.freedesktop.org/show_bug.cgi?id=40694> > What Removed Added Status REOPENED RESOLVED Resolution --- WORKSFORME > > *Comment # 19 <https://bugs.freedesktop.org/show_bug.cgi?id=40694#c19> > on bug 40694 <https://bugs.freedesktop.org/show_bug.cgi?id=40694> from > Samuel M. <s.mehrbrodt@gmail.com> * > > So I'm closing this bug as per Comment 11 <https://bugs.freedesktop.org/show_bug.cgi?id=40694#c11> and Comment 18 <https://bugs.freedesktop.org/show_bug.cgi?id=40694#c18> > If it still persists, please reopen. > > ------------------------------ > You are receiving this mail because: > > - You are on the CC list for the bug. > > > _______________________________________________ > LibreOffice mailing list > LibreOffice@lists.freedesktop.org > http://lists.freedesktop.org/mailman/listinfo/libreoffice > >
I have created a patch to correct this bug. https://gerrit.libreoffice.org/#/c/7618/5 On Thu, Jan 23, 2014 at 1:40 AM, <bugzilla-daemon@freedesktop.org> wrote: > *Comment # 20 <https://bugs.freedesktop.org/show_bug.cgi?id=40694#c20> > on bug 40694 <https://bugs.freedesktop.org/show_bug.cgi?id=40694> from > Ayantha Randika <randika.deultima@gmail.com> * > > I think I have corrected both errors. Now it warns and gives the correct > warning. I will submit the patch for review as soon as I figure out the > "Sending a Patch to Gerrit" instructions. > > > On Thu, Jan 23, 2014 at 1:25 AM, <bugzilla-daemon@freedesktop.org> wrote: > > > Samuel M. <s.mehrbrodt@gmail.com> changed bug 40694 <https://bugs.freedesktop.org/show_bug.cgi?id=40694><https://bugs.freedesktop.org/show_bug.cgi?id=40694> > > What Removed Added Status REOPENED RESOLVED Resolution --- WORKSFORME > >> *Comment # 19 <https://bugs.freedesktop.org/show_bug.cgi?id=40694#c19> <https://bugs.freedesktop.org/show_bug.cgi?id=40694#c19> > > on bug 40694 <https://bugs.freedesktop.org/show_bug.cgi?id=40694> <https://bugs.freedesktop.org/show_bug.cgi?id=40694> from > > Samuel M. <s.mehrbrodt@gmail.com> * > >> So I'm closing this bug as per Comment 11 <https://bugs.freedesktop.org/show_bug.cgi?id=40694#c11> <https://bugs.freedesktop.org/show_bug.cgi?id=40694#c11> and Comment 18 <https://bugs.freedesktop.org/show_bug.cgi?id=40694#c18> <https://bugs.freedesktop.org/show_bug.cgi?id=40694#c18> > > If it still persists, please reopen. > >> ------------------------------ > > You are receiving this mail because: > >> - You are on the CC list for the bug. > > > > >> _______________________________________________ > > LibreOffice mailing list > > LibreOffice@lists.freedesktop.org > > http://lists.freedesktop.org/mailman/listinfo/libreoffice > > > > > > ------------------------------ > You are receiving this mail because: > > - You are on the CC list for the bug. > > > _______________________________________________ > LibreOffice mailing list > LibreOffice@lists.freedesktop.org > http://lists.freedesktop.org/mailman/listinfo/libreoffice > >
Ayantha Randika committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=28e9efe5b4d6699b33498953e798f76008edaeda fdo#40694 - Error in message when truncating col/row numbers in calc The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Migrating Whiteboard tags to Keywords: (EasyHack DifficultyBeginner SkillCpp TopicCleanup) [NinjaEdit]
Remove LibreOffice Dev List from CC on EasyHacks (curtailing excessive email to list) [NinjaEdit]