Ask Your Question

Calc: Formulas not working when copying work sheet [closed]

asked 2012-09-17 21:45:07 +0200

ahallam gravatar image

updated 2015-10-23 05:18:18 +0200

Alex Kemp gravatar image

I seem to be having an issue when we create a copy of a work sheet in Calc. When we create a copy of a work sheet with all the formulas and data, the formulas are not working on the new page.

We can go in and see that the formula is correct (ie: =M4/N4) but there is no calculation done with there being data in both M4 and N4.

We have also tired copy and pasting all of the data in the work sheet into a new work sheet and we still seem to have the same issue.

Any input would be greatly appreciated.

We are running the most current version:

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-23 05:18:32.834377


We are right clicking on a tab, selecting "Move/Copy Sheet", then selecting copy and giving it a new name for the tab. Once we go into that new tab we are having this issue.

This is all in one file that we are doing this and the file formant is ODF Spreadsheet (.ods).

ahallam gravatar imageahallam ( 2012-09-17 22:40:18 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2013-02-23 06:56:49 +0200

qubit gravatar image

Hi @ahallam,

Could you please test this against a install of the latest release of LO?

If the latest release doesn't help, please consider filing a bug about this problem, and providing a list of steps that can reproduce it. The QA team will be happy to help you track down this issue!

Please post a link to any bugs you file in a comment below using the format "fdo#123456".


edit flag offensive delete link more

answered 2012-09-17 21:53:00 +0200

m.a.riosv gravatar image

I can't find this issue. Copying trough Right-Click on tab, Copy ... Ctrl while drag the sheet. What is the file format? How are you copying the sheet?

edit flag offensive delete link more

Question Tools


Asked: 2012-09-17 21:45:07 +0200

Seen: 670 times

Last updated: Feb 23 '13