Undefined Behavior for Custom Formatted xlsx linked Spreadsheet

オープン
#3,804 コメント 1 件 リアクション 1 件 担当者 0 名 GitHub で見る

メンテナーはふだん 1 日以内に返信

まだ誰も着手していません。

評価

難易度
4/5
見積もり時間
3〜5日
初心者へのやさしさ
48/100
issue の種類
バグ
明瞭さ
おおむね明確
活発さ
活発
技術スタック
javascript
領域
backend, data

調査の方向性

Start by examining the spreadsheet response export and row-append entry points; the issue does not name files or tests. Reproduce with a formatted, linked XLSX file containing an added column, then submit a response after upgrading from Forms 5.2.4 to 5.4.1. Done means existing spreadsheet contents and formatting remain intact and the new answer is appended as a row.

索引モデルが issue の本文から書いたものです。

説明

0. Needs triage bug needs info

Please use the 👍 reaction to show that you are affected by the same issue. Please don't comment if you have no relevant information to add!

Describe the bug
On upgrade to newer version of nextcloud when the linked spreadsheet is formatted via the nextcloud office or a local microsoft excel app, the whole table is wiped.
After that unlink and relink it to a new spreadsheet then formatting it as desired, no new row is going to be added.

To Reproduce
Steps to reproduce the behavior:

one quick note: consider that we are using complex English-Persian language to fill out forms.

  1. Create a form from an older version - forms-v5.2.4.tar.gz
  2. Fill out the form with a couple of answers.
  3. Link the responses to a xlsx spreadsheet.
  4. Format the spreadsheet using your desired excel application.
  5. Add new column at the end as well.
  6. Save and sync the spreadsheet.
  7. Upgrade the forms to version 5.4.1
  8. Add a new response
  9. You should that the entire form is wiped out except the title.
  10. If you try and relink it to an entire file then formatting it as desired, no new row is going to be added

Expected behavior New answers should be saved at the end of the sheets.

Screenshots
Unfortunately a screenshot of a wiped clean spreadsheet is not going to be helpful.

Nextcloud (please complete the following information):

  • Nextcloud-Version: 33.0.10
  • Forms-Version: 5.2.4 upgraded to 5.4.1

Desktop (please complete the following information):

  • OS: Linux Server -- Windows, iOS, Android clients.
  • Browser Any
  • Version [e.g. 22]

Smartphone (please complete the following information):

  • Device:
  • OS:
  • Browser
  • Version

Browser log
After re-exporting to spreadsheet for multiple times:

index.mjs:44 [WARN] viewer: Some mimes were ignored because they are not enabled in the server previews config Object
log @ index.mjs:44
index.mjs:47 [ERROR] viewer: The following mime is already registered Object
log @ index.mjs:47
search.js:22 Initializing unified search plugin-filters from talk
NotificationsApp.vue:455 Notifications permissions denied
NotificationsApp.vue:230 Has notify_push enabled, slowing polling to 15 minutes
NotificationsApp.vue:412 Polling interval updated to 900000
NotificationsApp.vue:279 Started background fetcher as session_keepalive is enabled
NotificationsApp.vue:368 Got notification data, restoring default polling interval.
index.mjs:44 [WARN] @nextcloud/vue: Found no locale to load. Object
log @ index.mjs:44

Additional context
Everything was fine in the last version.

主要言語
JavaScript
スター
385
フォーク
133
平均マージ
7時間 54分
マージ済み PR(30日)
157

環境構築

Codespaces で開く

このプロジェクトの開発コンテナを、あなたの GitHub アカウントでブラウザ上に起動します。

はじめの一歩

  1. issue を最後まで読み、次にプロジェクトのコントリビューションガイドを読みます。
  2. 着手することを issue にコメントします — 二人が同じ作業をするのを防げます。
  3. リポジトリをフォークし、ブランチを切って変更します。
  4. issue 番号を参照したプルリクエストを送ります。

nextcloud/forms のほかの issue

nextcloud/forms の issue をすべて見る

似ている issue

JavaScript の issue をもっと見る

新しい issue をメールで受け取る

初心者向けの GitHub issue を短くまとめたダイジェスト。