Description of problem: Can not create autooutline on the cell range contains formula. Version-Release number of selected component (if applicable): openoffice.org-2.3.0-6.11.el5 How reproducible:everytime Steps to Reproduce: 1. Launch the oocalc 2. Create a table like this: January February March 1st Quarter April May June 2nd Quarter 100 200 300 =SUM(A2;B2;C2) 400 500 600 =SUM(E2;F2;G2) 3. Select the cell with formula,click the Data->Outline->AutoOutline Actual results: After the step 3, nothing will happen. Expected results: The table should be grouped into two quarters Additional info:
Rather than using =SUM(A2;B2;C2) try using a direct range instead e.g. =SUM(A2:C2)
Created attachment 347539 [details] backported patch
Verified with openoffice.org-3.1.1-19.1.el5 on Red Hat Enterprise Linux 5Client - i386, x86_64 Red Hat Enterprise Linux 5Server-DPAS - i386, x86_64 1.Launch the oocalc 2. Create a table like this: January February March 1st Quarter April May June 2nd Quarter 100 200 300 =SUM(A2;B2;C2) 400 500 600 =SUM(E2;F2;G2) 3. Select the cell with formula,click the Data->Group and Outline->AutoOutline 4.It can outline the cells to two quarters now. Verified passed.
An advisory has been issued which should help the problem described in this bug report. This report is therefore being closed with a resolution of ERRATA. For more information on therefore solution and/or where to find the updated files, please follow the link below. You may reopen this bug report if the solution does not work for you. http://rhn.redhat.com/errata/RHBA-2010-0274.html