Export an ods table from jabref is messing it up

[AngelicaRibeiro]

JabRef version

5.3 (latest release)

Operating system

Other (please describe below)

Details on version and operating system

Manjaro linux / Windows 10

Checked with the latest development build

• [X] I made a backup of my libraries before testing the latest development version.
• [X] I have tested the latest development version and the problem persists

Steps to reproduce the behaviour

1. Added extra columns to the entrie table
2. Exported all entries with all the columns added by the menuFile > Export > Export All Entries to old office / libre office format
3. Saved to .ods file
4. when I've openned the .ods file it shows just the following fist 34 colluns if passes it it shows Custom# where # is the number the costom number starting from 1 to N.
5. So as a result it doesn't show the included columns in jabref to the ods file.

I've included all the collums that jabref permits

[AngelicaRibeiro]

jabrefBug.ods

[dhruvshar]

@Siedlerchr I would like to take this up!

[Siedlerchr]

@dhruvshar Go ahead, make sure to follow the steps for https://devdocs.jabref.org/contributing and setting up the workspace. https://devdocs.jabref.org/getting-into-the-code/guidelines-for-setting-up-a-local-workspace

The goal would be to have all fields exported, respecting the export settings for current table sort order etc

[koppor]

OpenOfficeDocumentCreator and https://github.com/JabRef/jabref/blob/main/src/main/java/org/jabref/logic/exporter/OOCalcDatabase.java

[HoussemNasri]

@koppor isn't .ods handled by OpenDocumentSpreadsheetCreator?

[AngelicaRibeiro]

I've tested here by uploading a library in a bibtex file, and with doubled embraces and it does not recognize the atributs at all . E.g:

@article{Tsekoura2020,
  abstract     = {{In this paper, we present the classification of electroencephalograph (EEG) signals produced by the first-octave musical notes of the piano as stimuli. The EEG classification of musical notes is attempted for the first time, to the best of our knowledge. This type of classification could be applied towards the development of Brain-Computer Interfaces (BCIs) for the composition of music via thought as well as the definition of mappings between different stimuli for Sensory Substitution Devices (SSDs) that are based on their actual impact on brain signals and thus serve better the purpose of SSDs, which is to translate between senses at the perceptual level. Event-Related Spectral Perturbations (ERSP) are extracted as features and are fed into a Support Vector Machine (SVM) classifier. Our aim was to classify musical notes as C, C#, D, D#, E, F, F#, G, G#, A, A#, B and we have achieved it with an average accuracy of 70%.}},
  address      = {{x}},
  annote       = {{x}},
  author       = {{Tsekoura, Konstantina and Foka, Amalia}},
  booktitle    = {{x}},
  chapter      = {{x}},
  comment      = {{x}},
  crossref     = {{x}},
  doi          = {{10.1016/j.eswa.2020.113507}},
  edition      = {{x}},
  editor       = {{x}},
  eprint       = {{x}},
  file         = {{x}},
  groups       = {{x}},
  howpublished = {{x}},
  institution  = {{x}},
  isbn         = {{x}},
  issn         = {{0957-4174}},
  journal      = {{Expert Systems with Applications}},
  keywords     = {{Auditory Evoked Potentials,Brain-Computer Music Interface (BCMI),Electroencephalography (EEG),Event-Related Spectral Perturbations (ERSP),Support Vector Machine (SVM)}},
  mendeley-tags = {{x}},
  month        = {{x}},
  note         = {{x}},
  number       = {{x}},
  organization = {{x}},
  owner        = {{x}},
  pages        = {{113507}},
  printed      = {{x}},
  priority     = {{x}},
  publisher    = {{Elsevier Ltd}},
  qualityassured = {{x}},
  ranking      = {{x}},
  readstatus   = {{x}},
  relevance    = {{x}},
  school       = {{x}},
  series       = {{x}},
  timestamp    = {{x}},
  title        = {{Classification of EEG signals produced by musical notes as stimuli}},
  type         = {{x}},
  url          = {{https://www.sciencedirect.com/science/article/pii/S0957417420303316}},
  volume       = {{159}},
  year         = {{2020}},
}

embraces.ods ..

[Siedlerchr]

Thanks again for the sample. @HoussemNasri is already working on a fix.

[Siedlerchr]

This is now implemented in the latest development version! https://builds.jabref.org/main/