相同的电子表格，相同的单元格，但结果不同，用户不同 [英] Same spreadsheet, same cell, but different results, with different user

问题描述

从今天开始，我在使用Google表格时遇到了问题. 我用来从其他工作表(在同一电子表格中)获取金额的电子表格.

I have a problem with Google sheets since today. The spreadsheet I use to get an amount from a different sheet (within the same spreadsheet).

但是同一张纸会根据用户是谁给出不同的结果.

But the same sheet gives different results depending on who is the user.

在此图像的示例中，对于user A，它是Cell J5，它是€ -50,00，对于user B，它是€ -5000,00 似乎与value()有关(这是我在Twitter上看到的，因为从今天开始，许多人都遭受这个问题的困扰)

In the example in this image it's Cell J5 for user A it is € -50,00 but for user B it is € -5000,00 It seems something to do with value() (it's what I saw on twitter, as many people suffer from this problem since today)

一旦使用了它们的功能值. (将文本转换为数字)，具体取决于用户.

Once their function value is used. (To convert text to a number) It goes wrong depending on the user.

但是我无法确定用户A和用户B中的设置之间的区别

But I can not find out a difference between settings in user A and user B

我的问题是:

是否有人已经知道如何解决此问题(从今天开始似乎已经发生)

Does anyone already know how to solve this issue (which seems to occur since today)

推荐答案

• 美国语法:
  • =VALUE(1.1) = 1.1
  • =VALUE(1,1) = #N/A 或 #VALUE!
  • US syntax:
    • =VALUE(1.1) = 1.1
    • =VALUE(1,1) = #N/A or #VALUE!
    • =VALUE(1,1) = 1,1
    • =VALUE(1.1) = #N/A 或 #VALUE!

    要查找的两个电子表格之间的区别是区域设置:

    这篇关于相同的电子表格，相同的单元格，但结果不同，用户不同的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！