search

jspreadsheet / ce

Jspreadsheet is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with other spreadsheet software.
https://bossanova.uk/jspreadsheet/v4
MIT License
6.73k stars 825 forks source link

formulas in data return text. Cell references using "=" return error #276

Closed pythonBerg closed 5 years ago

pythonBerg commented 5 years ago

I have carefully followed directions wrt to required libraries. When typing sum(range) in cell, it returns correct value. When placing =b3/b4 in data, results is not interpretted.

data = [ [1, 834000], [2, 834000], [3, 834000], [4, 834000,,'Cap Rates',.06,'7%','8%','9%','10%' ], [5, 834000,,'Value',"=b1*2",'=b2','=e4','=e5',834000/.1], [6, 834000], ];

1 834000
2 834000
3 834000
4 834000 Cap Rates 0.06 7% 8% 9% 10% 5 834000 Value =b1*2 =b2 =e4 =e5 8340000 6 834000
7 834000
8 834000

I have done my diligence looking for my error. Please point me in right direction

Using jquery 3.1.1 Thanks

pphod commented 5 years ago

Please, update your version to 3.5.7 and use capital letters.

B1*2, B2, E4, etc...

Regards,

On Thu, Jan 10, 2019 at 6:31 PM pythonBerg notifications@github.com wrote:

I have carefully followed directions wrt to required libraries. When typing sum(range) in cell, it returns correct value. When placing =b3/b4 in data, results is not interpretted.

data = [ [1, 834000], [2, 834000], [3, 834000], [4, 834000,,'Cap Rates',.06,'7%','8%','9%','10%' ], [5, 834000,,'Value',"=b1*2",'=b2','=e4','=e5',834000/.1], [6, 834000], ];

1 834000 2 834000 3 834000 4 834000 Cap Rates 0.06 7% 8% 9% 10% 5 834000 Value =b1*2 =b2 =e4 =e5 8340000 6 834000 7 834000 8 834000

I have done my diligence looking for my error. Please point me in right direction <script type="text/javascript" src="{% static 'node_modules/jexcel/dist/js/excel-formula.min.js' %}"> <script type="text/javascript" src="{% static 'node_modules/numeral/numeral.js' %}">

Using jquery 3.1.1 Thanks

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/paulhodel/jexcel/issues/276, or mute the thread https://github.com/notifications/unsubscribe-auth/AFvagdWKYY1ronG6LOubYOxM_GqodDsaks5vB4cNgaJpZM4Z6EZA .

pythonBerg commented 5 years ago

The capitalization makes big difference. Did you mean 3.5.7 or 1.5.7 for version? Should I be able to type into a cell =B4+B5? Any reference to other cells using '=' returns error in grid, thought it now works in data. I see the same in online examples so perhaps I am making too many assumptions about functionality.

Thanks

On Fri, Jan 11, 2019 at 6:20 AM Paul Hodel notifications@github.com wrote:

Please, update your version to 3.5.7 and use capital letters.

B1*2, B2, E4, etc...

Regards,

On Thu, Jan 10, 2019 at 6:31 PM pythonBerg notifications@github.com wrote:

I have carefully followed directions wrt to required libraries. When typing sum(range) in cell, it returns correct value. When placing =b3/b4 in data, results is not interpretted.

data = [ [1, 834000], [2, 834000], [3, 834000], [4, 834000,,'Cap Rates',.06,'7%','8%','9%','10%' ], [5, 834000,,'Value',"=b1*2",'=b2','=e4','=e5',834000/.1], [6, 834000], ];

1 834000 2 834000 3 834000 4 834000 Cap Rates 0.06 7% 8% 9% 10% 5 834000 Value =b1*2 =b2 =e4 =e5 8340000 6 834000 7 834000 8 834000

I have done my diligence looking for my error. Please point me in right direction <script type="text/javascript" src="{% static 'node_modules/jexcel/dist/js/excel-formula.min.js' %}"> <script type="text/javascript" src="{% static 'node_modules/numeral/numeral.js' %}">

Using jquery 3.1.1 Thanks

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/paulhodel/jexcel/issues/276, or mute the thread < https://github.com/notifications/unsubscribe-auth/AFvagdWKYY1ronG6LOubYOxM_GqodDsaks5vB4cNgaJpZM4Z6EZA

.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/paulhodel/jexcel/issues/276#issuecomment-453486711, or mute the thread https://github.com/notifications/unsubscribe-auth/AV1XMdRWnxKVUsR_r3YMybfE2j5lgHQ2ks5vCHORgaJpZM4Z6EZA .

pphod commented 5 years ago

Type =B4+B5 should work fine in the most recent version. Sorry, I meant v1.5.7

Regards,

On Fri, Jan 11, 2019 at 3:13 PM pythonBerg notifications@github.com wrote:

The capitalization makes big difference. Did you mean 3.5.7 or 1.5.7 for version? Should I be able to type into a cell =B4+B5? Any reference to other cells using '=' returns error in grid, thought it now works in data. I see the same in online examples so perhaps I am making too many assumptions about functionality.

Thanks

On Fri, Jan 11, 2019 at 6:20 AM Paul Hodel notifications@github.com wrote:

Please, update your version to 3.5.7 and use capital letters.

B1*2, B2, E4, etc...

Regards,

On Thu, Jan 10, 2019 at 6:31 PM pythonBerg notifications@github.com wrote:

I have carefully followed directions wrt to required libraries. When typing sum(range) in cell, it returns correct value. When placing =b3/b4 in data, results is not interpretted.

data = [ [1, 834000], [2, 834000], [3, 834000], [4, 834000,,'Cap Rates',.06,'7%','8%','9%','10%' ], [5, 834000,,'Value',"=b1*2",'=b2','=e4','=e5',834000/.1], [6, 834000], ];

1 834000 2 834000 3 834000 4 834000 Cap Rates 0.06 7% 8% 9% 10% 5 834000 Value =b1*2 =b2 =e4 =e5 8340000 6 834000 7 834000 8 834000

I have done my diligence looking for my error. Please point me in right direction <script type="text/javascript" src="{% static 'node_modules/jexcel/dist/js/excel-formula.min.js' %}"> <script type="text/javascript" src="{% static 'node_modules/numeral/numeral.js' %}">

Using jquery 3.1.1 Thanks

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/paulhodel/jexcel/issues/276, or mute the thread <

https://github.com/notifications/unsubscribe-auth/AFvagdWKYY1ronG6LOubYOxM_GqodDsaks5vB4cNgaJpZM4Z6EZA

.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/paulhodel/jexcel/issues/276#issuecomment-453486711, or mute the thread < https://github.com/notifications/unsubscribe-auth/AV1XMdRWnxKVUsR_r3YMybfE2j5lgHQ2ks5vCHORgaJpZM4Z6EZA

.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/paulhodel/jexcel/issues/276#issuecomment-453548662, or mute the thread https://github.com/notifications/unsubscribe-auth/AFvagY3U5TsS8LUHinxRgb9R6TYza9Fpks5vCKoYgaJpZM4Z6EZA .

pythonBerg commented 5 years ago

That does work, thanks.

On Fri, Jan 11, 2019 at 10:46 AM Paul Hodel notifications@github.com wrote:

Type =B4+B5 should work fine in the most recent version. Sorry, I meant v1.5.7

Regards,

On Fri, Jan 11, 2019 at 3:13 PM pythonBerg notifications@github.com wrote:

The capitalization makes big difference. Did you mean 3.5.7 or 1.5.7 for version? Should I be able to type into a cell =B4+B5? Any reference to other cells using '=' returns error in grid, thought it now works in data. I see the same in online examples so perhaps I am making too many assumptions about functionality.

Thanks

On Fri, Jan 11, 2019 at 6:20 AM Paul Hodel notifications@github.com wrote:

Please, update your version to 3.5.7 and use capital letters.

B1*2, B2, E4, etc...

Regards,

On Thu, Jan 10, 2019 at 6:31 PM pythonBerg notifications@github.com wrote:

I have carefully followed directions wrt to required libraries. When typing sum(range) in cell, it returns correct value. When placing =b3/b4 in data, results is not interpretted.

data = [ [1, 834000], [2, 834000], [3, 834000], [4, 834000,,'Cap Rates',.06,'7%','8%','9%','10%' ], [5, 834000,,'Value',"=b1*2",'=b2','=e4','=e5',834000/.1], [6, 834000], ];

1 834000 2 834000 3 834000 4 834000 Cap Rates 0.06 7% 8% 9% 10% 5 834000 Value =b1*2 =b2 =e4 =e5 8340000 6 834000 7 834000 8 834000

I have done my diligence looking for my error. Please point me in right direction <script type="text/javascript" src="{% static 'node_modules/jexcel/dist/js/excel-formula.min.js' %}"> <script type="text/javascript" src="{% static 'node_modules/numeral/numeral.js' %}">

Using jquery 3.1.1 Thanks

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/paulhodel/jexcel/issues/276, or mute the thread <

https://github.com/notifications/unsubscribe-auth/AFvagdWKYY1ronG6LOubYOxM_GqodDsaks5vB4cNgaJpZM4Z6EZA

.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <https://github.com/paulhodel/jexcel/issues/276#issuecomment-453486711 , or mute the thread <

https://github.com/notifications/unsubscribe-auth/AV1XMdRWnxKVUsR_r3YMybfE2j5lgHQ2ks5vCHORgaJpZM4Z6EZA

.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/paulhodel/jexcel/issues/276#issuecomment-453548662, or mute the thread < https://github.com/notifications/unsubscribe-auth/AFvagY3U5TsS8LUHinxRgb9R6TYza9Fpks5vCKoYgaJpZM4Z6EZA

.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/paulhodel/jexcel/issues/276#issuecomment-453559987, or mute the thread https://github.com/notifications/unsubscribe-auth/AV1XMXT5Ydp9JNeQ3QhWvfB7ssiZzJ4Nks5vCLHKgaJpZM4Z6EZA .