Jump to content




Speadersheet program - updated!


20 replies to this topic

#1 Konlab

  • Members
  • 595 posts
  • LocationKerbin

Posted 23 May 2016 - 04:39 PM

What is this?
This is a program you can make speadersheet with

Okay i know most of you don't read the texts so here is a screenshot:
Posted Image
Notice the function at the bottom?
More screenies (updated:)
Spoiler

Download:
http://pastebin.com/MrYWEUXT
pastebin get MrYWEUXT speadersheet

Changelog:
Spoiler


[Warning! Don't read the code! Or you will discover some messy and unreadable hard Lua literature!]

Controls:
Spoiler

Function format:
Spoiler

TODO:
Spoiler

Credits: Creator for the idea
Dog: for telling me the tostring thing to hide '.0' on the end of numbers

License: do anything you want to do with it but I'm not responsible for anything (but if you re-release you could credit me and +1, please)

Edited by Konlab, 11 June 2016 - 10:10 AM.


#2 Dog

  • Members
  • 1,179 posts
  • LocationEarth orbit

Posted 23 May 2016 - 04:51 PM

You're getting 1.0, 2.0, etc. at the top of your columns because you're not using tostring(). Convert the number to a string on line 126 and the .0 should be eliminated.

#3 DannySMc

  • Members
  • 1,808 posts
  • Location/home/dannysmc95

Posted 23 May 2016 - 04:59 PM

Could you upload this to my app store?:o I am working on a few updates, and one of them includes some new categories for programs that will be in, one of them is like Utilities like Word, Calculator, Spreadsheet, Powerpoint, and things like so, so this would be cool to be on my app store.

If you don't mind of course :P Link is here:
http://www.computerc...-discover-api6/

#4 TheRockettek

  • Members
  • 547 posts
  • LocationRem is best girl

Posted 23 May 2016 - 05:16 PM

:P its not a speadersheets, its a spreadsheet ;)

#5 Creator

    Mad Dash Victor

  • Members
  • 2,168 posts
  • LocationYou will never find me, muhahahahahaha

Posted 23 May 2016 - 05:23 PM

Awesome. Now we need powerpoint. I also see you implemented file storing since the last time you showed me this.

#6 Konlab

  • Members
  • 595 posts
  • LocationKerbin

Posted 23 May 2016 - 05:27 PM

Thanks for your replies!

 Dog, on 23 May 2016 - 04:51 PM, said:

You're getting 1.0, 2.0, etc. at the top of your columns because you're not using tostring(). Convert the number to a string on line 126 and the .0 should be eliminated.
Thanks! Will correct!

 DannySMc, on 23 May 2016 - 04:59 PM, said:

Could you upload this to my app store? :o I am working on a few updates, and one of them includes some new categories for programs that will be in, one of them is like Utilities like Word, Calculator, Spreadsheet, Powerpoint, and things like so, so this would be cool to be on my app store.

If you don't mind of course :P Link is here:
http://www.computerc...-discover-api6/
Of course!

 TheRockettek, on 23 May 2016 - 05:16 PM, said:

:P its not a speadersheets, its a spreadsheet ;)
Thanks! Corrected!

 Creator, on 23 May 2016 - 05:23 PM, said:

Awesome. Now we need powerpoint. I also see you implemented file storing since the last time you showed me this.
Power point is a good idea

Edited by Konlab, 23 May 2016 - 05:30 PM.


#7 TheRockettek

  • Members
  • 547 posts
  • LocationRem is best girl

Posted 23 May 2016 - 06:19 PM

KonLabs Office Bundle :P

#8 DannySMc

  • Members
  • 1,808 posts
  • Location/home/dannysmc95

Posted 24 May 2016 - 12:18 PM

 TheRockettek, on 23 May 2016 - 06:19 PM, said:

KonLabs Office Bundle :P

I will actually name this under the Store xD As long as he can get out an alternative to:
Word
Powerpoint
Spreadsheet

#9 Konlab

  • Members
  • 595 posts
  • LocationKerbin

Posted 24 May 2016 - 01:01 PM

Nex update!
Added functions: =ADD A-C1
and =COPY G5

 DannySMc, on 24 May 2016 - 12:18 PM, said:

 TheRockettek, on 23 May 2016 - 06:19 PM, said:

KonLabs Office Bundle :P

I will actually name this under the Store xD As long as he can get out an alternative to:
Word
Powerpoint
Spreadsheet
Word is hard :(

#10 DannySMc

  • Members
  • 1,808 posts
  • Location/home/dannysmc95

Posted 24 May 2016 - 11:21 PM

 Konlab, on 24 May 2016 - 01:01 PM, said:

Nex update!
Added functions: =ADD A-C1
and =COPY G5

 DannySMc, on 24 May 2016 - 12:18 PM, said:

 TheRockettek, on 23 May 2016 - 06:19 PM, said:

KonLabs Office Bundle :P

I will actually name this under the Store xD As long as he can get out an alternative to:
Word
Powerpoint
Spreadsheet
Word is hard :(

Yeah it will be :/

#11 Selim

  • Members
  • 189 posts
  • LocationHiding in Online Storage

Posted 06 June 2016 - 02:30 AM

Suggestion: Make it able to read from CSV files. They are actually quite simple and should be easy enough to be able to load a spreadsheet from one.

#12 randomdude999

  • Members
  • 19 posts
  • LocationStar System Sol, Galactic Sector ZZ9 Plural Z Alpha

Posted 06 June 2016 - 05:45 PM

Some ideas for a text editor:
  • You could have an "insert mode", where the person enters text, and a "command mode", where they can control text color etc (yes I use vim).
  • Since ComputerCraft display is quite limited, there wouldn't be a lot of things to do in command mode, but they could control text/background color and maybe text alignment as well.
  • You could make the key to enter insert mode be "i" and to exit it Ctrl (can't use Esc since that exits the computer).
  • Maybe "b" background color control and "c" for text color.
  • And "a" to toggle alignment (between left, center and right, also justify if you implement it.).
  • Maybe select stuff with "s" then move to end point and "s" again. (Then you can apply color operations on it)
  • Maybe make a file menu accessible with "f" where you could save/open (/print? (color printing would be tedious)) stuff.
  • Maybe a status line that tells you what mode you are in and maybe the word count?
(I might have overused the word "maybe", but these are just suggestions)

#13 Emma

  • Members
  • 216 posts
  • Locationtmpim

Posted 06 June 2016 - 09:06 PM

 randomdude999, on 06 June 2016 - 05:45 PM, said:

--snip--
  • You could make the key to enter insert mode be "i" and to exit it Ctrl (can't use Esc since that exits the computer).
--snip--
Or, you could, ya no, just use the insert key.

#14 Konlab

  • Members
  • 595 posts
  • LocationKerbin

Posted 07 June 2016 - 05:57 PM

 randomdude999, on 06 June 2016 - 05:45 PM, said:

Some ideas for a text editor:
  • You could have an "insert mode", where the person enters text, and a "command mode", where they can control text color etc (yes I use vim).
  • Since ComputerCraft display is quite limited, there wouldn't be a lot of things to do in command mode, but they could control text/background color and maybe text alignment as well.
  • You could make the key to enter insert mode be "i" and to exit it Ctrl (can't use Esc since that exits the computer).
  • Maybe "b" background color control and "c" for text color.
  • And "a" to toggle alignment (between left, center and right, also justify if you implement it.).
  • Maybe select stuff with "s" then move to end point and "s" again. (Then you can apply color operations on it)
  • Maybe make a file menu accessible with "f" where you could save/open (/print? (color printing would be tedious)) stuff.
  • Maybe a status line that tells you what mode you are in and maybe the word count?
(I might have overused the word "maybe", but these are just suggestions)
I know vim too :)

The text editor is hard
Power point seems not that hard, but time consuming instead :(
And debugging this will be time consuming too, not sure if I can motivate myself ever

#15 randomdude999

  • Members
  • 19 posts
  • LocationStar System Sol, Galactic Sector ZZ9 Plural Z Alpha

Posted 07 June 2016 - 06:50 PM

 Incinirate, on 06 June 2016 - 09:06 PM, said:

 randomdude999, on 06 June 2016 - 05:45 PM, said:

--snip--
  • You could make the key to enter insert mode be "i" and to exit it Ctrl (can't use Esc since that exits the computer).
--snip--
Or, you could, ya no, just use the insert key.
Some new laptop keyboards don't even have an insert key. (For example my laptop (came preinstalled with win7))

 Konlab, on 07 June 2016 - 05:57 PM, said:

--snip--

I know vim too :)

The text editor is hard
Power point seems not that hard, but time consuming instead :(
And debugging this will be time consuming too, not sure if I can motivate myself ever
Maybe I can help with debugging?

#16 MKlegoman357

  • Members
  • 1,170 posts
  • LocationKaunas, Lithuania

Posted 08 June 2016 - 12:01 PM

 randomdude999, on 07 June 2016 - 06:50 PM, said:

Some new laptop keyboards don't even have an insert key. (For example my laptop (came preinstalled with win7))

All keyboards have an insert key. It might be hidden as a function key (fn). Or it's name might be shortened to something like "ins".

#17 Konlab

  • Members
  • 595 posts
  • LocationKerbin

Posted 09 June 2016 - 02:35 PM

 randomdude999, on 07 June 2016 - 06:50 PM, said:

Maybe I can help with debugging?
If you can find the source of bugs with copy pasting or with the copying I will give a HUGE CREDIT

#18 randomdude999

  • Members
  • 19 posts
  • LocationStar System Sol, Galactic Sector ZZ9 Plural Z Alpha

Posted 09 June 2016 - 09:14 PM

 MKlegoman357, on 08 June 2016 - 12:01 PM, said:

All keyboards have an insert key. It might be hidden as a function key (fn). Or it's name might be shortened to something like "ins".

Found it. fn+i. Completely unlabeled or anything. I just went to my text editor and started mashing keys with the fn key down.

#19 Bye.

  • Members
  • 59 posts

Posted 10 June 2016 - 09:42 PM

Hi, can I please add your program to my OS?

#20 Konlab

  • Members
  • 595 posts
  • LocationKerbin

Posted 11 June 2016 - 06:08 AM

 Checco2212, on 10 June 2016 - 09:42 PM, said:

Hi, can I please add your program to my OS?
Of course! :D





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users