Ask Your Question
1

Calc: Formulas not working when copying work sheet

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

ahallam gravatar image ahallam
11 2

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: 3.6.1.2.

delete close flag offensive retag edit

Comments

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 ( 2012-09-17 22:40:18 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

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

qubit gravatar image qubit flag of United States
5693 3 48 41

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".

Thanks!

link delete flag offensive edit
0

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

mariosv gravatar image mariosv flag of Spain
4644 20 46

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?

link delete flag offensive edit

Login/Signup to Answer

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow

subscribe to rss feed

Stats

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

Seen: 212 times

Last updated: Feb 23