Speadsheet view not editable in non EN Language

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.1 CE GA2, 6.2.X EE, 7.0.0 Alpha 5
• Fix Version/s: 6.2.X EE, 7.0.0 Beta 1
• Component/s: Dynamic Data Lists, Dynamic Data Lists > Display
• Labels:
  • liferay-fixpack-portal-162-6210
• Branch Version/s:
  6.2.x
• Backported to Branch:
  Committed
• Story Points: 6
• Fix Priority: 3
• Sprint: Sprint 07: Dec, 21 - Dec, 31
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/33767

1. Create new Data Definition with Default Language non US (German), no Translation Languages, add a Text Field.
2. Create a Data List View and add a Data List based on this Definition
3. Change language in your profile to non-US (German)
4. Add a record to the data list, save, refresh it, => all looks okay.
5. Change Configuration of Dynamic Data List View to Spreadsheet (Tabellenansicht), editable.
6. Add or modify record in spreadsheet view again => looks okay now,
7. but after any refresh => display for this record changes to NULL values.

Reason I found: Saving records in Spreadsheet view creates a default US record, which will be empty when working in other languages. After refresh, spreadsheet display switches to default US record where available. Non US entries were saved correctly, but no longer displayed.

Workaround: Stay away from attractive editable Spreadsheet view in non US environment.