excel_reader 2.0.2 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142

#[cfg(feature = "serde")]
use serde::Serialize;

use crate::raw::drawing::{scene::rotation::XlsxRotation, st_types::st_angle_to_degree};

use super::camera::PresetCameraValues;

/// https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.drawing.rotation?view=openxml-3.0.1
///
/// Example:
/// ```
/// <a:rot lat="0" lon="0" rev="6000000"/>
/// ```
#[cfg_attr(feature = "serde", derive(Serialize))]
#[derive(Debug, PartialEq, Clone)]
pub struct Rotation {
    /// long: longitude coordinate, (x rotation)
    pub x_rotation: f64,

    /// lat: latitude coordinate (y rotation)
    pub y_rotation: f64,

    /// rev: revolution about the axis as the latitude and longitude coordinates
    ///
    /// - z rotation in terms of 3d rotation
    /// - angle in terms of lighting
    pub z_rotation: f64,
}

impl Rotation {
    pub(crate) fn from_light_rig(raw: Option<XlsxRotation>) -> Self {
        let Some(raw) = raw else {
            return Self {
                x_rotation: 0.0,
                y_rotation: 0.0,
                z_rotation: 0.0,
            };
        };
        return Self {
            x_rotation: st_angle_to_degree(raw.clone().long.unwrap_or(0)),
            y_rotation: st_angle_to_degree(raw.clone().lat.unwrap_or(0)),
            z_rotation: st_angle_to_degree(raw.clone().rev.unwrap_or(0)),
        };
    }
    pub(crate) fn from_camera(
        raw: Option<XlsxRotation>,
        preset: Option<PresetCameraValues>,
    ) -> Option<Self> {
        if let Some(rot) = raw {
            return Some(Self {
                x_rotation: st_angle_to_degree(rot.long.unwrap_or(0)),
                y_rotation: st_angle_to_degree(rot.lat.unwrap_or(0)),
                z_rotation: st_angle_to_degree(rot.rev.unwrap_or(0)),
            });
        }
        let Some(preset) = preset else {
            return None;
        };
        match preset {
            PresetCameraValues::IsometricBottomDown => Self::build_self_helper(314.7, 35.4, 299.8),
            PresetCameraValues::IsometricBottomUp => None,
            PresetCameraValues::IsometricLeftDown => Self::build_self_helper(45.0, 35.0, 0.0),
            PresetCameraValues::IsometricLeftUp => None,
            PresetCameraValues::IsometricOffAxis1Left => Self::build_self_helper(64.0, 18.0, 0.0),
            PresetCameraValues::IsometricOffAxis1Right => Self::build_self_helper(334.0, 18.0, 0.0),
            PresetCameraValues::IsometricOffAxis1Top => Self::build_self_helper(306.5, 301.3, 57.6),
            PresetCameraValues::IsometricOffAxis2Left => Self::build_self_helper(26.0, 18.0, 0.0),
            PresetCameraValues::IsometricOffAxis2Right => Self::build_self_helper(296.0, 18.0, 0.0),
            PresetCameraValues::IsometricOffAxis2Top => Self::build_self_helper(53.5, 301.3, 302.4),
            PresetCameraValues::IsometricOffAxis3Bottom => None,
            PresetCameraValues::IsometricOffAxis3Left => None,
            PresetCameraValues::IsometricOffAxis3Right => None,
            PresetCameraValues::IsometricOffAxis4Bottom => None,
            PresetCameraValues::IsometricOffAxis4Left => None,
            PresetCameraValues::IsometricOffAxis4Right => None,
            PresetCameraValues::IsometricRightDown => None,
            PresetCameraValues::IsometricRightUp => Self::build_self_helper(315.0, 35.0, 0.0),
            PresetCameraValues::IsometricTopDown => None,
            PresetCameraValues::IsometricTopUp => Self::build_self_helper(314.7, 324.6, 60.2),
            PresetCameraValues::LegacyObliqueBottom => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::LegacyObliqueBottomLeft => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::LegacyObliqueBottomRight => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::LegacyObliqueFront => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::LegacyObliqueLeft => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::LegacyObliqueRight => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::LegacyObliqueTop => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::LegacyObliqueTopLeft => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::LegacyObliqueTopRight => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::LegacyPerspectiveBottom => Self::build_self_helper(0.0, 20.0, 0.0),
            PresetCameraValues::LegacyPerspectiveBottomLeft => None,
            PresetCameraValues::LegacyPerspectiveBottomRight => None,
            PresetCameraValues::LegacyPerspectiveFront => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::LegacyPerspectiveLeft => Self::build_self_helper(20.0, 0.0, 0.0),
            PresetCameraValues::LegacyPerspectiveRight => Self::build_self_helper(340.0, 0.0, 0.0),
            PresetCameraValues::LegacyPerspectiveTop => Self::build_self_helper(0.0, 340.0, 0.0),
            PresetCameraValues::LegacyPerspectiveTopLeft => None,
            PresetCameraValues::LegacyPerspectiveTopRight => None,
            PresetCameraValues::ObliqueBottom => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::ObliqueBottomLeft => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::ObliqueBottomRight => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::ObliqueLeft => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::ObliqueRight => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::ObliqueTop => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::ObliqueTopLeft => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::ObliqueTopRight => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::OrthographicFront => None,
            PresetCameraValues::PerspectiveAbove => Self::build_self_helper(0.0, 340.0, 0.0),
            PresetCameraValues::PerspectiveAboveLeftFacing => None,
            PresetCameraValues::PerspectiveAboveRightFacing => None,
            PresetCameraValues::PerspectiveBelow => Self::build_self_helper(0.0, 20.0, 0.0),
            PresetCameraValues::PerspectiveContrastingLeftFacing => {
                Self::build_self_helper(43.9, 10.4, 356.4)
            }
            PresetCameraValues::PerspectiveContrastingRightFacing => {
                Self::build_self_helper(316.1, 10.4, 3.6)
            }
            PresetCameraValues::PerspectiveFront => Self::build_self_helper(0.0, 0.0, 0.0),
            PresetCameraValues::PerspectiveHeroicExtremeLeftFacing => {
                Self::build_self_helper(34.5, 8.1, 357.1)
            }
            PresetCameraValues::PerspectiveHeroicExtremeRightFacing => {
                Self::build_self_helper(325.5, 8.1, 2.9)
            }
            PresetCameraValues::PerspectiveHeroicLeftFacing => None,
            PresetCameraValues::PerspectiveHeroicRightFacing => None,
            PresetCameraValues::PerspectiveLeft => Self::build_self_helper(20.0, 0.0, 0.0),
            PresetCameraValues::PerspectiveRelaxed => Self::build_self_helper(0.0, 309.6, 0.0),
            PresetCameraValues::PerspectiveRelaxedModerately => {
                Self::build_self_helper(0.0, 324.8, 0.0)
            }
            PresetCameraValues::PerspectiveRight => Self::build_self_helper(340.0, 0.0, 0.0),
        }
    }

    fn build_self_helper(x: f64, y: f64, z: f64) -> Option<Self> {
        return Some(Self {
            x_rotation: x,
            y_rotation: y,
            z_rotation: z,
        });
    }
}