目前前端这块过滤时不会互相影响,但一旦页面刷新,系统会重新从后端获取最新的缓存文件。 而最新的缓存文件就是谁最后筛选的就是谁的筛选条件。
请问针对这种情况有没有解决方案啊?
看板demo.7z (22.9 KB)
目前前端这块过滤时不会互相影响,但一旦页面刷新,系统会重新从后端获取最新的缓存文件。 而最新的缓存文件就是谁最后筛选的就是谁的筛选条件。
请问针对这种情况有没有解决方案啊?
看板demo.7z (22.9 KB)
@feng.qun.zhu.avaryholding.com
Cause
When multiple users are working on an Excel file with formulas, refreshing the backend cache can lead to conflicts, as the last user’s filter settings overwrite those of others. This disruption can hinder collaborative efforts, especially when users depend on real-time data.
Solution
To prevent the backend cache from refreshing and overwriting user-specific settings, implement a mechanism that allows users to maintain their own session states or filter settings. This can be achieved by using unique identifiers for each user’s session, which will help manage individual filter states without interference.
Code
Here’s a basic approach to manage user-specific settings:
// Pseudo-code for managing user sessions
public class UserSession
{
public string UserId { get; set; }
public Dictionary<string, string> FilterSettings { get; set; }
}
// Store user sessions
private Dictionary<string, UserSession> userSessions = new Dictionary<string, UserSession>();
public void UpdateUserFilter(string userId, string filterKey, string filterValue)
{
if (!userSessions.ContainsKey(userId))
{
userSessions[userId] = new UserSession { UserId = userId, FilterSettings = new Dictionary<string, string>() };
}
userSessions[userId].FilterSettings[filterKey] = filterValue;
}
// Retrieve user-specific filter settings
public Dictionary<string, string> GetUserFilter(string userId)
{
return userSessions.ContainsKey(userId) ? userSessions[userId].FilterSettings : new Dictionary<string, string>();
}
Next Steps
Please proceed with these steps to enhance collaboration in your Excel file. Let me know if you need further assistance!
@feng.qun.zhu.avaryholding.com
目前还不支持实时刷新后端缓存文件。
我们已经在内部问题跟踪系统中打开了以下新问题单,并将根据Free Support Policies中提到的条款提供修复。
问题单号:CELLSGRIDJS-1737