Excel内容变动,能不刷新后台缓存文件吗? 因为在excel里有做公式看板, 若多人同时操作会互相影响。

目前前端这块过滤时不会互相影响,但一旦页面刷新,系统会重新从后端获取最新的缓存文件。 而最新的缓存文件就是谁最后筛选的就是谁的筛选条件。

ccda8377d4eb7e9c120df500fe22b32e.png (70.0 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

  1. Implement a session management system to track user-specific filter settings.
  2. Ensure that the frontend retrieves and applies these settings without refreshing the backend cache.
  3. Test the implementation with multiple users to confirm that settings do not interfere with each other.

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