[Dropped] Laptop freeze on use of 'Copy' command

[kennedypiano]

In an ODS file, I use a dedicated sheet is used to hold the data for a graph and the display of that graph. When I use the 'copy' command to add more data to the graph by copying the following equation "=VLOOKUP(O218;ConversionTable;3)*O218" to another cell, the spreadsheet (and hence the computer) freezes. I then have to use Task Manager to close Open Office.

COPY TEST.ods

(9.73 KiB) Downloaded 47 times

[RoryOF]

See

viewtopic.php?p=534803#p534803

and subsequent posts in that thread for possible solutions.

[MrProgrammer]

… to add more data to the graph …
=VLOOKUP(O218;ConversionTable;3)*O218

Attachment COPY TEST.ods does not contain a chart. It does not contain defined name ConversionTable. If setting Windows key → Settings → System → Clipboard → Suggested Actions → Off does not correct the difficulty you're having attach a spreadsheet containing that formula. Indicate which cell in which sheet contains the formula you want to copy and which cell in which sheet is to receive the copy. I will not help further without that information.

202309231457.gif (28.93 KiB) Viewed 2684 times

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.