David Genest, thank you for taking the time to report this bug and helping to make Ubuntu better. The issue you are reporting is an upstream one and it would be nice if somebody having it could send the bug to the developers of the software by following the instructions at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about the status. Thanks in advance.
** Description changed: - I want to autofill a series of dates, but in merged cells. I need to have a header row that is composed of 4 merge cells that states dates incrementally: - E.G. : + 1) lsb_release -rd + Description: Ubuntu 12.04 LTS + Release: 12.04 - -------------------------------------------- - |------------------ - Date |------------------ - |------------------ - -------------------------------------------- - I want to |------------------ - autofill |------------------ - increments here |------------------ - --------------------------------------------- + 2) apt-cache policy libreoffice-calc + libreoffice-calc: + Installed: 1:3.5.2-2ubuntu1 + Candidate: 1:3.5.3-0ubuntu1 + Version table: + 1:3.5.3-0ubuntu1 0 + 500 http://us.archive.ubuntu.com/ubuntu/ precise-updates/main i386 Packages + *** 1:3.5.2-2ubuntu1 0 + 500 http://us.archive.ubuntu.com/ubuntu/ precise/main i386 Packages - right now when I use the autofil feature, the increments are 4 instead - of what I would expect to be 1 (because there are now 1 merged cell and - not 4 separate cells). I tried to use the fill series function, but it - fools the spreadsheet and fills each row, as if the cells were not - merged. + 3) What is expected to happen in Calc via the Terminal: - Is there a way to accomplish this without having to enter each date - manually ? + cd ~/Desktop && wget + https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/153150/+attachment/3142909/+files/example.ods + && localc --nologo example.ods - Thank you for your time, + is when one highlights the merged cells A1-A5 -> use the mouse to grab + the bottom right corner of the cells -> drag it to cell A10, cells A6-10 + are merged, and the number increments to 2 in A10. Just as it does in + Excel 2010. A screenshot of how it should look in Calc: + https://launchpadlibrarian.net/12607059/autoFillExpected.png . - David. + 4) What happens instead is cells A6-A10 are not merged, and each cell + has a number incremented. ** Summary changed: - AutoFill not working down merged cells + AutoFill not filling and incrementing merged cells ** Changed in: libreoffice (Ubuntu) Importance: Undecided => Medium ** Changed in: libreoffice (Ubuntu) Status: New => Triaged ** Also affects: df-libreoffice Importance: Undecided Status: New ** Attachment removed: "wwt_week20.xls" https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/153150/+attachment/2144727/+files/wwt_week20.xls -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/153150 Title: AutoFill not filling and incrementing merged cells Status in LibreOffice Productivity Suite: New Status in The OpenOffice.org Suite: Confirmed Status in “libreoffice” package in Ubuntu: Triaged Status in “openoffice.org” package in Ubuntu: Won't Fix Bug description: 1) lsb_release -rd Description: Ubuntu 12.04 LTS Release: 12.04 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.5.2-2ubuntu1 Candidate: 1:3.5.3-0ubuntu1 Version table: 1:3.5.3-0ubuntu1 0 500 http://us.archive.ubuntu.com/ubuntu/ precise-updates/main i386 Packages *** 1:3.5.2-2ubuntu1 0 500 http://us.archive.ubuntu.com/ubuntu/ precise/main i386 Packages 3) What is expected to happen in Calc via the Terminal: cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/153150/+attachment/3142909/+files/example.ods && localc --nologo example.ods is when one highlights the merged cells A1-A5 -> use the mouse to grab the bottom right corner of the cells -> drag it to cell A10, cells A6-10 are merged, and the number increments to 2 in A10. Just as it does in Excel 2010. A screenshot of how it should look in Calc: https://launchpadlibrarian.net/12607059/autoFillExpected.png . 4) What happens instead is cells A6-A10 are not merged, and each cell has a number incremented. To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/153150/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
