https://issues.apache.org/ooo/show_bug.cgi?id=46263
Sreedevi <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |sreedevi_gatiganti@progress | |ive.com --- Comment #3 from Sreedevi <[email protected]> --- 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.
