search

statisticssweden / PxWeb

Web application for disseminating statistical tables
https://www.scb.se/pxweb
Apache License 2.0
34 stars 23 forks source link

Multiple footnotes produced in Excel for saved queries #47

Open MikaelNordberg opened 4 years ago

MikaelNordberg commented 4 years ago

If a saved query contains an operation that causes the following footnote to be displayed:

"The text in the table differs from the original in the database, because it has been changed manually"

An extra footnote with this text is added each time the saved query is called.

likp commented 4 years ago

@MikaelNordberg Could you update the issue with steps to reproduce the problem.

MikaelNordberg commented 4 years ago

Steps to reproduce the problem:

  1. Make a selection for a table and go to the table presentation view of PxWeb
  2. Perform a Sum operation on the table (summarize all the periods for example)
  3. Create a saved query where the output is in .xlsx format. (or use this one: http://pxwebdemo.scb.se/sq/d170450a-0ed5-47cd-8c37-cbbc26a7ec57)
  4. Call the saved query. The first time it will have one footnote telling "The text in the table differs from the original in the database, because it has been changed manually"
  5. Call the saved query again. Now it will have two footnotes. And so on...
Pates93 commented 3 years ago

Hi.

We ran into this exact problem, when we preformed some operations on a table and saved it to a saved query.

But for us we got the string "The text in the table differs from the original in the database, because it has been changed manually" in Faroese regardless what language was selected.

image

Seems like there is an extra bug with translation when displaying this sting.

Just a heads up for when this bug will be fixed :)