Bug 94118 - Copy a sheet before it does not keep the formulas
Summary: Copy a sheet before it does not keep the formulas
Status: RESOLVED DUPLICATE of bug 85538
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-09-11 02:49 UTC by Paulo da Silva
Modified: 2015-09-12 08:56 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example (12.29 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-09-11 02:49 UTC, Paulo da Silva
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Paulo da Silva 2015-09-11 02:49:43 UTC
Created attachment 118594 [details]
Example

Copying a sheet before itself does not keep the formulas' references as it does when the copy is to after itself.

In the attached examples just copy "Qua" to after and before itself.
To after the copy is correct while to before is not.

LO calc 5.0.1.2.
Comment 1 m_a_riosv 2015-09-11 22:23:17 UTC
Hi @Paulo, thanks for reporting.

I think not such issue, the formulas in QUA are relatives to Rec (not $Rec.), copying before they change accordantly to S3, copying before doesn't change because Rec it's the last sheet and only could be changed to an error reference.
Comment 2 Paulo da Silva 2015-09-12 01:55:45 UTC
(In reply to m.a.riosv from comment #1)
> Hi @Paulo, thanks for reporting.
> 
> I think not such issue, the formulas in QUA are relatives to Rec (not
> $Rec.), copying before they change accordantly to S3, copying before doesn't
> change because Rec it's the last sheet and only could be changed to an error
> reference.

No. The usual procedure (excel, gnumeric, google doc and other venerable spreadsheet programs) is to maintain all references (including those of the charts) the same when copying a sheet.

Furthermore, I see no use in changing references except creating all sorts of inconsistencies as that of "last sheet". References are to be kept.

Regards.
Paulo
Comment 3 Paulo da Silva 2015-09-12 04:28:23 UTC
Just a clarification: When I said "all references" I meant "all external references". Internal references should be changed to point to the new sheet.

The point is: The new sheet should mimic exactly the original sheet behaviour.
Comment 4 m_a_riosv 2015-09-12 08:56:29 UTC
When yes, when no?

If the issue is with external link then this seems a duplicate.

If you are not agree reopen it.

*** This bug has been marked as a duplicate of bug 85538 ***