I have an #Excel spreadsheet that for some reason reformats every single column when refreshed or a cell on the table is double clicked. This has just started happening and it's occurring with earlier versions of the same spreadsheet that presented no problems before. I have tried everything suggested by Microsoft to get Excel to stop reformatting the columns.
From superuser .com question (never heard of the site, i just searched)
"
In addition to "Adjust Column Width", it might help to set in the table properties "Preserve Column Sort/Filter/Layout".
...never run into this, myself, and the searching on it indicated that excel can get quite puzzling in its behaviour with refreshed pivot tables - but the above was about the only complaint about regular tables, all resizing to "current-data-size" when refreshed.
Hiermit möchte ich #LibreOffice mal ein Kränzchen winden: Seit den 2000er Jahren benutze ich die freie Office-Suite. (Vor dem Fork war es #OpenOffice) Privat, wie geschäftlich. Die Schriftartenersetzung ermöglicht mir Vorlagen, die platformübergreifend funktionieren. Der mächtige Text-Importer von Calc begeistert mich im Gegensatz von #Excel immer wieder aufs Neue. Vielen Dank, liebe Opensource-Gemeinde, für die tolle Software!
(1/2) I have been following the work of @stevensanderson and David Kum for a few years now, and I am excited to see the release of their new book 🥳- Extending Excel with Python and R 🚀.
The book focuses on the common conjunction and collaboration between data scientists and Excel users. This includes scaling and automating #Excel tasks with #RStats and #Python and core data science applications such as data wrangling, working with APIs, data visualization, and modeling.
(2/2) Here are some of the topics the book covers:
✅ Read and write Excel files with R and Python
✅ Excel automation with R and Python scripts
✅ Data visualization with ggplot2 and Matplotlib in Excel
✅ Time series analysis and forecasting
✅ Regression analysis
✅ Embading R/Python applications and functions in Excel
If you are working with Excel users or you are using Excel and want to extend your capabilities, I recommend checking this book.
Does anyone know how I can import prices from websites like #gog into #LibreOffice? I would like to create my own #wishlist with all the prices to get a better overview of the offers.
This project is actually a byproduct of another big thing I'm working on.
Currently, I use YNAB for budgeting, but I've been putting sustained effort into getting my data out of the cloud and self-hosting everything.
I started researching options for budgeting software, and I really couldn't find anything I liked or that felt like it had enough features.
I decided, then, to just whip up something in Excel... which led me to the discovery of Office.js and the ability to build Add-ins for Excel using web tech.
Thus, vue-excel was born.
I may eventually release my budgeting tool for Excel, when it's feeling a little more mature and stable. Stay tuned... ❤️
Mal was ohne Rollenspielbezug: Kennst sich hier jemand sehr gut mit #Excel aus?
Wenn ich aus einem anderen Fenster zurück zu Excel wechsle, wählt es nicht die Zelle aus, auf die ich klicke, sondern die, die ich zuletzt aktiviert hatte.
Bei Libre Office ist das anders - da lande ich immer dort, wo ich hinklicke. So möchte ich das auch gerne in Excel.
Ich hab mich halb tot gesucht in den Einstellungen, Google hilft mir gar nicht, und Copillot möchte mir irgendeinen dubiosen Code unterjubeln.
Further to this, I think what might be easier (for me, at least) is to automate having my Mac open the spreadsheets at a given time, so I can remember to review them and check whether anything has expired.
That part is relatively straightforward, though it does involve Calendar, Automator, Shortcuts, and whatever app the spreadsheets are in. But once it’s set I can forget about it.
@DJDarren pretty much. I mean, once it's in place it's a time saver, but you'll have to learn VBA (in reality google 'how to loop through files and send email vba excel'), test it, and maintain it...
Dobra. W Was jedyna nadzieja, bo mnie coś trafi powiem szczerze. Nie umiem excela, chyba że takie proste rzeczy jak w gimnazjum. Tego nie ogarniam, a zostałem poproszony o pomoc. Ktoś wie jak się takie rzeczy robi? Bo podejrzewam, że tu trzeba machnąć przestawną, ale za żadne skarby świata nie wiem jak to działa.
Should software like #Obsidian, #Excel, and the various flavours of #PlainTextAccounting be wrestled into doing things that can often be done more easily with other apps, or with #analog solutions? Consider using the 3-step recipe from my latest newsletter for choosing tools that support your values and promote peaceful contentment.
@simonmic Thank you for clarifying that, and for giving a balanced look at the topic. I hear what you're saying, though it's worth remembering that the "it's not hard" thing is relative to one's current level of knowledge.
And I totally get that doing things the hard way can be fulfilling; I do it from time to time in other fields just because I can. As you say, it can be fun, and a great way to learn!
anyone out there ever come across behaviour in #excel#ExcelTips where a scatter chart without connecting lines infuriatingly adds them every time you open the file? pls boost for reach
@timrichards It allows you to calculate a date that is a certain number of months before or after another date. Useful for due dates of regular payments, maturity dates of term deposits, etc.
I wonder how many data breaches there have been because someone filtered a spreadsheet and thought the recipient couldn't get to the data or notice that it was hidden.
My internet research is not working today. On Friday, I had found a way to add a semi-colon at the end of each #Excel cell with the Custom format cell and I cannot for the life of me find it again. What's the "take whatever the text is and add a character at the end"?
🤦♀️
[Even better if someone knows how to take two columns in Excel, and merge them with a semicolon between the both of them.]
I'm really outside of my comfort zone here. I'm trying to help myself a bit before AI is forced on us by converting one of my glossaries into a #CVS file that can be imported in the automatic translation tool.
However, I have terms with commas in them. It breaks the formatting and kills those equivalents.
I'm trying to understand the quotes, and how to isolate my commas, but I don't understand the explanations I find (so many quotations marks!!).
I think using a different separator than a comma would also work.
@governa I, for one, proudly announce that I choose to remain ignorant of most of excel's specific formulae and tricks with no interest whatsoever in learning them.
A spreadsheet is supposed to be a visualization of data, not a mini operating system. If it's no longer a data repository visualized, then it's no longer fit for being a spreadsheet.
And even as a data repository, you might make better use of that data as an actual database instead.
Sur #Excel, j'ai une macro qui fonctionne mais pas son raccourci (ctrl+d) alors que ça marche chez mes collègues.
A part si j'ai assigné ce raccourci à autre chose (comment vérifier ça? ) et que cela provoque un conflit, une idée pour résoudre ce mystère?
