SoftMaker.com

After more thinking, it's better to separate the cases with only numbers vs with numbers and empty cells. Thus I'll focus first on number-only patterns. Here's a pattern rule that I think it's one of the simplest but also more powerful than what's currently in use: Start with the linear (arithmetic)...

I just noticed that Planmaker (and other popular spreadsheets) do have currently a behavior about formulas' references when selecting several cells, for example: If in a column have the formulas: =A1 =A3 Then at selecting both and dragging by the corner, you get next formulas to be: =A3 =A5 =A5 =A7 ...

I'm refering to inserting a sequence of numbers, in a row or column, then selecting them all and dragging by the corner. 1,1 => 1,1,1,1... OK 1,empty,1,empty => 2,empty,2,empty,3,empty,3,empty .... NOT OK, inconsistent expected=> 1,empty,1,empty,1,empty,1,empty,.... 1,1,2,2 =>2,3,3,3,3,4,4,4,4,4... ...

It does not have "Let" function;
is there another equivalent way to define local variables inside formulas? Besides using a pre-defined name for a range of cells.

Currently, if drag(copy) a cell down by 1, the references in the formula inside the cell get their row index increased by 1. It would be useful to have an easy way to change this behaviour and specify that row index be increased by an arbitrary number, n. It would make, for example, skipping cells/r...

More suggestions: * Grouping of rows or cols: - make clicking on the group-line in the margin to close/hide the group (that is, make so that not only clicking on "-" closes the group, but also click on line itself). Else, more mouse work. If have 2 or more subsequent groups of rows, and bo...

In Excel, it's said that "offset" is a volatile function (recomputed at any change in the spreadsheet) and thus "index" should be more efficient.
Are there such differences in Planmaker?

Hi, I'm new to FreeOffice , it appears to be very good software! =D> One feature I find neat (and better than in LibreOffice) is that you can move an object (chart, picture...) with the keyboard arrow keys and also control the speed with the "ctrl" or "shift" keys. A few initial ...