Export as OpenOffice/LibreOffice CSV not escaping commas within the abstract field (i.e. Custom1)

adrianocorrea commented 2 years ago

JabRef version

5.7 (latest release)

Operating system

Windows

Details on version and operating system

Windows 11 21H2

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

Create a library with the following entries:

@Article{Belkhouja2021,
  author   = {Belkhouja, Mustapha and Fattoum, Senda and Yoon, Hyungseok (David)},
  title    = {Does greater diversification increase individual productivity? {The} moderating effect of attention allocation.},
  issn     = {00487333},
  number   = {6},
  volume   = {50},
  abstract = {∙ This study investigates how scholars' diversification of their portfolio of research disciplines and coauthors affects their research productivity. ∙ A moderate level of knowledge diversification is optimal for research productivity when the level of cognitive attention is low. ∙ A high level of knowledge diversification is beneficial for research productivity when the level of cognitive attention is high. ∙ A moderate level of collaborator diversification coupled with a high level of collaborative attention is optimal for research productivity. Despite the consensus on the "double-edged sword" effect of diversification (of knowledge and collaborators) on individual performance, little is known about the contingencies that affect the relationship between diversification and individual productivity. Drawing on the attention-based view, we theorize the moderating role of attention allocation to advance our understanding of the curvilinear relationship between diversification (of knowledge and collaborators) and individual productivity. Relevant hypotheses are tested using a longitudinal sample of more than 25,000 individual scholars. Our analysis reveals that although a moderate level of knowledge diversification is optimal for research productivity when the level of cognitive attention is low, a high level of knowledge diversification is more beneficial for research productivity when the level of cognitive attention is high. Furthermore, we show that a moderate level of collaborator diversification, coupled with a high level of collaborative attention, is optimal for research productivity. Our study provides important implications for highly skilled and creative individuals. [ABSTRACT FROM AUTHOR]},
  journal  = {Research Policy},
  keywords = {Attention, Cognition, Collaboration, Diversification, Portfolio diversification, Research productivity},
  month    = jul,
  year     = {2021},
}
@Article{Dai2019,
  author   = {Dai, Weiqi and Liao, Mingqing},
  title    = {Entrepreneurial attention to deregulations and reinvestments by private firms: {Evidence} from {China}.},
  doi      = {10.1007/s10490-018-9574-z},
  issn     = {02174561},
  note     = {Publisher: Springer Nature},
  number   = {4},
  pages    = {1221--1250},
  volume   = {36},
  abstract = {To increase the understanding of entrepreneurship in China and contribute to the view that deregulation facilitates the rapid development of the private sector in transitional economies, we examine the positive relationship between entrepreneurial attention to deregulation (formal institution at the country level) and reinvestment by Chinese private firms. We supplement this main aim by identifying two moderating factors: the entrepreneurs' political connections (informal institution) and the regional institution development (formal institution at the regional level). We also explore how the interaction of political connections and regional institution development moderate the "entrepreneurial attention to deregulation-reinvestment" link. We find support for our hypotheses from survey data on 3,284 private firms in China. This paper contributes to the research on the relationship between institution and entrepreneurship in general and the association of deregulation and reinvestment in particular by considering two categories of institutional arrangements (formal and informal institutions; national and regional institutions) simultaneously and by exploring the antecedent of reinvestment from a fresh perspective—the attention-based view, highlighting the importance of "noticed" or "perceived" deregulation that influences entrepreneurial decision-making. [ABSTRACT FROM AUTHOR]},
  journal  = {Asia Pacific Journal of Management},
  keywords = {Attention-based view, China, Deregulation, Institutional theory, Political connections, Private sector, Regional institutions, Reinvestment, Rural development, Transition economies},
  month    = dec,
  year     = {2019},
}

Go to File>Export>Export all entries and select OpenOffice/LibreOffice CSV (*.csv). Save the file.
Open the saved file with OpenOffice or Excel.
Go to column "AA", labelled "Custom1". You will notice that the abstract field spills over to columns "Custom2", "Custom3", etc. However, the expected behaviour would be for the abstract to be solely in column "Custom1" (see OpenOffice Export Layout).

Appendix

No response

roryoday commented 1 year ago

Could I be assigned this issue?

github-actions[bot] commented 1 year ago

As a general advice for newcomers: check out Contributing for a start. Also, guidelines for setting up a local workspace is worth having a look at.

Feel free to ask here at GitHub, if you have any issue related questions. If you have questions about how to setup your workspace use JabRef's Gitter chat. Try to open a (draft) pull-request early on, so that people can see you are working on the issue and so that they can see the direction the pull request is heading towards. This way, you will likely receive valuable feedback.

Ravitwr commented 1 year ago

Could I be assigned this issue?

JabRef / jabref