Problemsby GlyphCritical work still runs on fragile spreadsheets
20 posts from 20 people16d activeSteady, +4 this week
Posts per day
The posts behind it
Duo support is lacking
One drive, excel, word, copilot, one note, but not Teams?
feat: Download button in the file viewer header
...URL with ?attachment=true and saves it with the shown file name. ### Alternatives or Workarounds Right-click the file name and choose save link as. Most users do not know this.
Finance Python Automation
...man... I have a lot to learn.. For context, I have a finance background and have been struggling to fully automate my personal financial reporting. I'm currently using Tiller since originally I wanted to use excel of which I am very proficient but it is becoming more complex and...
[SIP-238] Extension APIs for exporting chart and dashboard data (Google Sheets export)
...straight to a new Google Sheet. Bringing the same workflow to charts and dashboards is blocked by two gaps in the extension framework: 1. **Backend:** `superset_core` can run raw SQL (`Database.execute`, #36529), but it can't run a chart's query context or walk a dashboard's...
AI agents in Academic workflow - help needed
As an academician, I have many roles and deadlines. When I look for AI help, most of the discussion seems to be ethical implications. But my need is more paperwork basded. I have been using llms and manual work for this. I believe there is some way I can leverage AI for this and...
SurfSense: a self-hosted NotebookLM alternative
...features, reviewing every change and testing the releases. New behaviour starts with a failing test, and each feature has an architecture doc the assistants read before changing it.. Repo: https://github.com/MODSetter/SurfSense . Docs: https://surfsense.com/docs .
Want to know some tools other than python /SQL for data cleaning and analysis.
...something like OpenRefine , Data lab ,. I'm a beginner , it will be better if I get advice on learning from people who are experienced .. Help me with your guidance please..
Panda overall instructions
...errors="coerce") # ^ use this one if values look like "$1,200" or "45%" # --- Clean messy text (extra spaces, mixed capitals) --- # data["city"] = data["city"].astype(str).str.strip().str.title() # FILL IN: column # --- Rename a column with an awkward name --- # data =...
Spreadsheet preview renders right-to-left text in the wrong order
...in the built-in spreadsheet preview, making the words appear reversed and the content difficult to read. This was observed when previewing an Excel file containing Arabic text. The issue concerns RTL text rendering within spreadsheet cells. It should be investigated as a general...
I ran a blind test on self-hosted AI agents. Here are the results, guess who's who [D]
...names hidden, results below, take a guess. The tasks . Merge two contact lists, messy emails, two different Alex Kims. All 5 got it right (46 people).. Rename a function across 3 files with messy spacing. All 5 passed.. Fix a bug, with hidden tests. 4 passed. C turned "Q3/Q4"...
Only 13% of 3,362 automation case studies use any AI at all. Agents show up in 18.
...now the systems just pass it along. Even in a lot of the AI cases, the model reads the messy email and then regular integration does everything after that. I think that's why the AI ones don't report better results. The model is a small piece of the project, and most of the...
Streaming CSV Export ignores CSV_EXPORT settings (encoding=utf-8-sig and sep=';') while ZIP CSV export respects them
...CSV This leads to inconsistent export behavior and causes interoperability issues with Microsoft Excel. **Expected Behavior** All CSV export methods should respect the configured values **Actual Behavior** ZIP Export Produces: UTF-8 BOM Semicolon delimiter Excel opens the file...
Why is GCP such thieves? Pettiness to refund £200
...thinking to go with GCP, don't bother. Yes, their tools are better than AWS, but it's IMPOSSIBLE TO REACH A HUMAN BEING ..
How to Build a Database Where I Can't See Any of the Data
...all of the data), BigQuery to store it all, and Looker/Data Studio to visualize it.. The struggle we're having is: my team does not want me to see any of the actual financial data. I can manage building the systems without the data because I have the template for them to drop...
Google auth fails to authenticate GitHub Actions on CI
I am trying to create a CI pipeline for my project. The project stands for a part number database on Google Sheets. The user gives an input part number on the streamlit front-end and the sheet is updated. I am using the library gspread . Currently, I am building CI/CD pipelines...
I created a large csv/excel data plot tool, looking for suggestions
...free to use and no data upload to cloud/server, local browser only; hope can help people struggling to quickly visualise large datasets, while you don't have any software/tools in hand, would really appreciate for your feedback, thanks!. https://megarows.com ....
Help! Getting started with Snowflake but i’m lost.
Hi everyone!. I need some help on how can i get started with Snowflake. Im completely new to VSC, dbt and Git.. I did some SQL in highschool and mostly use gpt for sql queries i need. I’ve been working on power bi, excel online and microsoft list.. I’m mostly using it for...
...evidence but when I used duckdb and Python and Pycharm the Pycharm table viewer was not working as well as Excel. The rendering was messed up. Could be related to the remote desktop rendering but still not as flawless as Excel. The patchwork of multiple software from different...
Am I wasting my time?
...sql server instances to Azure SQL instances for slower speeds, higher cost, and bigger headache. We did start to build software in-house to replace vendors, but this has also mostly been a failure. However this at least gave me some experience working with developers, and I was...
py-evoFE: Automated Evolutionary Feature Engineering for Tabular ML in Python (Genetic Algorithms + Scikit-Learn + Polars) [P]
...are won or lost. While GBDTs like LightGBM and XGBoost excel on raw tabular data, they struggle to discover complex ratios, nested group-by aggregations, nonlinear dimensional projections, and interaction graphs on their own.. Manual feature engineering is either tedious or...
Companies and products named
About this problem
Evidence
20 posts from 20 people in 14 places, about 2 a week over 71 days. Mostly on r/dataanalysis, r/MachineLearning, apache/superset. Tools named alongside: Excel, GitHub, Google Sheets, PyPI.
Frustration Frustration 1 of 3· Seen on Reddit, GitHub issues, Hacker News, Stack Overflow, App Store reviews
Summary, model-written
Users experience reversed text rendering in spreadsheet previews, software migration difficulties, and rendering flaws in table viewers.
How it was grouped
Posts that state a pain and match the "spreadsheets" rule. First post Aug 27, 2026, latest Nov 5, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method
The same problem elsewhere
Critical work in Excel is fragile and manual
29 posts from 29 people on Hacker News, Reddit, GitHub issues.
Critical work in Power BI is fragile and manual
7 posts from 7 people on Reddit.
Critical work in pandas is fragile and manual
4 posts from 4 people on GitHub issues.
Critical work in Apache Superset is fragile and manual
4 posts from 4 people on GitHub issues.
Critical work in ChatGPT is fragile and manual
2 posts from 2 people on Hacker News, Reddit. Unverified.
Critical work in PostgreSQL is fragile and manual
2 posts from 2 people on GitHub issues, Reddit. Unverified.
Critical work in OpenAI is fragile and manual
2 posts from 2 people on Hacker News, Reddit. Unverified.
History