github-starred/libxlsxwriter
2
0
Fork 0
mirror of https://github.com/jmcnamara/libxlsxwriter.git synced 2026-05-15 14:15:54 -06:00
Code Issues 16 Projects Packages Wiki Activity Actions

[GH-ISSUE #186] Align X Axis labels #152

New issue
Closed
opened 2026-05-05 11:47:46 -06:00 by gitea-mirror · 8 comments
gitea-mirror commented 2026-05-05 11:47:46 -06:00
Owner
Copy link

Originally created by @j15e on GitHub (Jun 14, 2018).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/186

Originally assigned to: @jmcnamara on GitHub.

It looks like axis labels alignement (c:lblAlgn) is hardcoded to ctr (center).

I would like to know if there is a way to change this property with the current library that I am not aware of? Or it would require a new feature on the chart writer?

Here are the revelant parts :

1 - An axis is created :
b616fb59ff/src/chart.c (L4028-L4032)

2 - A c:lblAlgn element is added :
b616fb59ff/src/chart.c (L4093-L4094)

3 - Element is added with ctr value :
b616fb59ff/src/chart.c (L3204-L3215)

PS I have been using your library with https://github.com/Paxa/fast_excel, I must say a big thanks, this is pretty well done!

Originally created by @j15e on GitHub (Jun 14, 2018). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/186 Originally assigned to: @jmcnamara on GitHub. It looks like axis labels alignement (`c:lblAlgn`) is hardcoded to `ctr` (center). I would like to know if there is a way to change this property with the current library that I am not aware of? Or it would require a new feature on the chart writer? Here are the revelant parts : 1 - An axis is created : https://github.com/jmcnamara/libxlsxwriter/blob/b616fb59ffe0268b1ee0cecf822bf8ed45cf4f30/src/chart.c#L4028-L4032 2 - A `c:lblAlgn` element is added : https://github.com/jmcnamara/libxlsxwriter/blob/b616fb59ffe0268b1ee0cecf822bf8ed45cf4f30/src/chart.c#L4093-L4094 3 - Element is added with `ctr` value : https://github.com/jmcnamara/libxlsxwriter/blob/b616fb59ffe0268b1ee0cecf822bf8ed45cf4f30/src/chart.c#L3204-L3215 PS I have been using your library with https://github.com/Paxa/fast_excel, I must say a big thanks, this is pretty well done!
gitea-mirror 2026-05-05 11:47:46 -06:00
gitea-mirror commented 2026-05-05 11:47:52 -06:00
Author
Owner
Copy link

@jmcnamara commented on GitHub (Jun 14, 2018):

That internal property may not be what you think it is.

What specific feature in Excel do you wish to change?

<!-- gh-comment-id:397457790 --> @jmcnamara commented on GitHub (Jun 14, 2018): That internal property may not be what you think it is. What specific feature in Excel do you wish to change?
gitea-mirror commented 2026-05-05 11:47:55 -06:00
Author
Owner
Copy link

@j15e commented on GitHub (Jun 14, 2018):

The alignment of labels on the X axis like this :
unnamed-7

<!-- gh-comment-id:397458232 --> @j15e commented on GitHub (Jun 14, 2018): The alignment of labels on the X axis like this : ![unnamed-7](https://user-images.githubusercontent.com/143380/41441556-1d4c27d2-7001-11e8-8dc8-f804023cb1cc.png)
gitea-mirror commented 2026-05-05 11:47:59 -06:00
Author
Owner
Copy link

@j15e commented on GitHub (Jun 14, 2018):

We want to do this to align the labels when creating an histogram, to make it clear the label is for the end of each histogram bucket (ex. the last column represent >725 to 750, not 750 to 775).

<!-- gh-comment-id:397458776 --> @j15e commented on GitHub (Jun 14, 2018): We want to do this to align the labels when creating an histogram, to make it clear the label is for the end of each histogram bucket (ex. the last column represent >725 to 750, not 750 to 775).
gitea-mirror commented 2026-05-05 11:48:01 -06:00
Author
Owner
Copy link

@jmcnamara commented on GitHub (Jun 14, 2018):

Ok. Got it.

That isn't currently supported. I'll need to put it into the Python and Perl versions first and then port it across. Your patch looks okay though so you can use that in the meantime.

<!-- gh-comment-id:397461041 --> @jmcnamara commented on GitHub (Jun 14, 2018): Ok. Got it. That isn't currently supported. I'll need to put it into the Python and Perl versions first and then port it across. Your patch looks okay though so you can use that in the meantime.
gitea-mirror commented 2026-05-05 11:48:04 -06:00
Author
Owner
Copy link

@j15e commented on GitHub (Jun 14, 2018):

Thanks, I hope my patch help implementing Python and Perl versions.

<!-- gh-comment-id:397463437 --> @j15e commented on GitHub (Jun 14, 2018): Thanks, I hope my patch help implementing Python and Perl versions.
gitea-mirror commented 2026-05-05 11:48:06 -06:00
Author
Owner
Copy link

@jmcnamara commented on GitHub (Sep 1, 2018):

Added in version 0.7.9.

<!-- gh-comment-id:417889973 --> @jmcnamara commented on GitHub (Sep 1, 2018): Added in version 0.7.9.
gitea-mirror commented 2026-05-05 11:48:09 -06:00
Author
Owner
Copy link

@jmcnamara commented on GitHub (Sep 2, 2018):

P.S. I changed the function name and enums slightly to make them consistent (or equally inconsistent) with existing code. See the changes in f7f32de

<!-- gh-comment-id:417931760 --> @jmcnamara commented on GitHub (Sep 2, 2018): P.S. I changed the function name and enums slightly to make them consistent (or equally inconsistent) with existing code. See the changes in f7f32de
gitea-mirror commented 2026-05-05 11:48:10 -06:00
Author
Owner
Copy link

@j15e commented on GitHub (Sep 4, 2018):

Thanks for the hint, I will update my code accordingly when going back to the official repo. 👍

<!-- gh-comment-id:418386236 --> @j15e commented on GitHub (Sep 4, 2018): Thanks for the hint, I will update my code accordingly when going back to the official repo. 👍
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
coverity
cmake-improvements
cmake_pkgconfig_fix
ctest
button
tables
autofilter
dtoa
iwyu
openssl
gentoo
gh310
condition_format
rich_string_html
header_footer_images
custom_data_labels
object_position
gh265
constant_mode_comments2
constant_mode_comments
vml
md5
vcpkg
hyperlinks
api_refactor
win_fopen
gh203
rich_strings
chartsheet
in_mem_image
gh192
revert-162-master
data_validation
meson
charts
scan_build
utf8_strlen
tmpfileplus
custom_properties
insert_image
default_row
control_chars
worksheet_protect
dev
red_black
panes
mkstemp
defined_names
optimise
wip
v1.2.4
v1.2.3
v1.2.2
v1.2.1
v1.2.0
v1.1.9
v1.1.8
RELEASE_1.1.7
RELEASE_1.1.6
RELEASE_1.1.5
RELEASE_1.1.4
RELEASE_1.1.3
RELEASE_1.1.2
RELEASE_1.1.1
RELEASE_1.1.0
RELEASE_1.0.9
RELEASE_1.0.8
RELEASE_1.0.7
RELEASE_1.0.6
RELEASE_1.0.5
RELEASE_1.0.4
RELEASE_1.0.3
RELEASE_1.0.2
RELEASE_1.0.1
RELEASE_1.0.0
RELEASE_0.9.9
RELEASE_0.9.8
RELEASE_0.9.7
RELEASE_0.9.6
RELEASE_0.9.5
RELEASE_0.9.4
RELEASE_0.9.3
RELEASE_0.9.2
RELEASE_0.9.1
RELEASE_0.9.0
RELEASE_0.8.9
RELEASE_0.8.8
RELEASE_0.8.7
RELEASE_0.8.6
RELEASE_0.8.5
RELEASE_0.8.4
RELEASE_0.8.3
RELEASE_0.8.2
RELEASE_0.8.1
RELEASE_0.8.0
RELEASE_0.7.9
RELEASE_0.7.8
RELEASE_0.7.7
RELEASE_0.7.6
RELEASE_0.7.5
RELEASE_0.7.4
RELEASE_0.7.3
RELEASE_0.7.2
RELEASE_0.7.1
RELEASE_0.7.0
RELEASE_0.6.9
RELEASE_0.6.8
RELEASE_0.6.7
RELEASE_0.6.6
RELEASE_0.6.5
RELEASE_0.6.4
RELEASE_0.6.3
RELEASE_0.6.2
RELEASE_0.6.1
RELEASE_0.6.0
RELEASE_0.5.9
RELEASE_0.5.8
RELEASE_0.5.7
RELEASE_0.5.6
RELEASE_0.5.5
RELEASE_0.5.4
RELEASE_0.5.3
RELEASE_0.5.2
RELEASE_0.5.1
RELEASE_0.5.0
RELEASE_0.4.9
RELEASE_0.4.8
RELEASE_0.4.7
RELEASE_0.4.6
RELEASE_0.4.5
RELEASE_0.4.4
RELEASE_0.4.3
RELEASE_0.4.2
RELEASE_0.4.1
RELEASE_0.4.0
RELEASE_0.3.9
RELEASE_0.3.8
RELEASE_0.3.7
RELEASE_0.3.6
RELEASE_0.3.5
RELEASE_0.3.4
RELEASE_0.3.3
RELEASE_0.3.2
RELEASE_0.3.1
RELEASE_0.3.0
RELEASE_0.2.9
RELEASE_0.2.8
RELEASE_0.2.7
RELEASE_0.2.6
RELEASE_0.2.5
RELEASE_0.2.4
RELEASE_0.2.3
RELEASE_0.2.2
RELEASE_0.2.1
RELEASE_0.2.0
RELEASE_0.1.9
RELEASE_0.1.8
RELEASE_0.1.7
RELEASE_0.1.6
RELEASE_0.1.5
RELEASE_0.1.4
RELEASE_0.1.3
RELEASE_0.1.2
RELEASE_0.1.1
RELEASE_0.1.0
RELEASE_0.0.9
RELEASE_0.0.8
RELEASE_0.0.7
RELEASE_0.0.6
RELEASE_0.0.5
RELEASE_0.0.4
RELEASE_0.0.3
RELEASE_0.0.2
RELEASE_0.0.1
Labels
Clear labels   
awaiting user feedback

   
bug

   
cmake

   
cmake

   
docs

   
feature request

   
in progress

   
long term

   
medium term

   
medium term

   
pull-request

Mirrored from GitHub Pull Request

  
question

   
question

   
ready to close

   
short term

   
under investigation

   
wontfix
No labels
awaiting user feedback
bug
cmake
cmake
docs
feature request
in progress
long term
medium term
medium term
pull-request
question
question
ready to close
short term
under investigation
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/libxlsxwriter#152
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?