u/Antoinedeloup

Hi there! I'm making a sheet that is full of conditional formats which only affect some columns and ranges. However, during work i have to constantly copy and paste text from a website and from one part of the sheet to another, which messes up the ranges (instead of conditional format 1 affecting range C1:C100, after pasting on C50 i get a range of C1:C49,C51:100 for example).

Eventually, this makes file slow to work with, and also messes some of the non-conditional formatting the sheet has; ends up being a mix and match of colors and fonts.

Generally, when i copy a large amount of cells, i do a paste special with CTRL+Shift+V, (Only pasting text/numbers and comments) + Enter to get past the dialog screen, however this is impractical for most copying i do on my workflow.

I was thinking i could change CTRL+V to trigger the Paste Special Function and CTRL+Shift+V for the normal paste, but i still can't ignore the paste special dialog, so it still needs an additional trigger to simply paste something.

Is there a way to have that pop-up window NOT trigger? I don't ever change the paste special properties on this machine.

On the same subject - Is there any other way to work with a file with formats, conditional formats, formulas, etc. and make any kind of copy/pasting operation not mess with those?

Maybe i am not understanding how styles work, or formats - but if i change the default style to have a custom font/borders/etc, no matter if i clear direct formatting, or CTRL+X the cell, the format will remain the same - but if i do this with a cell with another style applied, it will go back to the default style.

Is it possible to replicate this behaviour but for custom styles? so, no matter if i CTRL+X or CTRL+M a given cell, they go back to the predetermined style per range.

I am creating this sheet on Fedora Workstation 44, for use in both Fedora and Win10 and Win11.

Some details:

LibreOffice Calc Version: 26.2.3.2 (X86_64)

Build ID: 620(Build:2)

CPU threads: 8; OS: Linux 7.0; UI render: default; VCL: gtk3

Locale: es-AR (en_US.UTF-8); UI: en-US

Calc: threaded

For some context: The purpose of the sheet is to manage several inventories corresponding to a mobile workforce. the items have unique IDs scanned with barcodes. These items are then consumed, and marked with another ID next to them, which is acquired through a work website. This is where the main copy/pasting operations happen. After all of the IDs have been pasted, the inventory is copied to an empty space on the right (only with values+comments) which already has formatting and conditional formatting applied. Then, on the newly pasted inventory, i delete the consumed items and add new ones. These updated inventories get then pasted (only values+comments) on a new sheet with a template contanining the styles, conditional formatting and such.

Hi everyone. So far i'm loving Niri, and it works up really nice for me. One of the key things i like is that i can manage all my windows easily through my keyboard, without the need of using a mouse at all. Tiling ensures no window ever gets in front of another one, infinite horizontal space for managing windows that need space each, paired with the vertically arranged workspaces, it seems right at home with keys for this setup, extremely intuitive to me.

However, i have installed it with Dank Material Shell, which while it has met most of my needs as a shell, (very few bugs) has a nice customizable bar and matugen works wonderfully, nice integration with Niri too for things like border color with matugen, distance from bar, and some ui controls for things like border gaps and whatnot - but while i can map some system menus from widgets and launchers, there's many dms interfaces where i can only interact properly with a mouse. Not just the widgets for the control center (widget for bluetooth, wifi, battery etc.) but also the dms settings doesn't seem to recognize other keys apart from the search bar, so i cannot tab around the configurations, or move with arrow keys.
While i prefer this way of using my pc, i'm no expert who can entirely use their entire system through the terminal, and i still like some interactable GUI/TUI. I still need a visual shell for managing system controls like wifi, bluetooth, notifications and stuff. I'm looking for something you can use entirely with your keyboard, with hints, arrow keys or tabbing.

I'd like to know what kind of shells do you guys use with Niri.

Hi there! after being tired of paying a subscription to fuckass companies, i've decided to download and start my own collection to play locally.

I've been using Azul Box, which allows me to quickly download entire youtube playlists as songs, but it sometimes messes up the metadata - Confuses artists name, tags all artists as the first video listed, or every song gets the image from the first one.

I want to be able to find them on my app by artist name, album and such (I'm using Gapless, lovely interface and works great) but i'm annoyed at the way the metadata gets messed up.

How do y'all get your music, with its proper metadata?? Thanks in advance!