Spreadsheet: cut & paste value results in error (reference)

Desktop editors
1

I want to report a bug.

Worksheet “export” contains a lot of cell calculated on values from other worksheets.

  1. Copying an area of theses cells on worksheet “export”
  2. Pasting into another worksheet “result” (same file or other file).
  3. Choosing as an paste option “values and all formatting”
  4. Pasted cells are showing error “#Bezug” (German for reference).
    For bug reports, provide the steps to reproduce and if possible a minimal demo of the problem.
  5. Expected behavior: pasting value and all formatting should result in cells with text and numbers.

OS version: macOS 15.7.7
App version: Community 9.4.0
Downloaded from: ONLYOFFICE website

2

Hi @to.gu.de,

Welcome to the Community!

We tried to reproduce this but couldn’t get the #REF error with that paste option. Could you attach the file (or a simplified version) where this happens? That would help us reproduce the issue exactly.

Thank you!

3

Hi Nurullo,

yes, sure. I attached the file.

Some comments on the file:

  • Sheet “Plan”: the data in the way, I received.
  • Sheet “Lookup”: used for formatting in colum A in sheet “Plan”
  • Sheet “Export”: the sheet I used for translate the table from sheet “Plan”

In the past, I copied the cells from block A1 to I713 (on sheet “Export”) and pasted (values/format) into an empty worksheet and saving this as csv-file.

The problem: pasting these cells returns into an error.

I have done cut & paste (values/format) into another sheet for your convinience.

Kind regards, Tom

D26-09.xlsx (94.5 KB)

1 Like
5

Hi @to.gu.de,

Thanks for the file, that’s exactly what we needed.
We’re looking into it and will update the thread once we know more.