[Bug 46263] Cannot copy forumulas in tables (word processing)

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=46263

Sreedevi <sr...@progressive.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |sreedevi_gatiganti@progress
                   |                            |ive.com

--- Comment #3 from Sreedevi <sr...@progressive.com> ---
I was able to replicate the bug on windows7 and Open Office Writer version
4.0.1. The original bug was identified in version2.0 Beta. 
Steps to recreate the bug –
1.    Open Office Writer 4.0.1 app on you system
2.    From the menu bar, select Insert>Table.’ Insert Table’ window is
displayed
3.    On Insert Table window, Select Columns & Rows = 5, in Size section.
4.    Click OK button. A table with 5 rows and 5 columns is inserted into
Writer document.
5.    Enter the following values in first row – Row1Col1 =1; Row1Col2 =2;
Row1Col3 =3; Row1Col4 =4
6.    Click in Row1col5(5th cell in 1st row) and enter formula =sum(<A1:D1>)
and hit Enter
7.    Alternatively to insert formula into the 5th cell of Row1, you can click
on “Sigma” icon on table toolbar docked near the upper left hand corner and hit
enter.
8.    5th cell in Row1 will now have a value = 10. 
9.    Copy the value from 5th cell of Row1 and paste it into 5th cell of all
rows.
Actual Result – Value =10 was pasted into rest of the cells in column5. I.e.
Formula from Row1 cell 5 was not copied to the rest of the cells in Column5.
Expected result – User should be able to copy that formula to all of the cells
in the fifth row in 
the remaining columns, such that in each row, the fifth cell will hold the sum 
of the first four cells for that row.

Follow –up tests – 
1.    I replicated the bug in a similar application (MS Word) and found out
that the functionality to insert formulas in a table is not available.
2.    I tried to copy and paste the table I created in Writer to Calc and
noticed that formulas were not copied.
3.    Within Calc, I tried to create a same table and inserted formula in Row1
ColumnE and copied and pasted the cell value to remaining cells in ColumnE. The
formulas were successfully copied. 

Search for any duplicate bugs – I found a bug which seems like its related, but
is not a duplicate - Bug 50177 -Inherit cell format and formula when adding new
rows to a text table

After trying to replicate the bug and testing various followup tests, I think
this feature if fixed would help the users with managing formulas in tables
much easily.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.