#LibreOfficeCalc

0 posts0 participants0 posts today

C.Just ran into a brutal <a href="https://mindly.social/tags/UI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#UI</a> / <a href="https://mindly.social/tags/UX" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#UX</a> problem in LibreOffice Calc, on a Debian bookworm system, fully up to date.1. Decide to print spreadsheet 2. Open print dialog 3. Preview is in the left pane, options in the right. 4. Scroll down in the options pane to find an option near the bottom. 5. Change setting, or not. 6. Scroll back up to the top of the options pane, using the pointing device vertical scroll wheel. 7. If the "number of copies" scrollbox happens to pass under the mouse pointer, it will rapidly increase the number of copies. It's not particularly obvious this is happening; it's easy to miss the value is changing. 8. Move the mouse pointer slightly up and scrolling the options pane continues. 9. Click "print".Voila! 23 copies of what you wanted to print a single copy of.I actually ran into this while trying to debug a totally different UI / UX bug 😱 <a href="https://mindly.social/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LibreOffice</a> <a href="https://mindly.social/tags/LibreOfficeCalc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LibreOfficeCalc</a> <a href="https://mindly.social/tags/Calc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Calc</a> <a href="https://mindly.social/tags/spreadsheet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheet</a> <a href="https://mindly.social/tags/linux" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#linux</a> <a href="https://mindly.social/tags/Debian" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Debian</a> <a href="https://mindly.social/tags/bookworm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#bookworm</a> <a href="https://mindly.social/tags/printing" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#printing</a> <a href="https://mindly.social/tags/CUPS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#CUPS</a> <a href="https://mindly.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OpenSource</a> <a href="https://mindly.social/tags/FreeSoftware" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#FreeSoftware</a>

NormWhy does setting the column width to 1cm and the row height to 1cm not result in square cells?<a href="https://fosstodon.org/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LibreOffice</a> <a href="https://fosstodon.org/tags/LibreOfficeCalc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LibreOfficeCalc</a> <a href="https://fosstodon.org/tags/Spreadsheet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Spreadsheet</a>

Simon DeutschlIch habe in LibreOffice Calc eine Spalte in der verschiedene Ausprägungen öfters vorkommen. Ich würde gerne mittels Formel (Funktion) alle Ausprägungen auf einem anderen Tabellenblatt auflisten. Ich möchte ungerne eine Pivotabelle dazu benutzen. Gibt es eine Funktion, mit der ich jede Ausprägung einmal ausgeben kann? Per Suchmaschine habe ich leider nichts passendes gefunden.<a href="https://troet.cafe/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LibreOffice</a> <a href="https://troet.cafe/tags/Calc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Calc</a> <a href="https://troet.cafe/tags/LibreOfficeCalc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LibreOfficeCalc</a>

luiseme ⁂<a href="https://mastodon.social/@arredro" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@arredro</a>, como <a href="https://masto.es/tags/hasercorp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#hasercorp</a> tiene recursos de sobra para promocionarse, yo prefiero recomendarte este tutorial de <a href="https://masto.es/tags/LibreOfficeCalc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LibreOfficeCalc</a> 👉 <a href="https://www.edu.xunta.gal/centros/iesrosais2/aulavirtual/pluginfile.php/16607/mod_resource/content/14/tutorial_LOC_v7_v2.0.pdf" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.edu.xunta.gal/centros/iesrosais2/aulavirtual/pluginfile.php/16607/mod_resource/content/14/tutorial_LOC_v7_v2.0.pdf</a> <a href="https://masto.es/tags/FOSS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#FOSS</a> <a href="https://masto.es/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LibreOffice</a>

Amᵃᵖanda 🔜 HackW/E@LinuxHotelAm I right in thinking that <a href="https://en.osm.town/tags/Excel" class="mention hashtag" rel="tag">#Excel</a> doesn't have a “case if X then A, if Y then B, If Z then C ...” function? I need to do lots of nested `IF(...)` functions right?(I'm sure same Q applies to <a href="https://en.osm.town/tags/LibreOfficeCalc" class="mention hashtag" rel="tag">#LibreOfficeCalc</a>...)

Paul 🏳️‍🌈 🇺🇦🇵🇸🇬🇱<a href="https://mastodonapp.uk/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LibreOffice</a> - The compatibility is incredible. This is version 5.4 in XP loading a spreadsheet edited in 24.2. Same goes for Writer <a href="https://mastodonapp.uk/tags/LibreOfficeCalc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LibreOfficeCalc</a> <a href="https://mastodonapp.uk/tags/WindowsXP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#WindowsXP</a> <a href="https://mastodonapp.uk/tags/RetroComputing" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#RetroComputing</a>

Kajo 📷 :mastolove:Kurz noch die Arbeit von gestern vervollständigen wollen... und realisiert, dass diese komplett umsonst war. Knapp 6 Stunden! Ich (Doofi 🤪) hab in einer .csv gearbeitet und diese wie ne Excel-Tabelle gehandhabt, ohne mir dabei etwas zu denken. Heißt: Weitere Arbeitsblätter angelegt.Ich hab gespeichert, aber nun ist nur noch ein Arbeitsblatt vorhanden.Ist nun wirklich alles weg oder kann ich das irgendwie nochmal wiederbekommen? 🤔 <a href="https://social.tchncs.de/tags/LibreOfficeCalc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LibreOfficeCalc</a> <a href="https://social.tchncs.de/tags/followerpower" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#followerpower</a> :BoostOK:

Recent searches

Search options

Administered by:

Server stats: