Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2013-02

FPSpreadSheet keeps existent formulas?

6 messages · 3 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

silvioprog

Hello,

Can I write values in some cells but keeping the existents formulas? Demo for explain my doubt in attached.

Thank you!

Silvio Cl?cio My public projects - github.com/silvioprog -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20130218/5f8cfa68/attachment-0001.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: test.zip Type: application/zip Size: 4789 bytes Desc: not available URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20130218/5f8cfa68/attachment-0001.zip>

Reply by email

José Mejuto
to silvioprog

El 19/02/2013 0:52, silvioprog escribi?:

Show quoted text 5 lines
Hello, Can I write values in some cells but keeping the existents formulas? Demo for explain my doubt in attached.

Hello,

AFAIK no as the spreadsheet is fully loaded and interpreted (non interpreted information is discarded) and then saved.

Reply by email

Felipe Monteiro de Carvalho
to José Mejuto

Some days ago I finished RPN formula writing for BIFF8, but there is still no formula reading support.

One problem is that the topic of formulas is very large. Your example has only =A1+B1 which is very simple and should be easy to implement. What other formulas do you want to use?

Felipe Monteiro de Carvalho

Reply by email

silvioprog
to José Mejuto: El 19/02/2013 0:52, silvioprog escribi?: AFAIK no as the spreadsheet is fully loaded and…

2013/2/19 Jos? Mejuto

Show quoted text 12 lines
El 19/02/2013 0:52, silvioprog escribi?: Hello, > > Can I write values in some cells but keeping the existents formulas? > Demo for explain my doubt in attached. > > Hello, AFAIK no as the spreadsheet is fully loaded and interpreted (non interpreted information is discarded) and then saved.

So, I'm making a class to generate XLS reports. But I think I'll use RTF, it is a protocol easier to manipulate.

I'm seeing your code another email, I have not had time to do a merge it to PowerPDF. I'll do it as soon as possible. It will be very interesting to see the PowerPDF in FCL, and now with your help and the Michael it will be possible. :)

Silvio Cl?cio My public projects - github.com/silvioprog -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20130221/d282cc45/attachment.html>

Reply by email

silvioprog
to Felipe Monteiro de Carvalho: Some days ago I finished RPN formula writing for BIFF8, but there is still no formula…

2013/2/20 Felipe Monteiro de Carvalho

Some days ago I finished RPN formula writing for BIFF8, but there is still no formula reading support.

Hello,

You commited it in CCR? If yes, I'll update my CCR copy now. :)

One problem is that the topic of formulas is very large. Your example has only =A1+B1 which is very simple and should be easy to implement. What other formulas do you want to use?

Yes. I would use simple things like SUM, AVG etc. I saw that it also does not work well for resizing cells. Unfortunately it still does not handle simple spreadsheets (or I'm not using it correctly) like: http://www.sendspace.com/file/i06q5l

:| :/

Silvio Cl?cio My public projects - github.com/silvioprog -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20130221/7a608bbe/attachment-0001.html>

Reply by email

Felipe Monteiro de Carvalho
to silvioprog
silvioprog wrote
You commited it in CCR? If yes, I'll update my CCR copy now. :)

Yes, I commited to the lazarus-ccr subversion.

Yes. I would use simple things like SUM, AVG etc.

A full list is necessary.

I saw that it also does not work well for resizing cells. Unfortunately it still does not handle simple spreadsheets (or I'm not using it correctly) like: http://www.sendspace.com/file/i06q5l

Every single feature needs to be implemented in multiple places: generic, each reader and each writer

Felipe Monteiro de Carvalho

Reply by email