Nicolás Hatcher
4095b7db6e
UPDATE[API rename]: set_column_with => set_columns_with
...
Similarly set_row_height => set_rows_height
2025-02-19 18:26:49 +01:00
Nicolás Hatcher
dd9ca4224d
UPDATE: Select multiple columns/rows
...
Also fixed a bug where a second column would not pick up salyes correctly
2025-02-19 18:26:49 +01:00
Nicolás Hatcher
5aa7617e97
FIX: It it possible to have DF scoped to the first sheet
2025-02-19 13:40:32 +01:00
Nicolás Hatcher
a10d1f4615
FIX: Fix a bug were a new column style would introduce an invalid format
2025-02-15 15:25:36 +00:00
Nicolás Hatcher
91984dc920
FIX: Forces calculation after insert/delete columns/rows
2025-02-15 10:16:05 +00:00
Nicolás Hatcher
edd00096b6
FIX: Minor fixes in column/row styles
...
Most notably deleting the formatting does not change width/height
2025-02-15 09:46:39 +00:00
Nicolás Hatcher
d764752f16
FIX: diverse issues with set/delete column and row styles
2025-02-15 09:46:39 +00:00
Nicolás Hatcher
6ee450709a
FIX: Numerous fixes
...
This also fix old issues:
* Top border is only the top border of the selected area
(and not he top border of each cell in the area)
* Same for bottom, left and right borders
Factored out all the border related issues to a new file
2025-02-15 09:46:39 +00:00
Nicolás Hatcher
23ab5dfef2
UPDATE: Add rows/column style APIs
2025-02-15 09:46:39 +00:00
Nicolás Hatcher
dc8bb6da21
FIX: Undo/redo delete/add page
...
Now we can undo adding or deleting worksheets
2025-02-05 21:52:34 +01:00
Nicolás Hatcher
8a54f45d75
UPDATE: Add clear formatting
...
Fixes #267
2025-02-04 19:02:05 +01:00
Nicolás Hatcher
cbda30f951
FIX: Use 1 as the first serial number corresponding to 1899-12-31
2025-01-01 11:53:05 +01:00
Nicolás Hatcher
c6adf8449b
FIX: Dates are only valid up to the last day of 9999
2024-12-30 14:15:09 +01:00
Shalom Yiblet
d04691b790
refactor(dates): adjust date handling logic for improved accuracy
...
Updated the logic for handling months and days to improve date calculations. Also modified the constants for Excel date ranges to align with supported dates.
2024-12-30 13:12:33 +01:00
Shalom Yiblet
7c32088480
feat: update date
2024-12-30 13:12:33 +01:00
Nicolás Hatcher
6326c44941
FIX: TRUE and FALSE can also be functions
...
Previously the engine was internally transforming TRUE() to TRUE
Note that the friendly giant implements this only for
compatibility reasons
2024-12-29 19:17:54 +01:00
Gian Hancock
8ba30fde33
Add more tests for OR and XOR
...
Some of these tests fail due to inconsistencies with Excel
cleanup
2024-12-26 15:06:54 +01:00
Nicolás Hatcher
86213a8434
FIX: Add test for get_defined_name_list
...
Also uses the scope instead of the opaque sheet_id
2024-12-26 10:21:21 +01:00
Nicolás Hatcher
2ed5fb9bbc
FIX: Adds some validation and tests
2024-12-26 10:21:21 +01:00
Nicolás Hatcher
e455ed14ea
UPDATE: API for defined names
2024-12-26 10:21:21 +01:00
Nicolás Hatcher
5d8e6255a3
UPDATE: Hide/Unhide sheets
2024-12-20 00:49:33 +01:00
Nicolás Hatcher
e098105531
FIX: When cut and paste to a different sheet origin is removed
...
Fixes #193
2024-12-16 08:01:51 +01:00
Nicolás Hatcher
23814ec18c
FIX: Several fixes on the FV function
...
(1+x)^(1+y) was stringifyfied incorrectly
We still need work on this
FV now returns currency
FV(-1,-2,1) should return #DIV/0! not #NUM!
2024-12-14 22:08:44 +01:00
Gian Hancock
c59148bdf6
Add tests for OR function
...
Tests currently fail due to issue #175
2024-12-12 13:06:12 +01:00
Andrew Fillmore
d4a2289826
Add GEOMEAN .xlsx, Update .md files, and Run cargo fmt
2024-12-12 05:58:20 +01:00
Andrew Fillmore
e5aff48e36
Add GEOMEAN Tests
2024-12-12 05:58:20 +01:00
Sinan Yumurtaci
075760b7ba
typo
2024-12-12 05:49:25 +01:00
Sinan Yumurtacı
eee40c1b9a
FIX: Prevent negative column width, row height ( #167 )
...
* Prevent negative column width / row height in rust
* prevent in front-end
2024-12-11 00:07:06 +01:00
Nicolás Hatcher
4b806c357a
FIX[parser]: Check the order (row, column) in range before transforming
...
Fixes #155
2024-11-30 14:37:06 +01:00
Nicolás Hatcher
c1df2cec0b
FIX: Issues with paste
...
Copy/Paste is always with tab separated values not "," or others.
Maybe we can add that?
2024-11-27 22:55:39 +01:00
Nicolás Hatcher
283a44e109
FIX: Aaahhh! Make the linter happy
2024-11-27 22:55:39 +01:00
Nicolás Hatcher
f7dac8b015
FIX: fmt issues
2024-11-27 22:55:39 +01:00
Nicolás Hatcher
df0aa51d14
FIX: Adds some tests
2024-11-27 22:55:39 +01:00
Nicolás Hatcher
411c5de59b
FIX: Another round a borders
...
Only test are missing(!)
2024-11-27 22:55:39 +01:00
Nicolás Hatcher
0df132d5c2
FIX: Work undone
...
We are not going to follow this path, but I will leave this commit as
part of the git history
2024-11-27 22:55:39 +01:00
Nicolás Hatcher
8cdb3b8c60
FIX: Removes ununsed borders code
2024-11-27 22:55:39 +01:00
Nicolás Hatcher
d70ab85396
FIX: Adds some more tests fro FORMULATEXT
2024-11-27 22:28:07 +01:00
Nicolás Hatcher
726fc1399d
UPDATE: Adds FORMULATEXT for Steve
2024-11-27 22:28:07 +01:00
Nicolás Hatcher
949eafc97f
FIX: Removes the csv-sniffer in favour of a simple guess
...
This removes 500Kb form the was build so it is worth it.
We were using a very old version of the sniffer, the last one might not
have this bug though
2024-11-26 20:13:41 +01:00
Bruno Carvalhal
e130f784fd
add missing test case for multiple arguments in UNICODE
2024-11-17 16:49:41 +01:00
Bruno Carvalhal
3c49f9a606
Add error cases
2024-11-17 16:49:41 +01:00
Bruno Carvalhal
63817e2d50
Also accept _xlfn.UNICODE
2024-11-17 16:49:41 +01:00
Bruno Carvalhal
0ed2984358
Add code coverage
2024-11-17 16:49:41 +01:00
Bruno Carvalhal
726bf677ed
Implement UNICODE function
2024-11-17 16:49:41 +01:00
Nicolás Hatcher
49ae2d8915
FIX: Forbid unwrap, expect and panic in the base code
2024-11-17 11:59:10 +01:00
Nicolás Hatcher
2c2228c2c2
FIX: [App]: Borders done right
2024-10-31 22:43:43 +01:00
Nicolás Hatcher
04d8c658ab
UPDATE: Adds cut/paste
2024-10-31 22:43:43 +01:00
Nicolás Hatcher
ffa93309e2
FIX: Renaming a sheet with the same name doesn't do anything
...
Fixes #103
2024-10-24 21:54:34 +02:00
Nicolás Hatcher
80273a88ec
FIX: When creating a new sheet, select it
...
Fixes #100
2024-10-24 21:54:34 +02:00
Nicolás Hatcher
cd54389e91
UPDATE: Implement copy/paste in the UI
2024-10-23 21:43:18 +02:00