151–160 of 225 posts
Expected: A3 should become =SUM(A0:A2)+A0+A2 and evaluate to 4
Actual: A3 becomes =SUM(A0:A1)+A0+A2 and remains 4 until it is edited, at which point it evaluates to 3.
Founder/CEO here. When I worked in AWS S3, I spent a lot of time in Excel. Even as a dev, it was the fastest way to explore data, build models, and share forecasts with business partners. My Excel usage was plagued by slow performance, poor cloud integration, and no first-class Python support. I loved the richness and responsiveness of Excel, but I had to give up too much power to get it. This felt like a false choic…
This looks like something that I could use right away, but I wonder, since we can write Python, does this mean that we can write back to one of the native backends (e.g. Postgres)? Currently, the only way to do this from Excel (e.g. saving a snapshot of an analyst's current dashboard that they just built) is through a macro, which then starts the (understandable) descent into Excel's External Content and Trust Center…
https://techcommunity.microsoft.com/t5/excel-blog/announcing...
Founder/CEO here. When I worked in AWS S3, I spent a lot of time in Excel. Even as a dev, it was the fastest way to explore data, build models, and share forecasts with business partners. My Excel usage was plagued by slow performance, poor cloud integration, and no first-class Python support. I loved the richness and responsiveness of Excel, but I had to give up too much power to get it. This felt like a false choic…
Why build a custom arrow based columnar engine in Rust instead of using Datafusion or Polars?
They are all ultimately just different UIs on top of Arrow.
They're complimentary tools. We can take data out of the spreadsheet and put it into Polars instantly (you can do this in the Python code window if you want), etc.
Regarding why not implement our spreadsheet built on top of those: spreadsheet allow for heterogenous types in columns, so that requires a lot of extra infrastructure to manage, whereas Datafusion and Polars require homogenous column types.
Do you have any simd-optim in parsing all those large files ? I have read that you write some of your own parser for perf boost. (I am one of the author of https://github.com/V0ldek/rsonpath )
No SIMD in the parser path... yet... :) The main win from writing our own custom parser is writing directly into the final in-memory format from the parse stream without any intermediate allocations or data movement. Awesome project! Adding it to my list of things we may plug into in the future.
Out of curiosity, do you support/have plans to support the broader set of Excel shortcuts that reference the ribbon? (Alt + shortcuts). Lots of excel power users more or less exclusively use the keyboard to navigate, and so have muscle memory for almost everything they do, including more niche operations (Insert Line Chart = Alt N N 1, or Change Column Width = Alt H O W). Will be a very hard sell to banks/other finan…
Founder/CEO here. When I worked in AWS S3, I spent a lot of time in Excel. Even as a dev, it was the fastest way to explore data, build models, and share forecasts with business partners. My Excel usage was plagued by slow performance, poor cloud integration, and no first-class Python support. I loved the richness and responsiveness of Excel, but I had to give up too much power to get it. This felt like a false choic…
Can you make it a desktop application?
Would you be ok with a new file format or do we need to save to .xlsx?
How important is Python in a desktop version? Would you need integration with conda or virtualenv?
How much do you think we should charge?
Earlier quoted context omitted.
Yes, Excel compatible: https://rowzero.io/docs/spreadsheet-functions If we're missing any formulas you need, message me at breck at rowzero.io and we'll add them (usually within 24 hours).
You'll also need formatting to be the same to get adoption. e.g. I wanted to format numbers as currency, and got USD$x,xxx as a result, and no obvious way to change that to $x,xxx.
Earlier quoted context omitted.
Do you sell a software or a service running in a browser? Is the computation happening on my computer or your cloud?
All computation happens in the cloud. This is really nice because we can scale up and down to fit your data size. If you need a supercomputer for 30 minutes, we can get you one.
Quick bug report: I set A0 and A1 to 1, then set A2 =SUM(A0:A1)+A0+A1. As expected, A2 evaluated to 4. Then I right-clicked on the 1 row header and inserted 1 row above. Expected: A3 should become =SUM(A0:A2)+A0+A2 and evaluate to 4 Actual: A3 becomes =SUM(A0:A1)+A0+A2 and remains 4 until it is edited, at which point it evaluates to 3.
For me, A3 becomes =SUM(A1:A2)+A1+A2 and remains 4 as it should be.
The action I am taking:
A0=1
A1=1
A2=SUM(A0:A1)+A0+A1 (evaluates to 4)
Now I have:
A0=empty
A1=1
A2=1
A3=SUM(A1:A2)+A1+A2 (evaluates to 4)
Earlier quoted context omitted.
> * but spreadsheets on the browser always represent an inferior UX What do you mean by this? Inferior to a standalone app? Inferior to some other design in general?
Inferior to a native app. Navigating it with the keyboard is clunky, the UI is never as crisp and responsive, it's harder to save and open files... the list goes on