Search found 52 matches

by dbickin
Jul 10, 2020 14:43
Forum: General
Topic: Embedding a Spreadsheet
Replies: 35
Views: 1437

Re: Embedding a Spreadsheet

an old post, may be useful https://ewbi.blogs.com/develops/popular/excelformulaparsing.html Thanks. I ended up realizing I needed to figure out exactly what "minimally functional" spreadsheet would need to do. Most of the Gui toolkits could handle displaying and entering data in a grid. A...
by dbickin
Jul 06, 2020 1:47
Forum: General
Topic: Embedding a Spreadsheet
Replies: 35
Views: 1437

Re: Embedding a Spreadsheet

Thanks TJF. I finally had time to try to understand your code. I read the code, but haven't tried to compile it, or test it. I think I have convinced myself that it does allow for COS(A1). (ie the cosine of the value in cell A1) But I am guessing for simplicity you omitted processing any functions t...
by dbickin
Jul 02, 2020 3:45
Forum: General
Topic: Embedding a Spreadsheet
Replies: 35
Views: 1437

Re: Embedding a Spreadsheet

This looks like exactly what I want. This Pascal solution implements a complex custom type for the RPN stack, which makes the solver complicated. IMHO it's better to operate with two stacks (value/RPN). This answer confuses me.... not too hard to do. I suspect because you are answering a question I...
by dbickin
Jul 02, 2020 3:27
Forum: General
Topic: Embedding a Spreadsheet
Replies: 35
Views: 1437

Re: Embedding a Spreadsheet

oyster wrote:I suggest to focus on your own application, and embed JavaScript code in application


Would that JS run in client in a embedded html viewer in my code, or would a server have to be set up?

David
by dbickin
Jun 30, 2020 22:07
Forum: General
Topic: Embedding a Spreadsheet
Replies: 35
Views: 1437

Re: Embedding a Spreadsheet

perhaps this might be of some value https://wiki.freepascal.org/RPN_Formulas_in_FPSpreadsheet This looks like exactly what I want. Assuming you can put two sWorkSheetGrid controls on one form, with other non-spreadsheet related controls in the same form. Is there an "easy" way to link the...
by dbickin
Jun 30, 2020 2:50
Forum: General
Topic: Embedding a Spreadsheet
Replies: 35
Views: 1437

Re: Embedding a Spreadsheet

Wow! Thanks. Well, at least is DOES handle cell references in its expression parser. Unrelated, I was checking out the packages in a Linux distro, and saw "Gnu spreadsheet Widget" Excitedly I went to its website, only to see "Documentation is currently not available." Undeterred,...
by dbickin
Jun 30, 2020 1:13
Forum: General
Topic: Embedding a Spreadsheet
Replies: 35
Views: 1437

Re: Embedding a Spreadsheet

I agree. Unfortunately, all of the FB parsers I have come across have made the tacit assumption that the formula is going to return a number and that is arguments are going to be numbers. Not true for my problem domain. Actually, I don't think I've seen any that can have the argument of a function, ...
by dbickin
Jun 28, 2020 15:22
Forum: General
Topic: Embedding a Spreadsheet
Replies: 35
Views: 1437

Re: Embedding a Spreadsheet

it may be better to do all evaluation on the LUA side, just passing the pointer of the table and the formular to evaluate. I don't know LUA. Is parsing B1 to a value from the table something that LUA simply knows how to do, or is that something I would have to code? The IUPCells sample broke "...
by dbickin
Jun 27, 2020 14:52
Forum: General
Topic: Embedding a Spreadsheet
Replies: 35
Views: 1437

Re: Embedding a Spreadsheet

@krcko : Thanks, I'll see if I can work with SEE. Since I need arguments and results to be either numbers or text, I will have to change the doubles in the code to variant-types. And then figure out how to translate cell and range references to something that SEE can use. SEE actually scares me with...
by dbickin
Jun 26, 2020 16:52
Forum: General
Topic: Embedding a Spreadsheet
Replies: 35
Views: 1437

Embedding a Spreadsheet

Hi, For a project I want to do, I need to embed a "reasonably functional" spreadsheet inside a program window. My google skills are not great, but I have not found anything that will do what I want. gtksheet provides a spreadsheet that can be embedded in a gtk window, but as near as I can ...
by dbickin
Jun 15, 2020 18:34
Forum: Beginners
Topic: DIR is driving me nuts.
Replies: 19
Views: 663

Re: DIR is driving me nuts.

It compiled and ran fine for me using fbc 1.06 linux 64 bits.

I only got your error when forcing it to use -lang qb.

If you are using an IDE, could it be set up to set the lang to qb?

David
by dbickin
Jul 27, 2019 23:43
Forum: Projects
Topic: JSON library (0.20.2)
Replies: 36
Views: 17913

Re: JSON library (0.20.2)

Thanks for looking at this. I recompiled with the define and am getting: fbJSON Error: Invalid number '0' encountered at position 449 one line 1. fbJSON Error: Expected key at position 455 on line 1, found ":" instead. Position 449 appears to be the end of "lat":0.0 The program e...
by dbickin
Jul 22, 2019 12:53
Forum: Projects
Topic: JSON library (0.20.2)
Replies: 36
Views: 17913

Re: JSON library 1.01

Couldn't find a dedicated support forum for this library elsewhere, so I will ask here. I am trying to use this library, and I like what I see. It works EXCEPT that it does not like the data below. The source is a array of objects like this. It can read all the objects except this one. It appears to...
by dbickin
Jun 06, 2018 3:26
Forum: General
Topic: time zone conversion
Replies: 4
Views: 465

Re: time zone conversion

Thanks, lizard. That will let me handle the time zone conversion. Then I have to deal with daylight savings time.

David
by dbickin
Jun 05, 2018 13:01
Forum: General
Topic: time zone conversion
Replies: 4
Views: 465

time zone conversion

I have a data file with times in it. However, the file is a mixture of different timezones: Mostly "Etc/GMT" and "America/New_York". I want to convert them to local time for display. It looks like the built in time functions don't handle time zones, so can anyone recommend a libr...

Go to advanced search