framapiaf.org est l'un des nombreux serveurs Mastodon indépendants que vous pouvez utiliser pour participer au fédiverse.
Un service Mastodon fourni par l'association d’éducation populaire Framasoft.

Administré par :

Statistiques du serveur :

1,4K
comptes actifs

#libreofficecalc

1 message1 participant0 message aujourd’hui
C.<p>Just ran into a brutal <a href="https://mindly.social/tags/UI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>UI</span></a> / <a href="https://mindly.social/tags/UX" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>UX</span></a> problem in LibreOffice Calc, on a Debian bookworm system, fully up to date.</p><p>1. Decide to print spreadsheet<br>2. Open print dialog<br>3. Preview is in the left pane, options in the right.<br>4. Scroll down in the options pane to find an option near the bottom.<br>5. Change setting, or not.<br>6. Scroll back up to the top of the options pane, using the pointing device vertical scroll wheel.<br>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.<br>8. Move the mouse pointer slightly up and scrolling the options pane continues.<br>9. Click "print".</p><p>Voila! 23 copies of what you wanted to print a single copy of.</p><p>I actually ran into this while trying to debug a totally different UI / UX bug 😱 </p><p><a href="https://mindly.social/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LibreOffice</span></a> <a href="https://mindly.social/tags/LibreOfficeCalc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LibreOfficeCalc</span></a> <a href="https://mindly.social/tags/Calc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Calc</span></a> <a href="https://mindly.social/tags/spreadsheet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>spreadsheet</span></a> <a href="https://mindly.social/tags/linux" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>linux</span></a> <a href="https://mindly.social/tags/Debian" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Debian</span></a> <a href="https://mindly.social/tags/bookworm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>bookworm</span></a> <a href="https://mindly.social/tags/printing" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>printing</span></a> <a href="https://mindly.social/tags/CUPS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>CUPS</span></a> <a href="https://mindly.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenSource</span></a> <a href="https://mindly.social/tags/FreeSoftware" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FreeSoftware</span></a></p>
CraigOnline<p><span class="h-card" translate="no"><a href="https://aus.social/@jimbob" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>jimbob</span></a></span><br>Hmm, does that come in <a href="https://aus.social/tags/LibreOfficeCalc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LibreOfficeCalc</span></a> ?</p>
Virtual Curiosities<p><a href="https://www.virtualcuriosities.com/articles/4118/news-libreoffice-calc-24-2-adds-column-row-highlighting-for-active-cell" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">virtualcuriosities.com/article</span><span class="invisible">s/4118/news-libreoffice-calc-24-2-adds-column-row-highlighting-for-active-cell</span></a> <a href="https://mastodon.social/tags/technology" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>technology</span></a> <a href="https://mastodon.social/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a> <a href="https://mastodon.social/tags/libreoffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>libreoffice</span></a> <a href="https://mastodon.social/tags/libreofficecalc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>libreofficecalc</span></a> <a href="https://mastodon.social/tags/news" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>news</span></a> <a href="https://mastodon.social/tags/software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>software</span></a></p>
Boris Unckel<p><span class="h-card" translate="no"><a href="https://fosstodon.org/@linux_mclinuxface" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>linux_mclinuxface</span></a></span> In <a href="https://fosstodon.org/tags/LibreOfficeCalc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LibreOfficeCalc</span></a> its 3993778408</p>
luiseme ⁂<p><span class="h-card" translate="no"><a href="https://mastodon.social/@arredro" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>arredro</span></a></span>, como <a href="https://masto.es/tags/hasercorp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>hasercorp</span></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">#<span>LibreOfficeCalc</span></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"><span class="invisible">https://www.</span><span class="ellipsis">edu.xunta.gal/centros/iesrosai</span><span class="invisible">s2/aulavirtual/pluginfile.php/16607/mod_resource/content/14/tutorial_LOC_v7_v2.0.pdf</span></a><br><a href="https://masto.es/tags/FOSS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FOSS</span></a> <a href="https://masto.es/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LibreOffice</span></a></p>
Marcel SIneM(S)US<p>Emojis und andere Symbole in <a href="https://social.tchncs.de/tags/Excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Excel</span></a> und <a href="https://social.tchncs.de/tags/LibreOfficeCalc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LibreOfficeCalc</span></a> - pctipp.ch <a href="https://www.pctipp.ch/praxis/office/emojis-symbole-in-excel-libreoffice-calc-2793685.html" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">pctipp.ch/praxis/office/emojis</span><span class="invisible">-symbole-in-excel-libreoffice-calc-2793685.html</span></a> <a href="https://social.tchncs.de/tags/MicrosoftExcel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MicrosoftExcel</span></a> <a href="https://social.tchncs.de/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LibreOffice</span></a></p>
yeKcim<p>Je découvre <a href="https://framapiaf.org/tags/Regressi" class="mention hashtag" rel="tag">#<span>Regressi</span></a> (<a href="https://regressi.fr/WordPress" target="_blank" rel="nofollow noopener noreferrer" translate="no"><span class="invisible">https://</span><span class="">regressi.fr/WordPress</span><span class="invisible"></span></a>)</p><p>C’est aussi puissant que moche !</p><p>La propagation automatique des incertitudes wow ! Par ex, vous avez une série d’angles θ à ±1°, vous créez une colonne sin(θ), les incertitude sur le sinus sont directement calculée !</p><p>Je n’ai trouvé ça dans aucune autre interface graphique (c’est possible avec uncertainties en python ou errors dans R)</p><p>J’ai testé <a href="https://framapiaf.org/tags/labplot2" class="mention hashtag" rel="tag">#<span>labplot2</span></a>, <a href="https://framapiaf.org/tags/scidavis" class="mention hashtag" rel="tag">#<span>scidavis</span></a>, <a href="https://framapiaf.org/tags/alphaplot" class="mention hashtag" rel="tag">#<span>alphaplot</span></a> <a href="https://framapiaf.org/tags/GNUPlot" class="mention hashtag" rel="tag">#<span>GNUPlot</span></a>, <a href="https://framapiaf.org/tags/LibreOfficeCalc" class="mention hashtag" rel="tag">#<span>LibreOfficeCalc</span></a>, <a href="https://framapiaf.org/tags/JASP" class="mention hashtag" rel="tag">#<span>JASP</span></a>, <a href="https://framapiaf.org/tags/Jamovi" class="mention hashtag" rel="tag">#<span>Jamovi</span></a> j’ai pas trouvé ça !</p>
Amᵃᵖanda 🔜 HackW/E@LinuxHotel<p>Am I right in thinking that <a href="https://en.osm.town/tags/Excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Excel</span></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?</p><p>(I'm sure same Q applies to <a href="https://en.osm.town/tags/LibreOfficeCalc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LibreOfficeCalc</span></a>...)</p>
Paul 🏳️‍🌈 🇺🇦🇵🇸🇬🇱<p><a href="https://mastodonapp.uk/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LibreOffice</span></a> - The compatibility is incredible. This is version 5.4 in XP loading a spreadsheet edited in 24.2. Same goes for Writer<br><a href="https://mastodonapp.uk/tags/LibreOfficeCalc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LibreOfficeCalc</span></a><br><a href="https://mastodonapp.uk/tags/WindowsXP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>WindowsXP</span></a><br><a href="https://mastodonapp.uk/tags/RetroComputing" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RetroComputing</span></a></p>
mborus<p>Doing my taxes with <a href="https://mastodon.social/tags/LibreOfficeCalc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LibreOfficeCalc</span></a> and I'm tired of using the mouse too much.</p><p>So I thought maybe get <a href="https://mastodon.social/tags/ChatGPT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ChatGPT</span></a> to teach me the keyboard shortcuts and formatting tricks. So far it's doing a really good job. </p><p>For example. I only need about 10 columns and it suggested pressing Ctrl+Shift + Right on the last column and then hiding them. Very good advice. </p><p>It will be fun to see what I'll learn today.</p>
Cdrik ⏚🌻<p>Sparklines 🤔 </p><p><a href="https://framapiaf.org/tags/LibreOfficeCalc" class="mention hashtag" rel="tag">#<span>LibreOfficeCalc</span></a></p>
maupao<p>Da quando ho capito come funziona la <a href="https://framapiaf.org/tags/tabellapivot" class="mention hashtag" rel="tag">#<span>tabellapivot</span></a> appena posso metto tutto in un foglio di calcolo e genero tabelle su tabelle. <a href="https://framapiaf.org/tags/libreofficecalc" class="mention hashtag" rel="tag">#<span>libreofficecalc</span></a></p>
JBrickelt963 (φ)<p>Petite <a href="https://framapiaf.org/tags/question" class="mention hashtag" rel="tag">#<span>question</span></a> de formatage des cellules sur <a href="https://framapiaf.org/tags/LibreOffice" class="mention hashtag" rel="tag">#<span>LibreOffice</span></a> <a href="https://framapiaf.org/tags/Calc" class="mention hashtag" rel="tag">#<span>Calc</span></a> comment faites-vous pour afficher des unités genre kg, m, etc parce qu&#39;en fouillant sur le net et l&#39;assistance libreoffice j&#39;ai bien trouvé les code formatage, mais aucun formatage défini par l&#39;utilisateur n&#39;a fonctionné.</p><p>Au passage je suis sur Windows 10 (x64) avec la version 7.1.3.2 de LibreOffice si ça peut aider.</p><p>Merci d&#39;avance pour tout vos retours ^^</p><p><a href="https://framapiaf.org/tags/libreofficecalc" class="mention hashtag" rel="tag">#<span>libreofficecalc</span></a> <a href="https://framapiaf.org/tags/traitementtexte" class="mention hashtag" rel="tag">#<span>traitementtexte</span></a> <a href="https://framapiaf.org/tags/formatage" class="mention hashtag" rel="tag">#<span>formatage</span></a> <a href="https://framapiaf.org/tags/cellule" class="mention hashtag" rel="tag">#<span>cellule</span></a> <a href="https://framapiaf.org/tags/libreoffice" class="mention hashtag" rel="tag">#<span>libreoffice</span></a>-fr</p>