mini_spreadsheet
1.0.0
Windows Forms Application C#
This is pretty spreadsheet created in Windows Forms that can help you make basic operations with cells and values.
git clone https://github.com/pashokred/mini_spreadsheet.gitAnd open it in IDE with .NET Core 3.1 and Windows Forms support
There is all the bells and whistles this project can perform:
The main functionality is to easy calculate expressions with double values and cell initializers
In this form you can use next operations:
* Arithmetic operations
+, -, *, / (binar operations)
^ (put number in the power)
mod (modulo operation or operation %) - returns the remainder or signed remainder of a division, after one number is divided by another)
div (integer division) - is division in which the fractional part (remainder) is discarded is called integer division and is sometimes denoted
* Logical operations:
=, <, >
<=, >=, <>
(returns '1' if true and '0' if false)
You can also do operations with cell identifiers:
Create table by your own size, Add/Delete last rows and columns
If you get really randy, you can even export this table in .xlsx format or import in table from files with extentions .xls, .xlsx, Excel WorkBook, Excel Workbook 97-2003.
Type: Double|String
Return: Double
Default: 0
A2 = 45;
H4 = 7;
F3 = 26;
G3 = F3;
B1 = 45;
E5 = 16;
Example:
((A2+50) - H4*10) mod F3 + G3 div B1 > (E5/3)^4 # Prints 0Type: Double|String
Return: Double
Default: 0
A2 = 45;
F3 = 26;
B1 = 45;
E5 = 16;
Example:
(A2+45) / F3 mod E5 - 50 mod B1 # Prints -1.5384...If you'd like to contribute, please fork the repository and use a feature branch. Pull requests are warmly welcome!
The code in this project is licensed under MIT license. LICENSE
