Problemsby GlyphCritical work in Excel is fragile and manual
29 posts from 29 people25d activeSteady, +2 this week
Posts per day
The posts behind it
feat: open the file viewer on the Preview tab when the file has a preview
...in a built chunk, so it has to be re-applied after every upgrade. ### Alternatives or Workarounds None without patching the build.
...and Apple Numbers are really just me too players, albeit with their niches. LibreOffice struggles imo since its main claim is to be fully Excel compatible but there are so many ancient Excel sheets that fail in practice (VBScript?). I think that there will continue to be a need...
Title: Need advice on implementing AI agents in a garment manufacturing factory Hi everyone, I am exploring the possibility of implementing AI agents in a garment manufacturing factory and would like guidance from people experienced in AI agent development and manufacturing operations. The factor
Title: Need advice on implementing AI agents in a garment manufacturing factory. Hi everyone,. I am exploring the possibility of implementing AI agents in a garment manufacturing factory and would like guidance from people experienced in AI agent development and manufacturing...
...is appreciated. I used an excel sheet for the longest time and this was ugly and annoying to use because any sort of visualization or aggregate data involved needing to know how to work excel. This might have been a skill issue ... but anything is better than excel.
How much actual analysis do you get to do vs. just maintaining dashboards and fixing ad-hoc spreadsheet requests?
...finding patterns in data. But I wonder how much of the actual job is spent dealing with messy Excel files, fixing reports, maintaining dashboards, or handling last-minute requests.. For those working as data analysts, how does your time usually break down? How much do you spend...
...in my job Excel is not used for numbers but abused as a database. It really deeply sucks at that, you need to copy paste vlookups and it chokes on a few hundred thousand rows. On a modern computer that's ridiculous. It doesn't enforce type integrity and sometimes people type...
Exported CSV/Excel files ignore locale-specific number formatting and may export incorrect numeric values
...precision or as raw internal representations. 4. Exported files become difficult or impossible to use in localized versions of Excel. 5. In German Excel, values such as 3.5 may be interpreted incorrectly (as an date) depending on regional settings. **Expected Behavior** CSV and...
Title: Dashboard variables: When "All" is selected, show all individual values as checked (Excel-style filter behavior)
**Why is this needed**: In a multi-value dashboard variable with "Include All option" enabled, selecting All only checks the "All" entry. Every individual value (e.g. FI, SE1, SE2, SE3, SE4) still shows an empty checkbox. This is confusing because: It looks like no individual...
Cloud instance: executions across all workflows killed mid-run with status 'crashed' — instance-wide, no node error, survives reboots (1.123.85)
## Describe the problem/error/question Since **2026-10-19**, executions across **two unrelated workflows** on our n8n Cloud instance are being killed mid-run with status **`crashed`** - no node-level error message, the runData simply stops. The failure is instance-wide (an...
Lakeview missing basic functionality?
Hopefully someone can help point me in the right direction or offer workarounds, but it seems like Lakeview dashboards are missing super basic functionality.. Specifically two things:. The ability to click to filter a table via a given field on the table header, similar to an...
Going from bad to worse
...How is someone not testing this integration? Sending code in the chat is still a nightmare. Wish they can just copy the functionality from Slack Teams on web is just terrible. Calls don’t always come through.Screen sharing freezes randomly The less said about the scrolling...
...was powerful, and how arrays being first-class citizens made sense. To this day, I'm frustrated by Excel's (and almost no other spreadsheet's) inability to have a cell containing anything other than a scalar. When people ask me which language they should learn next, I always...
[SIP-237] Include Applied Filter Settings in Excel and CSV Exports
...data, but not the filter selections that produced that data. This makes exported files difficult to interpret, reproduce, or share outside of Superset. This is particularly problematic when: - dashboard native filters affect chart results; - chart-level filters affect exported...
[SIP-236] Proposal for a Spreadsheet chart (Excel-like, editable) built on Univer
## [SIP] Proposal for a Spreadsheet chart (Excel-like, editable) built on Univer ### Motivation Many Superset users still copy chart data into Excel to do the last mile of work: rename a header, add a total row, colour a few cells, write a formula next to the data, group rows...
...probably would use LibreOffice or OnlyOffice or something. LibreOffice Calc just kind of sucks as of right now.
...Google Sheets for me in functionality. Too bad copy paste from Excel or Google Sheets doesn't work correctly. It does work, which is already impressive. This is probably not heavy use, I get it, but definitely improves things for me. Also rapid improvements are incoming.
Software X has a feature. Me: "hi support, feature is not available??" Support: "it doesn't work in that situation. Here's a link to our documentation with two dozen bullet points about where and when that feature doesn't work". It's as if you selected a cell in Excel, and the...
...and other information fields. The whole text to SQL thing is about data teams being a bottleneck to the business (rather like software people). The goal is good in theory but honestly an Excel plugin is probably a better solution in many cases.
CSV/formula injection in generateCSV: log exports emit attacker-controlled cells that execute in an admin's spreadsheet
## Describe the Bug `generateCSV` doesn't neutralise formula prefixes, and only escapes quotes when the value happens to contain a comma. Several of the columns that flow through it are user-supplied text, so someone can plant a formula that fires when an admin opens the export....
If "a few years ago" counts, a relative of mine abroad used an MS-DOS application attached to an Epson dot-matrix printer that supported a PITA foreign script to print invoices. It wasn't too painful, since the system supported batch jobs fed by a format that Excel could export.
Excel on Mac does not have all the features. It does have most of them. It is also buggy.
> and launch the program I sat down to get into, without thinking "Oh yeah, I meant to edit that excel file..." and going on a 30 minute tangent. I have the opposite problem. I leave things on the desktop as an intentional reminder to get back to them, but it doesn't work.
Senior Data Analyst
...within Excel. I don't know exactly what the date will look like but I do know it will be messy. I work in Excel daily and I know basic formulas like TRIM, XLOOKUP, IF, etc. I can also make a decent pivot table lol. I did not over exaggerate my experience or what I can do in...
Advice and professional development online feels like its geared towards one-time ad-hoc projects. Any resources on managing data on a recurring, organizational basis?
...gathering across teams with confusing/vague needs. dealing with a system that's built on workarounds after workarounds. best practices documenting analytics/dashboards that are being shared publicly (word doc, slide deck, notion page?). dealing with a domain that is overly...
I can write code to fix this. I should not have to write code to fix this.
...r/excel post.. The Teams message was meant to be a slightly humorous way to express my frustration/disappointment to colleagues outside the email thread with our boss about said data. Rant incoming. . Could I have just thrown Python at this nonsense and built something much more...
pdf App for IOS
...save it there, work on it, and reupload it to google drive again.. This is quite annoying, not just the extra step but also it sometimes struggles and you cannot redraw some things after uploading it to drive.... Thanks in advance for any answers :).
Excel vs SQL
...achieve the monthly end result.. I want to automatize further and I’m looking into SQL. Any advice on what to look up for if this is the right lead, and where to start? .
I think I can. In 2026 Excel is unusable for me (I cannot see the active cell at a glance, I cannot trace dependent cells to “debug” my formulas, I cannot save directly to my local hard disk with a keystroke combination- I have to click around to avoid OneDrive) Outlook freezes...
Feature idea: read_excel support for password-protected (encrypted) workbooks
### Description I know read_excel has trimmed engines before (pyxlsb got dropped in #16784 a few months after calamine landed, once calamine covered the same ground), so this isn't another "please add a fast engine" request. calamine and openpyxl can't read password-protected...
Companies and products named
About this problem
Evidence
29 posts from 29 people in 14 places, about 3 a week over 64 days. Mostly on Hacker News comments, r/analytics, apache/superset. Tools named alongside: Apache Superset, GitHub, PyPI, Google Sheets.
Frustration Frustration 2 of 3· Seen on Hacker News, Reddit, GitHub issues, App Store reviews
How it was grouped
Posts that state a pain and match the "spreadsheets" rule about Excel. First post Sep 2, 2026, latest Nov 4, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method
The same problem elsewhere
Critical work still runs on fragile spreadsheets
18 posts from 18 people on Reddit, GitHub issues, Stack Overflow.
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 DuckDB is fragile and manual
2 posts from 2 people on Hacker News, Reddit. Unverified.
Critical work in SQL Server is fragile and manual
2 posts from 2 people on Reddit. Unverified.
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