Comments (6)
Hi @thanhlevu
You are right, when I tested it it seemed to work. I asked our HyperFormula developer if that's indeed an intended behavior, as after more investigation, it seems not to work correctly. I'll let you know once I have more information.
from handsontable.
Hi @thanhlevu
This is actually a feature, but you can bypass it if you need to. There's a method afterFormulasValuesUpdate
that controls this. You can just make it return if there are any changes in, for example, column order. Here's an example: https://jsfiddle.net/handsoncode/k4qxj6af/
from handsontable.
Thank you so much for your time on my matter again.
I have reviewed your solution in jsfiddle,
with return;
, I see it does not help to bypass the changes of formula if column moved.
for example, move column B to A
Do you mean, I need to set a logic to revert the changes of formula in the afterFormulasValuesUpdate
hook ?
from handsontable.
wonderful @adrianszymanski89 ,
thank you once again.
from handsontable.
Hi @thanhlevu
I have an update for you. I get confirmation that this is a desired behavior, and it matches the industry standard, so it behaves the same in Excel, for example.
Because of that, it's not possible to alter this functionality, as it may break the fundamentals of the plugin behavior and make it unusable in general.
There might be a workaround to restore the initial formula each time the columns are manually moved with the setDataAtCell
hook, but it's inefficient. Here's an example: https://jsfiddle.net/handsoncode/8wadLzp5/
from handsontable.
Thank you for your reply. I see what you mean that it is not efficient if using setDataAtCell
.
Thank you for your help always.
from handsontable.
Related Issues (20)
- [Bug]: Installed 14.2 but having performance and display issue not seen with 13.0, also had to convert to ES5 HOT 16
- [Bug]: vue2 insert column disable? HOT 5
- How can i get the older version document, such as v6,v7? HOT 4
- [Bug]: Multiple sorting resets on the fifth click HOT 2
- [Bug]: custom rendorer called multiple times and did dom manipulation creating a slow performance and row misalignment HOT 2
- [Bug]: cell editor doesn't switch as intended on tab navigation between cells HOT 1
- [Bug]: Table crashes when entering a number value with a space between negative symbol and numbers HOT 1
- [Bug]: Vue 3 composition API ref error HOT 9
- Handsontable 14.3.0 is here!
- [Bug]: A bug caused by sheetRename HOT 2
- [Bug]: Property 'prototype' does not exist on type 'BaseEditor' HOT 7
- [Bug]: The bug about the ROUND function in the formula, why 21.9/0.2, keeping 0 decimal places, will get 109? In theory, the ROUND function should be rounded to 110. HOT 6
- [Bug]: In vue2, when using HotColumn slot, there is no readonly html style HOT 5
- [Bug]: Object array data source causes spliceRow call error: rowData.slice is not a function HOT 2
- [Bug]: How can the handsonTable component freeze columns on both sides HOT 4
- [Bug]: Context Menu: long texts are truncated HOT 1
- [Bug]: Submenu wrong positon when horizontal scrolling HOT 1
- [Bug]: When the table scrolls to the bottom of the page, click the date editor in the last row, the date editor will be blocked, please solve this problem, thank you HOT 1
- [Bug]: columnSummary does not include formulated cells HOT 1
- [Bug]: vue dev-tools, Select a component HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from handsontable.