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.
[Dropped] Laptop freeze on use of 'Copy' command
-
- Posts: 4
- Joined: Wed Aug 31, 2022 11:08 pm
[Dropped] Laptop freeze on use of 'Copy' command
Last edited by MrProgrammer on Sun Oct 01, 2023 1:13 am, edited 1 time in total.
Reason: Dropped: No attachment to demonstrate the problem -- MrProgrammer, forum moderator
Reason: Dropped: No attachment to demonstrate the problem -- MrProgrammer, forum moderator
OpenOffice 4.1.10 on Windows 10
Re: Laptop freeze on use of 'Copy' command.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
- MrProgrammer
- Moderator
- Posts: 4944
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Laptop freeze on use of 'Copy' command
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.kennedypiano wrote: ↑Sat Sep 16, 2023 7:39 pm … to add more data to the graph …
=VLOOKUP(O218;ConversionTable;3)*O218
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.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).