使用importrange函数下载文件失败-认为这是一个错误 [英] Downloading File with importrange function failing - think it's a bug

问题描述

一段时间以来，我一直在将Google表格保存到Excel中而没有任何问题.这些工作表始终已成功保存并使用importrange功能在Excel中打开.但是，最近它尚未成功正确保存.

I've been saving Google Sheets to Excel without any problems for a while. These sheets have always successfully saved and opened in Excel with the importrange function. However, recently it hasn't been successfully saving correctly.

它过去仅具有静态值(例如40).头行中的第一个单元格曾经存在IFERROR，但是现在它存在于每个单元格中.

It used to just have the static value (e.g, 40). There used to be an IFERROR in the first cell in the header row but now it exists in every single cell.

例如，每个单元格都将具有以下内容:

E.g, each cell would have something like this:

=IFERROR(__xludf.DUMMYFUNCTION(importrange(blahblah)),"40"). 

DUMMYFUNCTION引发错误，结果返回"40".但是"40"是一个字符串，而不是一个整数，会弄乱我所有的公式.

DUMMYFUNCTION throws an error and "40" is returned as a result. but "40" is a string, not an integer which messes up all my formulas.

我还知道这不是Excel问题，因为OpenOffice对该文件执行相同的操作.

I also know this isn't an Excel issue because OpenOffice is doing the same thing with the file.

我很确定这将是一个错误，因为它为什么要工作几个月，然后突然停止工作?

I'm pretty sure this would be a bug because why would it be working for months and then suddenly stop working?

我该怎么办?

推荐答案

我也认为这是一个错误.

I'm thinking it's a bug too.

• 仅使用IFERROR(__xludf.DUMMYFUNCTION(...复制和粘贴范围内的值，然后使用Excel的UI工具将显示为文本的数字转换为数字.
• 有选择地删除引起问题的单元格的IFERROR第二个参数上的引号
• 删除=IFERROR(__xludf.DUMMYFUNCTION(),"value")，除了value(为此，我们可以使用Excel的内置FIND& REPLACE)

• Copy and paste as values only the ranges with IFERROR(__xludf.DUMMYFUNCTION(..., then use Excel's UI tools to convert numbers shown as text to numbers.
• Selectively remove quotes on the IFERROR second argument of the cells causing problems
• Remove =IFERROR(__xludf.DUMMYFUNCTION(),"value") except value (we could use Excel's built-in FIND & REPLACE for this)

• 仅在具有公式具有不兼容功能(例如IMPORTRANGE，QUERY，FILTER等)的范围区域上使用复制">粘贴"作为值.
• 如果只需要这些值，请以CSV而不是XLSX的格式下载

为了帮助确定此问题的优先级，请向Google发送反馈.为此，请打开Goog​​le表格电子表格，点击帮助>报告问题，然后填写反馈表单并提交.

In order to help to prioritize this issue, send feedback to Google. To do this open a Google Sheets spreadsheet, click on Help > Report a problem, then fill the feedback form and submit it.

我用西班牙语发布了5篇关于此的小文章.您可以在 https://www.rubenrivera.mx/p/上找到它们descargar-hcg-excel.html .

I posted 5 small articles about this in Spanish. You could find them listed on https://www.rubenrivera.mx/p/descargar-hcg-excel.html.

这篇关于使用importrange函数下载文件失败-认为这是一个错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！