Copy only visible cells

• John Leonard 13 oct 2023, 23:35 (hace 14 mes)

  ★ ★ ★ ☆ ☆

  sometimes it works but sometimes it does this with subtotals
  Item 1 Sum -7058.84
  Item 2 Sum #REF!
  Item 3 Sum #REF!
  Grand Sum -7058.84
  

• Timur Gadzo 25 oct 2022, 12:33 (hace 2 año)

  ☆ ☆ ☆ ☆ ☆

  No need for this anymore, as from LO 7.2 there is new "Select Visible Cells" so that only that can be copied.
  As in Help https://help.libreoffice.org/latest/en-US/text/scalc/guide/cellcopy.html

• bill pernell 6 oct 2022, 16:04 (hace 2 año)

  ★ ☆ ☆ ☆ ☆

  Does not work at all. LibreOffice version 7.4.1.2 on MacOS Monterey (12.4). After several crashes trying to get the extension installed, i now have a button and menu item for "Copy only visible cells," however when i click that and try to paste anywhere else (another sheet or a plain text document), the hidden rows are pasted into the new document, just like before installed the extension.

• Milen Iliev 20 jul 2022, 19:58 (hace 2 año)

  ★ ★ ★ ★ ★

  worked for me, using Version: 6.4.7.2 on ubuntu. Had to wait a minute for it to sort through about 4000 row, if I pasted too soon, it didn't work.

• Michał Faflik 10 sept 2021, 15:38 (hace 3 año)

  ★ ★ ☆ ☆ ☆

  I didn't check other use cases but in case of subtotals it simply doesn't work. the result is in #REF error in pasted cells instead of values.
  Version: 7.0.6.2 (x64)
  Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
  CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
  Locale: pl-PL (pl_PL); UI: pl-PL
  Calc: threaded

• Paul Janzen 8 jul 2021, 3:56 (hace 3 año)

  ★ ★ ★ ★ ★

  I am using LibreOffice Calc 7.1.4.2 (x64) on Linux Mint 20.1 and for me it works exactly as described. Congratulations to the developers.

• Paul Madley 8 may 2021, 20:14 (hace 4 año)

  ★ ★ ★ ★ ★

  I'm running Calc 6.4.7.2 on Fedora. It did exactly what I needed to. Only ~600 rows but it worked fine.

• Joe Public 17 mar 2021, 21:22 (hace 4 año)

  ★ ☆ ☆ ☆ ☆

  It doesn't work. My LibreOffice is version Versión: 6.4.3.2 (x64) and don't do what it is promised. If you have filtered rows it copy and paste well, but with hidden columns it doesn't copy well. With all my respects to all the collaborators of this software, LibreOffice is a very good tool, but I don't know how this USEFULL function isn't integrated into the "LibreOffice" nucleus for a long time. When you filter rows or hide columns an later want to copy what you see in your screen, why libreOffice copy what you don't see? It has no sense. Thanks.

• David K 27 feb 2021, 17:12 (hace 4 año)

  ★ ★ ☆ ☆ ☆

  Seems to work OK with a small number of cells but trying to copy 5K filtered cells from a 50K row spreadsheet didn't work. Libreoffice just ran at 100% CPU for minutes and nothing was in the clipboard.

  • Paul Madley 8 may 2021, 20:15 (hace 4 año)

    That's my impression. I did notice the spinny "somethings happening" cursor for a split second, when I clicked "Copy only visible cells" on about 600 rows.

• denis 2 nov 2020, 7:19 (hace 4 año)

  ★ ☆ ☆ ☆ ☆

  no, ir doesn't work with cells, linked with neighbors. I installed it only to solve this case...

Nadie comentó en esta página todavía.